Difference between revisions of "Stored Queries"
From SDU
(→All tickets) |
(→Requests, Incidents, Problems, Change Orders & Issues) |
||
| Line 3: | Line 3: | ||
== Requests, Incidents, Problems, Change Orders & Issues == | == Requests, Incidents, Problems, Change Orders & Issues == | ||
| − | {| style="width:100%;" | + | {| style="width:100%;vertical-align:top;" |
|- | |- | ||
! style="width:30%;" | Description | ! style="width:30%;" | Description | ||
Revision as of 02:53, 14 January 2008
Stored Queries are used exclusively for the Scoreboard. Stored Queries have no capabilities or functionality outside of the Scoreboard.
Contents
Requests, Incidents, Problems, Change Orders & Issues
| Description | Code | Notes |
|---|---|---|
| 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 | |
| Affected end user is the person logged in | customer = @cnt.id | Requests, Incidents & Problems only |
| Attached CO | (change IS NOT NULL AND change != 0) | Requests, Incidents & Problems only |
| Affected end user is the person logged in | affected_contact = @cnt.id | Applies to Change Orders and Issues only |
| Requester is the person logged in | requestor = @cnt.id | Applies to Change Orders and Issues only |
| 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 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\') |
Workflow & Issue Workflow
| Description | Code | Notes | |
|---|---|---|---|
| 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 | Notes |
|---|---|---|
| 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
