Skip to main content

[en] Knowledge Center

[en] Filtering in RamBase

[en] Built-in Filters

[en] You can use the built-in filters in any application. To do so, select filter_funnel.svg at the right of the search field, if the search field is given. Select the filter to apply in the popup that appears. Every application has a different set of filters. Select X in the filter label to remove the filter.


[en] Select the spacebar with focus in the search field to view a list of available fields to filter on. Select the down and up arrow keys to navigate to the necessary filter and select the Enter key to apply the filter. A popup appears with filter query expressions, the descriptions are given in the table below. Once you select the expression, there is an And, Or and Orderby operator option available which enables you to add another field to the filter. When finished building your filter query, select the Enter key and the filtered result is displayed.


[en] RamBase supports the following operators for filter expressions

[en] Operator

[en] Meaning

[en] Example


[en] Equal to

[en] PART="ABC"

[en] <>

[en] Not equal to

[en] PART<>"ABC"


[en] Greater than

[en] PART>100


[en] Less than

[en] PART<100

[en] >=

[en] Greater than or equal to

[en] PART>=100

[en] <=

[en] Less than or equal to

[en] PART<=100


[en] And

[en] PART="ABC",PRICE>100


[en] Begins with


[en] RamBase supports the following wild cards

[en] Wild cards can be used in certain filter expressions to substitute for one, or several unspecified characters in the expression.

[en] Wild card

[en] Meaning

[en] Example


[en] Zero, one, or more than one unspecified characters

[en] PART="ABC*" (Will give all PARTs beginning with ABC)


[en] One unspecified character

[en] PART="ABC?" (Will give all PARTs made up of 4 characters beginning with ABC)

[en] Note that wild cards, especially when placed at the start of the expression (TEXT="*ABC"), may increase the response time in some situations. In these cases you should consider if the same search can be done without using a leading wild card.

[en] Avoid using wild cards in expressions that use ‘>’ (Greater than) ‘<’ (Less than), ‘>=’ (Greater than or equal to) and ‘<=’ (Less than or equal to), as this will behave differently depending on the type of field the filter is set against and the result may not be obvious.

[en] Filtering on DATE- and PERIOD-fields

[en] Task

[en] Operators

[en] Examples

[en] Filter by specific date or specific date interval

[en] ‘=’,’>’,’<’,’>=’,’<=’,’<>’

[en] DATE="2015.01.01"

[en] DATE>="2015.01.01"

[en] DATE>="2015.01.01",DATE<="2015.01.31"

[en] Filter by year


[en] DATE="2015*" (All of 2015)

[en] Filter by month


[en] DATE="2015.01*" (All of January 2015)

[en] Filter by week


[en] DATE="*1501" (Week 1 of 2015)

[en] Filter by period


[en] PERIOD="201501"

[en] Filtering on NUMBER-fields

[en] Task

[en] Operators

[en] Examples

[en] Select all that are equal to a given number

[en] ‘=’

[en] PRICE=100

[en] Select all that are greater than a given number

[en] ‘>’

[en] PRICE>100

[en] Select all that are greater or equal to a given number

[en] ‘>=’

[en] PRICE>=100

[en] Select all that are less than a given number

[en] ‘<’

[en] PRICE<100

[en] Select all that are less or equal to a given number

[en] ‘<=’

[en] PRICE<=100

[en] Select all that are not equal to a given number

[en] ‘<>’

[en] PRICE<>100

[en] Select all that have a value

[en] ‘>’

[en] PRICE>0

[en] Filtering on TEXT-fields

[en] Upper- and Lower-case are not differentiated when filtering on TEXT-fields.

[en] Spaces will be taken into account, so for instance filtering on TEXT="INKPRINTER" will cause "INK PRINTER" to be left out of the result.

[en] If using ‘>’ (greater than) or ‘<’ (less than) in a filter, this will filter the TEXT based on a character for character basis. Take care if using ‘>’ or ‘<’ against TEXT fields that contain numbers as this may not behave as expected.

[en] For instance, if filtering on TEXT>"1000" this would also include results where TEXT is "12". As TEXT-fields are compared on a character for character basis, the second character here will decide that 2 is greater than 0 and therefore include this in the result.

[en] Task

[en] Operators

[en] Examples

[en] Select all that are equal to a given value

[en] ‘=’


[en] Select all that contain a certain value somewhere in the text

[en] ‘=’

[en] TEXT="*PRINT*"

[en] Select all that start with a certain value

[en] ‘=’

[en] TEXT="INK*"

[en] Select all that have no value

[en] ‘=’

[en] TEXT=""