Creating and Publishing a Fixed Selection Query

Fixed queries are used in conjunction with dynamic queries. If configured, an audit coordinator can choose which type of query to use when generating the list of cases for an audit. Page names do not have to be specified when creating fixed queries. This is because fixed queries are predefined. As such, audit coordinators are not required to enter any parameters for selection criteria that make up the query; therefore the pages to display the selection criteria are not required.

Otherwise, fixed queries are created similarly to dynamic queries, with an SQL statement that is validated using selection criteria. Once published, the administrator can then associate the fixed query with a case audit configuration. An audit coordinator can choose any fixed query that has been configured for a case audit. When run as part of the case list generation of an audit plan, this will return a list of cases for the audit coordinator in the runtime application.

An administrator can associate one or more fixed queries with a case audit configuration.