Difference between revisions of "Stored Queries"
From SDU
(→Requests, Incidents, Problems, Change Orders & Issues) |
|||
| Line 1: | Line 1: | ||
[[Category:Miscellaneous]][[Category:Definitions]] | [[Category:Miscellaneous]][[Category:Definitions]] | ||
| − | Stored Queries are used exclusively for the [[Scoreboard]]. Stored Queries have no capabilities or functionality outside of the Scoreboard. | + | Stored Queries are used exclusively for the [[Scoreboard]]. Stored Queries have no capabilities or functionality outside of the [[Scoreboard]]. |
| − | == Requests, Incidents, Problems, Change Orders & Issues == | + | == [[Request|Requests]], [[Incident|Incidents]], [[Problem|Problems]], [Change Order|Change Orders]] & [[Issue|Issues]] == |
{| style="width:100%;vertical-align:top;" | {| style="width:100%;vertical-align:top;" | ||
|- | |- | ||
| Line 17: | Line 17: | ||
| | | | ||
|- | |- | ||
| − | | Has Assignee | + | | Has [[Assignee]] |
| assignee is not null | | assignee is not null | ||
| | | | ||
|- | |- | ||
| − | | No Assignee | + | | No [[Assignee]] |
| assignee is null | | assignee is null | ||
| | | | ||
|- | |- | ||
| − | | Assignee is the person logged in | + | | [[Assignee]] is the person logged in |
| assignee = @cnt.id | | assignee = @cnt.id | ||
| | | | ||
|- | |- | ||
| − | | Affected | + | | [[Affected End User]] is the person logged in |
| customer = @cnt.id | | customer = @cnt.id | ||
| Requests, Incidents & Problems only | | Requests, Incidents & Problems only | ||
|- | |- | ||
| − | | Attached CO | + | | Attached [[Change Order|CO]] |
| (change IS NOT NULL AND change != 0) | | (change IS NOT NULL AND change != 0) | ||
| Requests, Incidents & Problems only | | Requests, Incidents & Problems only | ||
|- | |- | ||
| − | | Affected | + | | [[Affected End User]] is the person logged in |
| affected_contact = @cnt.id | | affected_contact = @cnt.id | ||
| Applies to Change Orders and Issues only | | Applies to Change Orders and Issues only | ||
|- | |- | ||
| − | | Requester is the person logged in | + | | [[Requester]] is the person logged in |
| requestor = @cnt.id | | requestor = @cnt.id | ||
| Applies to Change Orders and Issues only | | Applies to Change Orders and Issues only | ||
| Line 49: | Line 49: | ||
| | | | ||
|- | |- | ||
| − | | Category or Area is specific | + | | [[Category]] or [[Request/Incident/Problem Area]] is specific |
| category.id = nnnnnn | | category.id = nnnnnn | ||
| | | | ||
|- | |- | ||
| − | | Group is specific | + | | [[Group]] is specific |
| group=nnnnnn | | group=nnnnnn | ||
| | | | ||
|- | |- | ||
| − | | Member of the Group is the person logged in | + | | Member of the [[Group]] is the person logged in |
| group.group_list.member IN (@cnt.id) | | group.group_list.member IN (@cnt.id) | ||
| | | | ||
| Line 65: | Line 65: | ||
| | | | ||
|- | |- | ||
| − | | Priority is 1 | + | | [[Priority]] is 1 |
| priority = 5 | | priority = 5 | ||
| References the enum value not the sym value. | | References the enum value not the sym value. | ||
|- | |- | ||
| − | | Priority is 5 | + | | [[Priority]] is 5 |
| priority = 1 | | priority = 1 | ||
| References the enum value not the sym value. | | References the enum value not the sym value. | ||
|- | |- | ||
| − | | Resolved | + | | [[Resolved]] |
| active = 1 and status = \'RE\' | | active = 1 and status = \'RE\' | ||
| | | | ||
|- | |- | ||
| − | | SLA has been violated | + | | [[SLA]] has been violated |
| sla_violation != 0 | | sla_violation != 0 | ||
| | | | ||
|- | |- | ||
| − | | SLA has not been violated | + | | [[SLA]] has not been violated |
| sla_violation = 0 | | sla_violation = 0 | ||
| | | | ||
| Line 143: | Line 143: | ||
|} | |} | ||
| − | == Workflow & Issue Workflow == | + | == [[Workflow]] & Issue [[Workflow]] == |
{| style="width:100%;" | {| style="width:100%;" | ||
|- | |- | ||
| Line 150: | Line 150: | ||
! style="width:30%;" | Notes | ! style="width:30%;" | Notes | ||
|- | |- | ||
| − | | Assignee is logged in person | + | | [[Assignee]] is logged in person |
| assignee = @cnt.id | | assignee = @cnt.id | ||
| | | | ||
|- | |- | ||
| − | | Assignee is a specific Group | + | | [[Assignee]] is a specific [[Group]] |
| assignee.last_name = \'Smith\' | | assignee.last_name = \'Smith\' | ||
| | | | ||
| Line 182: | Line 182: | ||
| | | | ||
|- | |- | ||
| − | | Is not next in the workflow | + | | Is not next in the [[Workflow|workflow]] |
| status.do_next_task = 0 | | status.do_next_task = 0 | ||
| | | | ||
| Line 188: | Line 188: | ||
|} | |} | ||
| − | == Contacts == | + | == [[Contact|Contacts]] == |
{| style="width:100%;" | {| style="width:100%;" | ||
|- | |- | ||
| Line 195: | Line 195: | ||
! style="width:30%;" | Notes | ! style="width:30%;" | Notes | ||
|- | |- | ||
| − | | All Analysts | + | | All [[Analyst|Analysts]] |
| type = 2307 | | type = 2307 | ||
| | | | ||
|- | |- | ||
| − | | Analyst is available | + | | [[Analyst]] is available |
| available = 1 | | available = 1 | ||
| | | | ||
|- | |- | ||
| − | | Analyst is unavailable | + | | [[Analyst]] is unavailable |
| available=0 OR available IS NULL | | available=0 OR available IS NULL | ||
| | | | ||
|- | |- | ||
| − | | Contact is active | + | | [[Contact]] is active |
| delete_flag = 1 | | delete_flag = 1 | ||
| | | | ||
|- | |- | ||
| − | | Contact is inactive | + | | [[Contact]] is inactive |
| delete_flag = 0 | | delete_flag = 0 | ||
| | | | ||
|- | |- | ||
| − | | Contact's location is the same as the logged in person's location | + | | [[Contact|Contact's]] [[Location|location]] is the same as the logged in person's [[Location|location]] |
| location = @cnt.location | | location = @cnt.location | ||
| | | | ||
| Line 221: | Line 221: | ||
|} | |} | ||
| − | == Configuration Items == | + | == [[Configuration Item|Configuration Items]] == |
<br> | <br> | ||
| − | == Knowledge == | + | == [[Knowledge Tools/Keyword Search|Knowledge]] == |
<br> | <br> | ||
Revision as of 01:58, 17 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 Order|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 Request/Incident/Problem 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 | References the enum value not the sym value. |
| Priority is 5 | priority = 1 | References the enum value not the sym value. |
| 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 = \'Smith\' | |
| 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
