Here are some record filter examples.
PPANKey>4800
*You must use ( ) because PPAN is text due to leading zeroes.
PPAN>(00014104)
SchoolDist='CLF30
'
SchoolDist in ('CLF30', 'CLF20')
*Must use % as wild card.
Upper(PPAN.PublicComments) like '%2012 NO TAXPAYER RESPONSE - ESTIMATED%
'
AssessYear=2008 AND AssessDate='08/14/2008' AND ChangedBy='JAS'
PPAN.AssessYear=2008 AND PPAN.AssessDate>='8/2/2008' AND PPAN.ChangedDate ⇐ '8/15/2008 23:59:59' AND PPAN.ChangedBy='JAS
'
PPAN.BusinessType like '%LEASE VEHICLE%
'
PPAN.AssessYear=2009 AND PPAN.Status='ACTIVE' AND PPAN.TotalAssessedValue>=150000
PPAN.AssessYear=2008 AND Left(PPAN.BusinessType,14) = 'NEW BUSINESS
'
AssessYear=2009 AND Status='ACTIVE' AND PropType='C' AND BusinessType like '%LEASE%' AND AssessName like '%WHEELS%'
(RPTvwAssessments.AssessYear=2010and not PRTvwAssessments.PPANKey in (select Property.PPANKey from Property where RPTvwAssessments.PPANKey=Property.PPANKey and year(Property.AssessDate)=2010))
PPAN.TaxpayerID is null AND PPAN.AssessYear=2008
PPAN.AssessYear=2009 AND PPAN.AssessDate>='03/13/2009' AND PPAN.ChangedDate >= '03/01/2009 00:00:00' AND PPAN.ChangedDate ⇐ '03/19/2009 23:59:59' AND PPAN.ChangedBy='JKP
'
PPAN.AssessYear=2009 AND PPAN.ChangedDate ⇐ '12-31-2009 23:59:59' AND not Upper(PPAN.OfficeComments) like '%BUSINESS FORM TO CUSTOMER%' AND not PPAN.BusinessType like '%LEASE%
'
AssessYear=2006 AND BusinessType='UTILITY' AND AssessDate>='01/01/2006' AND AssessDate⇐'12/31/2006' AND Status='ACTIVE
'
PPAN.AssessYear=2008 AND PPAN.AssessDate>='1/12/2008' AND PPAN.ChangedDate ⇐ '1/25/2008 23:59:59' AND PPAN.ChangedBy='RHE
'
PPAN.AssessYear=2008 AND PPAN.AssessDate>='11/12/2008' AND PPAN.ChangedDate >= '11/12/2008 00:00:00' AND Left(PPAN.AssessName,1) = 'O' AND PPAN.ChangedBy='JKP
'
PPAN.BusinessType like '%LEASE%
'
not PPAN.BusinessType like '%LEASE%
'
PPAN.TaxpayerID is null AND PPAN.AssessYear=2006
PPAN.AssessYear=2011 AND PPAN.PPANType='U
'
AssessYear>=2008 AND AssessName is not null AND ChangedDate is not null
PPAN.AssessYear=2008 AND PPAN.SchoolDist='082' AND PPAN.TotalAssessedValue>50000
999999 < (select sum(Property.AssessedValue) from Property where PPAN.PPANKey = Property.PPANKey) and PPAN.PPANType <> 'P
'
AssessYear=2007 AND PropType='2001 TOYOTA TUNDRA
'
PPAN.TaxpayerID is null AND PPAN.AssessYear=2007
PPAN.AssessName like '%D L PETERSON%' AND PPAN.Status='ACTIVE
'