Queries

In addition to the queries described below, there are default queries for the main objects in the Change Management module. These default queries have names of the form Change - <object>, and display the Title (or Summary), Created by, and Created date fields. They have no criteria specified. Default queries that differ significantly from this are also included below.

Queries that include the Extended ID attribute (which uses the column heading of Reference) typically also include the ID or Reference Number attribute as a hidden column. This hidden attribute is used for sorting. For more information about extended IDs, see Extended IDs.

Active Changes

Purpose:	Lists all changes not at an end status
Prompts:	None
Fields displayed:	Extended ID, Creation Date, Title, Status, Current Assigned Group, Current Assigned Analyst
Criteria:	Status.Is End is equal to false

All Changes

Purpose:	Lists all changes
Prompts:	None
Fields displayed:	Extended ID, Asset ID, User, Creation Date, Status, Lifecycle, Title
Criteria:	None

All Releases

Purpose:	Lists all releases
Prompts:	None
Fields displayed:	Extended ID, Release Outline, Created On, Current Status
Criteria:	Lifecycle is equal to Release Management Process

Change – Approvals

Purpose:	Default query for Change Approvals
Prompts:	None
Fields displayed:	Name
Criteria:	None

Change – Assignments

Purpose:	Default query for Change Assignments
Prompts:	None
Fields displayed:	Title, Created by, User assigned to, Group assigned to, Assignment date
Criteria:	None

Change – Escalation Points

Purpose:	Default query for Change Escalation Points
Prompts:	None
Fields displayed:	Title, Created by, Escalation Time, Is Breach, Created date
Criteria:	None

Change – Implementation Submissions

Purpose:	Default query for Implementation Submissions
Prompts:	None
Fields displayed:	Name
Criteria:	None

Change – Quotes

Purpose:	Default query for Change Quotes
Prompts:	None
Fields displayed:	Quote, Quote Obtained From, Quote Amount, Created by, Created date
Criteria:	None

Change – Raise Purchase Order

Purpose:	Default query for Raise Purchase Order
Prompts:	None
Fields displayed:	Raise Purchase Order, Purchase Order Number, Created by, Created date
Criteria:	None

Change – Reminders

Purpose:	Default query for Change Reminders
Prompts:	None
Fields displayed:	Subject, Send Date
Criteria:	None

Change – Task Assignments

Purpose:	Default query for Change Task Assignments
Prompts:	None
Fields displayed:	Title, Created by, User assigned to, Group assigned to, Assignment date
Criteria:	None

Change – Task Reminders

Purpose:	Default query for Change Task Reminders
Prompts:	None
Fields displayed:	Subject, Send Date
Criteria:	None

Change – Tasks

Purpose:	Default query for Change Tasks
Prompts:	None
Fields displayed:	Title, Status, Created by, Created date
Criteria:	None

Change – UAT Submissions

Purpose:	Default query for User Acceptance Test Submissions
Prompts:	None
Fields displayed:	Name
Criteria:	None

Changes Awaiting Authorisation

Purpose:	Lists Changes that are awaiting authorisation
Prompts:	None
Fields displayed:	Extended ID, Created date, Title, Status
Criteria:	Status.Title is one of (Change Manager Approval, Change Advisory Board Approval)

Changes By Status

Purpose:	Lists open Changes sorted by status
Prompts:	None
Fields displayed:	Extended ID, Title, Category, Type of change, Lifecycle, Status, Created date
Criteria:	Status.Is End is equal to false

Changes By Type

Purpose:	Lists open Changes sorted by type of change
Prompts:	None
Fields displayed:	Extended ID, Title, Category, Type of change, Lifecycle, Status, Created date
Criteria:	Status.Is End is equal to false

Changes Created by Me

Purpose:	Lists open Changes created by the current user
Prompts:	None
Fields displayed:	Extended ID, Title, Status, Created date
Criteria:	Status.Is End is equal to false AND Created By is current user

My Group's or Role's Change Workload

Purpose:	Lists open Changes assigned to my group or role
Prompts:	None
Fields displayed:	Extended ID, Title, Category, Type of change, Lifecycle, Status, Latest assigned role, Latest assigned group, Latest assigned user, Last updated
Grouping:	Status.Title
Criteria:	Status.Is End is equal to false AND Latest Assignment.Group is within my groups AND Status.Is End is equal to false AND Latest Assignment.Role is within my roles AND Status.Is End is equal to false AND Latest Assignment.User is current user

Release Tests still Outstanding

Purpose:	Lists all unfinished Release Test Tasks for a specified Release; used on the Release Details and Roll Out Details windows
Prompts:	Change ID
Fields displayed:	Test Type, Description
Criteria:	Change ID is equal to <prompt user> AND Status.Is End is equal to false

Releases Planned For Today

Purpose:	Lists all Releases that are proposed to be released on the specified day; used on the Release Details and Roll Out Details windows
Prompts:	None
Fields displayed:	Extended ID, Release Outline, Release Type, Current Status
Criteria:	Proposed Release Date Is Today

Roll Outs Planned For this Day

Purpose:	Lists all Releases that are proposed to be rolled out on the specified day.
Prompts:	None
Fields displayed:	Extended ID, Release Outline, Release Type, Current Status
Criteria:	Roll Out Date Is Today

SS Changes Currently Assigned To Me

Purpose:	Lists all open changes assigned to the current user. Intended for use with Web Access.
Prompts:	None
Fields displayed:	Extended ID, Creation Date, Title, Lifecycle
Criteria:	Current Assigned User is Current User AND Status is not an End status

Purpose:	Lists Changes that were updated in the previous two days
Prompts:	None
Fields displayed:	Extended ID, Title, Status, Last Updated, Last Updated By
Criteria:	Status.Is End is equal to false AND Last Update is within the previous 48 hours AND Status.Name Is not equal to Open