Queries

This topic applies to systems using an Asset Manager or Universal license only.

Active Contract Activities

Purpose:

Lists all active contract activities

Prompts:

None

Fields displayed:

Lifecycle, Extended ID, Title, Status, Contract, Contract Start, Contract End

Criteria:

Status.Is End is equal to False

The Active Contract Activities query includes the Reference Number attribute as a hidden column in addition to the Extended ID attribute (which uses the column heading of Reference). This hidden attribute is used for sorting. For more information about extended IDs, see the Designer Guide.

Contract - Assignments

Purpose:

Lists all contract assignments

Prompts:

None

Fields displayed:

Process Assignment, Status, User, Group, Role

Criteria:

None

Contract - Attachments

Purpose:

Lists all contract attachments

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Contract - Cancellations

Purpose:

Lists all contract cancellations

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Contract - Escalation Points

Purpose:

Lists all contract escalation points

Prompts:

None

Fields displayed:

Title, Creation Date, Expiry Date Time, Is Breach

Criteria:

None

Contract - Notes

Purpose:

Lists all contract notes

Prompts:

None

Fields displayed:

Serial Number, Title, Text, Created By, Creation Date

Criteria:

None

Contract - Reminders

Purpose:

Lists all contract reminders

Prompts:

None

Fields displayed:

Subject, Send Date

Criteria:

None

Contract - Tasks

Purpose:

Lists all contract tasks

Prompts:

None

Fields displayed:

Serial Number, Title, Lifecycle, Status

Criteria:

None

Contract - Task Assignments

Purpose:

Lists all contract task assignments

Prompts:

None

Fields displayed:

Title, Created By, User, Group, Creation Date

Criteria:

None

Contract - Task Completions

Purpose:

Lists all contract task completions

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Contract - Task Notes

Purpose:

Lists all contract task notes

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None

Contract - Task Reminders

Purpose:

Lists all contract task reminders

Prompts:

None

Fields displayed:

Subject, Send Date

Criteria:

None

Contract - Task Restarts

Purpose:

Lists all contract task restarts

Prompts:

None

Fields displayed:

Title, Created By, Creation Date

Criteria:

None


Was this article useful?    

The topic was:

Inaccurate

Incomplete

Not what I expected

Other