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 the Designer Guide.

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 Authorization

Purpose:

Lists Changes that are awaiting authorization

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

Recently Updated Changes

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

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


Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other