The condition builder is a tool that allows users to create conditions for collecting fields formed dynamically and setting multiple conditions for specific request, depending on context.
The condition builder helps users to filter lists, create ACL and Business Rules, etc.
Condition format
The condition consists of three parts:
- Field
- Operator
- Value
The Field part is a choice list that consists of table columns. You can navigate to the columns of the related tables using dot-walking.
The Operator part is a choice list that consists of different sets of operators. The sets depend on a field type. For example, in the Task table, you cannot apply the greater than operator to the Active field, since it is a field of Boolean type. But you can use this operator to any field of number type.
The Value part is a text field, a set of text fields, or a choice list, depending on a chosen field and operator. For example, for the Active field of Boolean type, the value area will be displayed as a choice list with the options: false and true. For the Description field, the value area is an input text field.
Condition builder actions
Click on the funnel sign 
to call the condition builder toolbar.
- AND – tells the database that search items should contain the condition necessarily. If you apply two or more conditions with AND, you will see only those records, that meet all of these conditions.
- OR – tells the database that any of the specified conditions will be acceptable. You can add high-level conditions using these buttons in the condition builder toolbar. If you apply two or more conditions with OR, you will see the records, that meet at least one of these conditions.
Other available actions:
- Sort – adds conditions of the fields sorting in descending and ascending order.
- Group – adds conditions of the fields, grouping and sorting in descending and ascending order by Name and Count. Available on lists only.
- Save – saves the configured conditions. Before saving, be sure to enter the name for the filter. It is only available on the lists.
- Run – runs the configured condition to apply the filter. It is only available on the lists.
- Close – hides the condition builder. It is only available on the lists.
- Clear All – deletes defined conditions.
Breadcrumbs
In SimpleOne, the breadcrumb navigation is an element of the interface that display all applied conditions for filtering. You can see the breadcrumbs above the condition builder toolbar, near the funnel sign
.
You can reset applied conditions by clicking on arrows 
to delete unnecessary filters.
To delete all filters but one, you need to click on the filter that you need to keep.
Quick filtration
Show Matching, Filter Out, and Group By are three quick ways to filter elements. After applying one of these filters, you can also add more conditions in the condition builder toolbar or by applying actions Show Matching, Filter Out, and Group By one more time. You can see all applied conditions in the breadcrumbs.
It is convenient to use Quick Filtration, if you need to apply one condition without any details. Use Condition Builder toolbar, if you need to apply several conditions with details.
- Show Matching – displays elements that contain the same parameter. It corresponds with positive and AND operators.
- Filter Out – eliminates all elements with one certain parameter. It corresponds with negative operators, for example, is not, does not, etc.
- Group By – collects all elements with the same parameters. As a result, you will see groups based on the condition and the number of elements in each group. It is the same operator as Group in Condition Builder toolbar. You can navigate to each group to see the records and also Open a group in the list.
To process the filtering, complete the steps below:
- Navigate to the list you need.
- Right-click the value of any field and open the context menu.
- Select the necessary action.
Condition string
The condition string describes conditions that are applied to the table fields with the AND and OR operators. It is generated automatically by the condition builder. It is used in the URL in the condition parameter, after the list is filtered. Also, it can be created manually in scripts.
The condition string does not contain the table name related to this condition. So when using it, take the table to filter out into account.
The condition string is represented as described below:
a0^a1^a2^...^an, or a0^ORa1^ORa2^OR…^ORan
Where an – are the same condition strings bracketed.
Special symbols
| Symbol | Description |
|---|---|
| ^ | AND operator. |
| ^OR | OR operator. |
| ^ORDERBY | The ascending sorting. |
| ^ORDERBYDESC | The descending sorting. |
| @ | Values delimiter in the <values> section. |
The complex expressions can be built using AND/OR operators; to prevent collisions, elementary expressions inside the complex one are bracketed.
