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.

Edit area

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.

Operator buttons

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, Param1, and Param2 are Boolean parameters.

Scope tree

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.

Description area

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.

Verify button

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.

OK button

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.

Cancel button

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.

Help button

The Help button opens a contextual topic of Service Studio help.

See Also

Simple Query Editor