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 Extended IDs.
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 |