Service Studio 6.0 Help
Query Condition Editor
The Query Condition Editor Show picture allows you to type and edit the conditions of a Simple query.
The areas and elements available in the Query Condition Editor are presented below.
The top window pane. In this area, you edit your condition by:
Typing the condition expression directly.
Right-click on the typed condition expression and select the "Complete Word" or use CRTL + Space to complete your expression. Service Studio provides you a drop-down list with the possible elements, based on what you typed so far. Therefore you don't have to actually type the complete expression.
In addition, if you want to use an Entity or a Structure, select respectively, the Entity or Structure name followed by "." and Service Studio automatically displays a drop-down list with the attributes.
In this situation, the attribute you selected in the drop-down list is automatically highlighted in the Scope tree and you can check its definition and help text.
Using the operator buttons and the elements in the Scope tree, such as Entities, Structures, Parameters or Built-in Functions.
If you want to check the definition or the help text of any element, place the cursor over the element, right-click and then select the Synchronize Scope Tree option or simply press CTRL + K.
Note that your condition must be valid boolean expression.
Numeric, logical, and comparison operators. The parenthesis allows you to define the priority order. The LIKE operator tests whether a text expression matches a give pattern.
If you are using Boolean parameters, you must pay attention to some SQL limitations that generate an error message and cause the eSpace to not be valid (An eSpace is valid when all expressions are correctly defined and Verify operation issues no errors.). The issue is that the Boolean parameters must be used together with the comparison (=) operator:
Param = true
not (Param = true)
Param1 and Param2
(Param1 = true) and (Param2 = true)
Param1 or Param2
(Param1 = true) or (Param2 = true)
Param, Param1, and Param2 are Boolean parameters.
In this area you can access all the elements that can be used in your condition in the current scope; these elements are organized by folders. The elements that you can use in a query condition are: query parameters, entities that you've added to the query, and some of the provided built-in functions.
This area contains the description for the currently selected element which is the value of the Description property of the element or, in the case of the built-in functions, a description automatically provided by Service Studio that includes:
the data type of the function output,
a description of the function.
a list of the input parameters, their Is Mandatory and Data Type properties, as well as their Description property if not empty.
The Verify button checks whether the condition is a valid boolean expression. It checks both the syntax and the expression evaluation. In built-in function calls, it may rearrange the arguments' so they'll be ordered as in the built-in function definition. Learn more about verifying an expression.
The Ok button closes the query condition editor applying the changes that you've just performed. When evaluating a function call, it may rearrange the arguments' so they'll be ordered as in the function definition.
Instead of pressing the Ok button to accept condition changes, you can press ALT + ENTER, Shift + ENTER, or Ctrl + ENTER.
The Cancel button closes the query condition editor without applying the changes that you've just made. If you press this button you may lose work.
Instead of pressing the Cancel button to discard condition changes, you can press Esc.
The Help button opens a contextual topic of Service Studio help.
Simple Query Editor