Page History

Condition Builder The condition builder is a tool that allows creating conditions to collect users to create conditions for collecting fields formed dynamically and setting multiple conditions for specific request, depending on the context.

The Condition Builder 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 consisting that consists of table fieldscolumns. You can choose fields from navigate to the columns of the related tables using dot-walking.

The Operator part is a choice list consisting that consists of different set sets of operators depending on a . 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 's is a field of Booleanfield type. But you can use this use this operator to any field any field of a number type.

The Value part is a text field, or a set of text fields set, or a choice list, depending on a chosen field and operator. For example, for the Active field of a Boolean type, the value area will be displayed as a choice list with the options displayed: '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 Condition Builder 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. Available It is only available on the lists only.
• Run – runs the configured condition to apply the filter. Available It is only available on the lists only.
• Close – hides the condition builder. Available It is only available on the lists only.
• Clear All – deletes All – deletes defined conditions.

Breadcrumbs

Anchor
breadcrumbs breadcrumbs

In SimpleOne,  Breadcrumb Navigation the breadcrumb navigation is an element of the interface that display all applied conditions for filtering. You can see Breadcrumbs the breadcrumbs above the Condition Builder 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 one, you need to click on the filter that you want 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 condition builder toolbar or by applying actions Show Matching, Filter Out, and Group By one one more time. All You can see all applied conditions you can see in Breadcrumbs Navigationin 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, please complete the steps below:

1. Navigate to the list you need. 
2. Right-click on the value of any field and open the context menu.
3. Select the necessary action.

Condition

string

Condition The condition string describes conditions , that are applied to the table fields , combined with the AND and OR operators. It is generated automatically by the condition builder. It can be seen is used in the URL in the condition parameter, after filtering 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:

a₀^a₁^a₂^...^a_n,  or a₀^ORa₁^ORa₂^OR…^ORa_n

Where a_n – are the same condition strings bracketed.

Special symbols

The complex expressions can be built using AND/OR operators; to prevent collisions, elementary expressions inside the complex one are bracketed.

Node conditions

The node conditions can be represented like described below:

<attribute><operator><values>

<attribute> – the table attribute (that is system name of the field). Dot-walking attributes can be used, for example, assigned_user.id.company.name.

<operator> – the operator available to use with the selected <attribute>.

<values> – the set of the values (operands) divided by "@".

JavaScript injections

The <values> field also supports so called JavaScript injections, so you can specify a JavaScript short scenario in case the <values> field is of one of the text input types. This scenario will be interpreted, and its results will be returned as a search value.

To use this functionality, add a JS injection into a <values> field in a following format:

javascript: script_text

Image Removed

You can also use include scripts in this injections. To use an include script there, follow instructions in the Script Includes article (write a script and invoke it using the ss.importIncludeScript method). The script maximum length is limited up to 255 symbols.

The example of include script in injections is provided below: