Skip to main content
OnCommand Workflow Automation 5.0
A newer release of this product is available.

Add Cache Query dialog box


The Add Cache Query dialog box enables you to create a new cache query for a dictionary entry and associate the query with a data provide type, such as a specific OnCommand Unified Manager version.

  • Dictionary Entry

    Enables you to select a dictionary entry for which you want to create a cache query.

  • Entity Version

    Enables you to enter the version number for the cache query in major.minor.revision format—​for example, 1.0.0.

  • Data Source Types

    Enables you to select the data source types you want to associate with the cache query—​for example, OnCommand Unified Manager_6.0.

Table Structure

  • Attributes tab

    Displays the attributes associated with the dictionary entry.

  • Create Table SQL tab

    Displays the Create Table script for that dictionary entry.

SQL select query

Enables you to enter the SQL select query that retrieves data from the table of the specified data provider.

Command buttons

  • Test

    Enables you to test the SQL query entered in the SQL select query field.

  • Save

    Saves the cache query and closes the dialog box.

  • Cancel

    Cancels changes, if any, and closes the dialog box.