Add Condition Row
Condition Rows allow users defining the basic filters or constraints that will narrow down the data retrieved from the main entity. Condition Rows act similarly to the WHERE clause in an SQL query, allowing the specification of the exact criteria that need to be met for a record to be included in the query results.
Steps to Add Simple Conditions
Navigate to the Query Builder
Ensure that the Query Builder tab is selected when configuring the query.
The Main Entity Component should already be visible and will serve as the basis for adding conditions.
Initiate the Process
Click the Add Row icon in the header of the Main Entity Component.
This will add a new row for the condition below the entity's main section.
Select a Property
In the newly added condition row, click the Select Property dropdown to choose a property from the entity. This property represents the field that will be evaluated by the condition.
Example: For an Employee entity, properties might include Name, Hire Date, Department, or Salary.
Select an Operator
After selecting a property, choose the Operator that defines the relationship between the property and the value. Operators can include:
=
<>
Contains
Starts With
Does Not Start With
Ends With
Does Not End With
In
Not In
Example: When filtering employees by salary, the >= operator can be used to find employees whose salary is above a certain value.
Enter or Select a Value
Input the Value that the property will be compared against. The value type will depend on the selected property and operator:
Click the Expression button (fx) to use the Expression Assistant to build expressions or formulas, enabling advanced calculations and logic.
Add Multiple Conditions (Optional)
If the query requires more than one condition, click the Add Condition icon again to create additional rows.
Conditions are combined using AND logic by default, meaning all conditions must be true for the record to be included in the results.
The logical operator between conditions (e.g., switching from AND to OR) can be changed by adjusting the connector between rows.
Example:
Suppose you're querying the "Employee" entity to find all employees who:
Were hired after January 1, 2020.
Work in the "Engineering" department.
Steps:
Select the Hire Date property, choose the >= operator, and input "anuary 1, 2020 as the value.
Add another condition, select the Department property, choose the = operator, and enter Engineering as the value.
The query will now only return employees in the Engineering department who were hired after January 1, 2020.
Last updated