Dell Vizioncore Podręcznik Użytkownika Pobierz pdf (Strona 87)

Queries 87

Creating a Query in vFoglight

Removing an Order By key

To remove an Order By key:

• Click the button.

Where

The Where property restricts which data objects are selected by the query, based on

criteria such as property values in the data objects.

Note In SQL, the property and its parts are also called Where clauses.

Adding a Where Clause

To add a Where clause:

Click the button under Where.

A popup appears, displaying the following types of conditions:

• Comparison

•Is Set

• Sub Type is

•And

•Or

•Not

Select a type and the fields that define the condition are displayed.

Any condition evaluates to either true or false. The conditions in the Where

clause are evaluated for each data object found by the query. That data object is

included in the final results only if the condition evaluates to true.

Removing a Where Clause

To remove an entire where clause:

• Click the button to the right of the section you want to remove.

Conditional Types

You can configure the following different types of conditions.

1 2 ... 82 83 84 85 86 87 88 89 90 91 92 ... 167 168

Brak uwag

Dell Vizioncore Podręcznik Użytkownika Strona 87