Sample Condition Statements
The following
are sample condition statements and each of these can be used in combination
with each other or with other not listed criteria.
User that need more in depth help creating conditional statements, please contact .
- To
select only accounts with a specific court code: For
example: court
ABC
CTCODE='ABC'
- To select accounts with
below a certain balance: For
example: Accounts
under $5000
DBALI<5000
- To select accounts with
a filing date:
FilingDate>0
- To select accounts with
a certain status code: For
example Status Code 010
Status='010'
- To select accounts for
a court code that starts with 2 characters: For
example: Any Court that starts with AB
(Copy(CTCODE,1,2)='AB')
- To
select accounts with a certain action code due today or in the past: For
example: Action Code FW
(LActDate[FW]<=Date) and (LActDate[FW]>0)
- To
select accounts with a court in a certain county: For
example: Court
County of Henrico
CTCounty='Henrico'
- To
select accounts with a court in a certain county and the county in all
in uppercase: For example Court County of HENRICO
UPPERCASE(CTCounty)='HENRICO'
- To
select accounts with a type of Retail, status code either 010, 011 or
012 and has a court county of Henrico:
DETYPE='RETAIL' and (status code='010' or
status code='011' or status code='012') and CTCounty='Henrico'
For more in depth help in creating condition statements, please contact .