Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »


Some system queries may need parameters to execute. Each system query has its parameters predefined and will prompt for values for the current execution.


You can use the Define Query Parameters dialog when running a query in the following cases:

  1. Run query(s) that has parameter(s) by design from Queries screen. The same for such queries within group if user run group from Groups screen
  2. Run Action Rule (which run query with parameter(s)) without mapping parameter(s)
  3. On adding Schedule which include such group(s) where assigned query has parameter(s). And It can be shown on edit schedule if user needs to redefine parameter value(s)

 

Query parameters usage and definition for custom queries:

Parameters are used in query text in next format - :parameter_name:




Parameter Types

Several types of query parameters are available:

  • User entered single parameter. Enter an integer or a character string.
  • Date value. Specify the requested date via the Eagle date selector.
  • Selection list. Select one or more entries from the check boxes.

Sample Single Parameter

The following is a sample user entered single parameter:

Sample Date Value Parameter

The following is a sample date value parameter:

Sample Selection List Parameter

The following is a sample selection list parameter:

With selection lists, you may check one, several, or all check boxes from the list.

One value:

Several values:

All values (by checking the top box):

back to top

  • No labels