The DSM Explorer › Queries Folder › Create a New Query › Add Advanced Argument Dialog

Add Advanced Argument Dialog

The Add Advanced Argument dialog lets you query the asset management database fields directly. To create this type of query, you must be familiar with the asset management database, tables and field values.

Pseudo Text

Defines any text that is used as an identifier for the argument in the Query Designer dialog.

Table

Specifies all the asset management tables that you can query. You can either select the table you want to query or select Any to query all the tables.

Note: When you select Any, you must specify the where clause manually by editing the SQL statement.

Table Item

Specifies the items in the selected table.

Note: If you have selected Any in the Table field, this field is disabled.

Additional Where Clause

Specifies the conditions you want to apply. You can select the macros and fields that you want to add to the condition from the Select Macro and Select Field drop-down lists.

Note: Do not begin this clause with "Where."

Select Macro

Specifies the date macros. You can add these macros to the Additional Where clause by clicking the Up arrow button next to this field.

Select Field

Specifies the field on which you want to specify the condition.

More information:

Query Designer Dialog