Stored Queries

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

All tickets

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

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

Workflow & Issue Workflow

Description	Code
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

Description	Code
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