Queries Folder

The Catalog folder \\Public\Meridium\Modules\Management Of Change\Queries contains the following items.

Query Name	Behavior and Usage
All Change Projects	Returns the list of Change Projects. This query is used when you select the Change Projects tab on the MOC Overview page.
All MOC Tasks	Returns the list of Operations Tasks. This query is used when you select the Tasks tab on the MOC Overview page.
All Exceptions Admin Query	Returns the list of Exceptions available in the database. This query is used when you select the Exceptions tab on the MoC Admin page.
Change Project Checklist Query	Returns the list of Checklists associated with a Change Project. This query is used when you select the Checklists tab in the pane to the left of the Project Summary workspace.
Checklist Questions Query	Returns the list of Questions associated with a Checklist. This query is used when you select the Checklist Items tab for a Checklist on the MoC Admin page.
Exception Graph Query	This query is used to create the Exception Summary Graph, which appears in the Summary section in the Project Summary workspace of a Change Project.
Exceptions Admin Query	Returns the list of Exceptions assigned to a specific site. This query is used while creating Questions, when you search for an Exception to associate with an Answer Option.
MOC All Checklist Admin Query	Returns the list of Checklists available in the database. This query is used when you select the Checklists tab on the MoC Admin page.
MOC Checklists Admin Query	Returns the list of Checklists assigned to a specific site. This query is used when you add Checklists to a Change Project.
MOC Questions Admin Query	Returns the list of Checklist Questions available in the database. This query is used when you select the Questions tab on the MoC Admin page.
Remaining Questions	Returns the list of Questions that belong to the same site as that of the Checklist and that are not associated with any Checklist. This query is used to display results on the Select questions to add window, which appears when you add Questions to a Checklist.
Task states count query	This query is used to display the number of tasks in each state available for the Operations Task family.
Task Summary Graph Query	This query is used to create the Task Summary Graph, which appears in the Summary section in the Project Summary workspace of a Change Project.
Answered Count by Checklist	This query is used to calculate the number of Questions that are answered in a Checklist.
Unanswered Count by Checklist	This query is used to calculate the number of Questions that have not been answered in a Checklist.
Exceptions Triggered by Change Project	This query is used to calculate the number of Exceptions that have been created based on your responses in a Checklist for a Change Project.