Filter Statement Basics

  • Updated

Applies to: Version 5.0
For Version 4.0, please click here to download three (3) PDFs with instructions.

PastPerfect 5.0’s Query, Report Maker, and Lists screens have drop down options to help you build filter statements quickly. However, there may be times where you need to modify filter statements to meet your needs.

Below are some of the components of filter statements that you may see in a filter statement. For field names, check your Field Descriptions reports in PastPerfect or online at https://museumsoftware.com.

NOTE: CHARACTER/MEMO fields (such as Object Name, Object ID, Contact Names, Zip Codes, Descriptions and Notes) require "quotes" or [brackets] around the searched text. NUMERIC fields (such as donation or dues amounts) do not need quotes.

 

  • Equals
    • STATE="PA"
    • DONATIONS=1000
  • Begins With
    • ZIP="193"
    • OBJECTID="2003.12."
  • Not Equal To
    • STATE#"PA"
    • EARLYDATE#1942
  • Greater Than
    • CATDATE>CTOD([01/01/2000])
    • NEXTDUE>CTOD("12/31/2017")
  • Less Than
    • DUES<500
  • Greater Than or Equal To
    • DUES>=500
  • Between
    • DUES>=50 and DUES<=500
  • Contains
    • "Hilton"$DESCRIP [San]$CITY
  • Does Not Contain
    • !"RANCH"$DESCRIP ![FAMILY]$TYPE
  • Check Box Fields
    • Checked boxes are TRUE, unchecked boxes are FALSE, except for the two numeric fields mentioned in the next bulletpoint
    • DECEASED=.T. VOLUNTEER=.F.
  • Numeric Check Box Fields
    • Bill to Members / Include on Overdue List
      • 0 = EMPTY
      • 1 = BILLING Member / YES on Overdue list
      • 2 = NON-BILLING member / NO on Overdue List
    • BILLMEMBER=1
    • ACTIVE=2
  • Dates
    • CTOD() Changes Characters to Dates. Best used for searching in date-formatted fields.
    • LASTPAID>=CTOD("01/01/2010")

 

Related Article(s)

Attachment(s)