Difference between revisions of "Stored Queries"

Revision as of 22:05, 13 January 2008

Stored Queries are used exclusively for the Scoreboard. Stored Queries have no capabilities or functionality outside of the Scoreboard.

All tickets

Active

Active: active = 1
Inactive: active = 0

Has Assignee: assignee is not null
No Assignee: assignee is null
Assignee is the person logged in: assignee = @cnt.id
Assignee is a specific contact: assignee = nnnnnn

Callback Today: call_back_flag=1 AND call_back_date < EndAtTime(\'TODO_TODAY\')

Category or Area is specific:category.id = nnnnnn

Group is specific: group=nnnnnn
Member of the Group is the person logged in: group.group_list.member IN (@cnt.id)

Created by the person logged on: log_agent = @cnt.id

Priority is 1: priority = 5
Priority is 5: priority = 1

Resolved: active = 1 and status = \'RE\'

SLA has been violated: sla_violation != 0
SLA has not been violated: sla_violation = 0

Created in the past 60 minutes: open_date > StartAtTime(\'PAST_HOUR\')
Created in the past 24 hours: open_date > StartAtTime(\'PAST_DAY\')
Created in the past 7 days: open_date > StartAtTime(\'PAST_WEEK\')
Created in the past 30 days: open_date > StartAtTime(\'PAST_MONTH\')
Created in the past 365 days: open_date > StartAtTime(\'PAST_YEAR\')
Created last hour: open_date > StartAtTime(\'LAST_HOUR\')
Created last month: open_date > StartAtTime(\'LAST_MONTH\')
Created last year: open_date > StartAtTime(\'LAST_YEAR\')
Created this hour: open_date > StartAtTime(\'THIS_HOUR\')
Created this month: open_date > StartAtTime(\'THIS_MONTH\')
Created this month last year: open_date > StartAtTime(\'THIS_MONTH_LAST_YEAR\')
Created today: open_date > StartAtTime(\'TODAY\')
Created today after noon: open_date > StartAtTime(\'AFTER_NOON\')
Created today before noon: open_date > StartAtTime(\'BEFORE_NOON\')
Created yesterday: open_date > StartAtTime(\'YESTERDAY\')

Requests, Incidents, Problems only

Affected end user is the person logged in: customer = @cnt.id
Attached CO: (change IS NOT NULL AND change != 0)

Change Orders & Issues only

Affected end user is the person logged in: affected_contact = @cnt.id
Requester is the person logged in: requestor = @cnt.id

Workflow & Issue Workflow

Assignee is logged in person: assignee = @cnt.id
Assignee is a specific Group: assignee.last_name = \'xxxxxxxxxx\'

Future: status.allow_task_update = 0 AND status = \'WAIT\'
Waiting: status = \'WAIT\'
Pending: status = \'PEND\'
To do today: status = \'PEND\' AND est_completion_date < EndAtTime(\'TODO_TODAY\')

Cannot be edited: status.allow_task_update = 0
Is not complete:status.task_complete = 0
Is not next in the workflow:status.do_next_task = 0

Contacts

All Analysts: type = 2307

Analyst is available: available = 1
Analyst is unavailable: available=0 OR available IS NULL

Contact is active: delete_flag = 1
Contact is inactive: delete_flag = 0

Contact's location is the same as the logged in person's location: location = @cnt.location

Configuration Items

Knowledge