Add a List Query

Using List Query, you can built a filter query for the lookup to fetch records. This field is enabled only if the Get all records option is selected as False in the New Repository List Lookup dialog box.

To build a query

1. In the Enterprise Console, click the Menu button, click Settings, and then click Lookup Settings. The Lookup Settings page appears.

2. Click the New Lookup List icon on the Ribbon Bar. The New Repository List Lookup dialog box appears.

3. Click the Query icon against List Query to build a filter query to get the required records.

   The Dynamic Query Builder dialog box opens.

   Field	Description
   Condition (Prefix)	Grouping prefix for the condition.
   Table	Click this text box to select the required table. The tables that are associated to a List are displayed in a tree menu. The tree menu displays the hierarchy of tables.
   Column	Select the column associated to the selected table.
   Operator	Select the available operator for creating Query.
   Type	Select the Type to display the filtered records. The available Type options are Value, Table Field, and Parameter.
   Value	When the Type is Value, the Value can be given as a string with Single quotes for a string or a number for Number type as per the Column selected. When Type is Table Field, in the Value, the table and the column can be specified. When Type is Parameter, the Value can be given as @<parameter name>.
   Condition (Suffix)	Grouping suffix for the condition with the option of specifying AND and OR operators to build multiple conditions based query.

4. Click Add to add the query.

   Multiple conditions can be specified using the Condition (Prefix) and Condition (Suffix) options.

5. Click Save to save the query.

6. Click Clear to remove the data entered in the Query Builder.