Once a grid or form view is opened from the dashboard, you will be able to click on the Filters button in the left upper corner. When you click on it, the query builder panel appears on the left side of the application.
Click on Add new (or icon) and use fuzzy-search to faster find a field or simply select a field from the list by clicking. The selected field will be added to the query builder as a search term. On the query panel, the default query operator became visible. Next to the query operator, one or two text fields appear to define the search value for each criterion. You can change the operator by clicking on the operator field and selecting the appropriate item from a dropdown list. The following query operators are available for different data types:
Numeric integer values: <, >, <>, ≤, ≥, between, empty, not empty, not in list, in list;
Numeric decimal values: <, >, between, empty, not empty ;
Text values: equals, does not equal, starts with, does not start with, ends with, does not end with, any of, none of, in list, contains, does not contain, empty, not empty;
Date values: on, today, last 7 days, last 14 days, after, before, between, last, empty, not empty .
Most of these operators take a single value. Exceptions to this rule are:
The between operator, where you have to specify the lower and the upper boundary of the interval you want to find with the search;
The in list and not in list operators both require a comma-separated list of values;
The empty and not empty operators make it possible to search for records where the value of the given field is missing or present, respectively;
The last date query operator requires a number and a value selected from a drop-down list. For example, last 5 months .
You can add new conditions to the query from the context menu as well. Left-click on the dropdown arrow of the column header in the grid, and select Add to filter.
When you finished building up the query, the search can be started either by pressing Enter or by clicking the Filter button below query conditions. Whenever you modify the query (e.g., you change the criteria or add/remove a condition), the Filter button will become available to run the search again. During searching, results are being loaded continuously into the active database view, so you can keep browsing in your data without any interruption. You can run complex query just by adding multiple fields to your query builder.
If you want to undo filtering by a certain search condition, click on the button in the top right corner of the condition to remove it from the query, and then you can run the search again. To remove all query criteria from the query builder, use icon or Clear all button.
Filter child data
The filter child data feature will present in result only relevant child data records that fit to the definition set in the query. The Filter child option in the query builder can be found next to the Clear all button. If the Filter child toggle button is turned on , only that records of the child data table appear as filtering results, which correspond to child data filtering criterion. If the toggle button is turned off , all the records of the child data table are displayed – in this case, the child data table contains at least one record which corresponds to child data filtering criterion.
The model query on the Wombat demo data below uses search for benzene substructure in the "Wombat structures" entity AND L929 cell in the "Wombat activities" entity. When the filter is turned off, three records from the "Wombat activities" table are shown in the hit list, although only one of them contains “L929 cell” value in the BIO.CELL field. The row containing “L929 cell” value is highlighted.
When the same search is repeated with the toggle button turned on, only the record from the Wombat activities table containing “L929 cell” value in the BIO.CELL field is displayed.