Filtering in RamBase(QMS)
Standard filters
In the RamBase system, there is the option to use a set of standard (pre-defined) filters or create custom filters.
To do so, locate a Search field and click on the Standard and saved filters icon to the right of the search field.
Every application has a different set of filters. Once a standard filter is selected from the popup, it will be available under the Search field. If the filter is active it will be marked with the color orange. If a filter is inactive it will be marked with the color grey. A filter can be removed by clicking the Remove filter icon next to the filter.
Icon | Description |
|---|---|
| Add filter to field icon: |
| Standard and saved filters icon |
| Reset filters icon |
| Save filter icon |
| Remove filter icon |
Custom filters
In the Add filter to field popup, the user can also create custom filters by selecting the desired fields, then the desired operators and values for each field. Click the Save filter icon, enter a name for the new custom filter and click the Save button. Saved filters are application specific and will be available from the My saved filters area of the Standard and saved filters popup. Click the intended saved filter to add it below the Search field. To edit the name of a saved filter, click the the Edit icon to the right of the filter name. To delete a saved filter, click the delete filter icon to the right of the filter name.
Quick search fields
The Quick search field is a free text search field, which allows users to search for various values associated with a field. Clicking on the Quick search field icon displays the available fields with checkboxes enabling users to select specific categories for their search.
Click the Quick search fields icon in the Search field. This popup will list all of the available fields (columns) to search through. Select the intended fields then click the Search field to type in the information you are looking for. Enter.
RAMBASE SUPPORTS THE FOLLOWING OPERATORS FOR FILTER EXPRESSIONS
Operator | Meaning | Example |
|---|---|---|
= Between < > < = > = <> Is EMPTY Not EMPTY Contains NotContains StartsWith EndsWith | Equal to Between Less than Greater than Less than or equal to Greater than or equal to Not equal to The field has no data The field contains data Only displays results that contain the described data Filters out results with the described data Only displays results that begin with the described data Only displays results that end with the described data | TITLE = "ABC" CREATED AT Between yyyy.MM.dd:yyyyy.MM.dd CREATED AT < yyyy.MM.dd CREATED AT > yyyy.MM.dd CREATED AT < = yyyy.MM.dd CREATED AT > = yyyy.MM.dd CREATED AT <> yyyy.MM.dd DESCRIPTION Is EMPTY DESCRIPTION Not EMPTY TITLE Contains "ABC" TITLE NotContains "ABC" TITLE StartsWith "ABC" TITLE EndsWith "ABC" |