Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

builder actions


Click on the funnel sign  to call Condition Builder the condition builder toolbar.

Anchor
cbtoolbar
cbtoolbar

  • 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.
Breadcrumb Navigation 

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

filtration


Show MatchingFilter 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 MatchingFilter 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 notdoes 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

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:

a0^a1^a2^...^an,  or a0^ORa1^ORa2^OR…^ORan

Where an – are the same condition strings bracketed.

Special symbols

SymbolDescription
^AND operator.
^OROR operator.
^ORDERBYThe ascending sorting.
^ORDERBYDESCThe descending sorting.
@Values delimiter in the <values> section (see the Condition Builder#Node conditions section in this acrticle for more information).

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

Tip

Use these API methods to build conditions:

Node conditions

AnchorNode conditionsNode conditions

The node conditions can be represented like described below:

Code Block
<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:

Code Block
languagejs
themeEclipse
titleJS injection
javascript: script_text

Image Removed

Info

The field supports commas ',' and line breaks (\n).

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:

Code Block
languagejs
themeEclipse
titleInclude script in injections
javascript: ss.importIncludeScript('DateTimeScript'); return getWeekStartDate();

Table of Contents
absoluteUrltrue
classfixedPosition