Ceres Filter Criteria (v5.0)

Modified on Wed, 20 Sep 2023 at 09:41 AM


Purpose of this document


The purpose of this document is to explain the symbols and expressions that can be used to filter data in Ceres. 



Ceres Object release 5.00.00 is required for the functionality described in this document. 


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 some special symbols or mathematical expressions. The following table shows the available formats.



Sample Expression

Records Displayed


Equal to


Number 377.


Those with the BLUE code, for example, the BLUE warehouse code.


A datetime: from 22-current month-current year 0:00:00 to 22-current month-current year 22:59:59.

22 10

An exact datetime: 22-01-01 10:00:00.




Numbers 1100 through 2100.


Up to and including 2500.

..12 31 00

Dates up to and including 12 31 00.


Information for accounting period 8 and thereafter.


From the beginning of time until 23-current month-current year 23:59:59.


From 23-current month-current year 0:00:00 until the end of time.


From 22-current month-current year 0:00:00 until 23-current month-current year 23:59:59.




Those with number 1200 or 1300.




Numbers that are less than 2000 and greater than 1000.

 The ampersand (&) cannot be used by itself with numbers because no record can have two numbers.


Not equal to


All numbers except 0.

 The SQL Server Option allows you to combine this symbol with a wild card expression. For example, <→A* meaning not equal to any texts that start with A.

Greater than


Numbers greater than 1200.


Greater than or equal to


Numbers greater than or equal to 1200.

Less than


Numbers less than 1200.


Less than or equal to


Numbers less than or equal to 1200.


An indefinite number of unknown characters


Texts that contain "Co".


Texts that end with "Co".


Texts that begin with "Co".


One unknown character


Texts such as Hansen or Hanson.

Calculate before rest


Those with number 30 or with a number from 10 through 20 (the result of the calculation within the parentheses).


Ignore case (either uppercase or lowercase allowed)


Texts such as LOCATION, location, or Location.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article