Skip to main content
Version: Ceres 6

Filter Criteria

The purpose of this document is to explain the symbols and expressions that can be used to filter data in Ceres 5. When you enter criteria, you can use all the numbers and letters that you can normally use in the field. In addition, you can use special symbols or mathematical expressions to further filter the results.

The following table shows the symbols which can be used in filters in Ceres.

note

There may be instances where field values contain these symbols and you want to filter on them. To do this, you must include the filter expression that contains the symbol in quotation marks (''). For example, if you want to filter on records that start with the text S&R, the filter expression is 'S&R*'.

(..) Interval​

Sample ExpressionRecords Displayed
1100..2100Numbers 1100 through 2100
..2500Up to and including 2500
..12 31 00Dates up to and including 12 31 00
P8..Information for accounting period 8 and thereafter
..21From the beginning of time until the 21st of the current month and current year at 23:59:59
21..From 21st of the current month and current year at 00:00:00 until the end of time
22..23From 22nd of the current month and current year at 0:00:00 until 23rd of the current month and current year at 23:59:59.

(|) Either/or​

Sample ExpressionRecords Displayed
12001300

(<>) Not equal to​

Sample ExpressionRecords Displayed
<>0All numbers except 0

You may combine this symbol with a wild card expression. For example, <>A* meaning not equal to any text that starts with A.

(>) Greater than​

Sample ExpressionRecords Displayed
>1200Numbers greater than 1200

(>=) Greater than or equal to​

Sample ExpressionRecords Displayed
>=1200Numbers greater than or equal to 1200

(<) Less than​

Sample ExpressionRecords Displayed
<1200Numbers less than 1200

(<=) Less than or equal to​

Sample ExpressionRecords Displayed
<=1200Numbers less than or equal to 1200

(&) And​

Sample ExpressionRecords Displayed
>200&<1200Numbers greater than 200 and less than 1200

('') An exact character match​

Sample ExpressionRecords Displayed
'man'Text that matches man exactly and is case sensitive

(@) Case insensitive​

Sample ExpressionRecords Displayed
@man*Text that starts with man and is case insensitive

(*) An indefinite number of unknown characters​

Sample ExpressionRecords Displayed
*Co*Text that contains "Co"
*CoText that ends with "Co"
Co*Text that begins with "Co"

(?) One unknown character​

Sample ExpressionRecords Displayed
Hans?nText such as Hansen or Hanson

('') Blank or empty​

Sample ExpressionRecords Displayed
''A record with no text in this field

Combined format expressions​

Sample ExpressionRecords Displayed
5999|8100..8490Include any records with the number 5999 or a number from the interval 8100 through 8490.
..1299|1400..Include records with a number less than or equal to 1299 or a number equal to 1400 or greater (all numbers except 1300 through 1399).
>50&<100Include records with numbers that are greater than 50 and less than 100 (numbers 51 through 99).