Stored Queries

2008-03-07T02:44:16Z

Aalhajj: /* Requests, Incidents, Problems, Change Orders & Issues */

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

== [[Request|Requests]], [[Incident|Incidents]], [[Problem|Problems]], [[Change Order|Change Orders]] & [[Issue|Issues]] ==
{| style="width:100%;vertical-align:top;"
|-
! style="width:30%;" | Description
! style="width:40%;" | Code
! style="width:30%;" | 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
|-
| [[Affected End User]]'s Location
| customer.location = U'A26C98F436C43149A700CC0ED3BA74E5'
| Requests, Incidents & Problems only
|-
| [[Affected End User]]'s Site
| customer.location.site = U'A26C98F436C43149A700CC0ED3BA74E5'
| Requests, Incidents & Problems only
|-
| [[Affected End User]]'s Location is the same as the person logged in
| customer.location = @cnt.location
| Requests, Incidents & Problems only
|-
| [[Affected End User]]'s Site is the same as the person logged in
| customer.location.site = @cnt.location.site
| Requests, Incidents & Problems only
|-
| [[Affected End User]] is the person logged in
| customer = @cnt.id
| Requests, Incidents & Problems only
|-
| Attached [[Change Order|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
|-
| [[Affected End User]]'s Location
| affected_contact.location = U'A26C98F436C43149A700CC0ED3BA74E5'
| Applies to Change Orders and Issues only
|-
| [[Affected End User]]'s Site
| affected_contact.location.site = U'A26C98F436C43149A700CC0ED3BA74E5'
| Applies to Change Orders and Issues only
|-
| [[Affected End User]]'s Location is the same as the person logged in
| affected_contact.location = @cnt.location
| Applies to Change Orders and Issues only
|-
| [[Affected End User]]'s Site is the same as the person logged in
| affected_contact.location.site = @cnt.location.site
| 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=U'7D15BCD6D0B7E8468E58EA600E61F484'
| For pre-r11 releases, just reference the id.
|-
| 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\') AND open_date < EndAtTime(\'YESTERDAY\')
|
|-
| Created yesterday and today
| open_date > StartAtTime(\'YESTERDAY\')
|-
|}

== [[Workflow]] & Issue [[Workflow]] ==
{| style="width:100%;"
|-
! style="width:30%;" | Description
! style="width:40%;" | Code
! style="width:30%;" | 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|workflow]]
| status.do_next_task = 0
|
|-
|}

== [[Contact|Contacts]] ==
{| style="width:100%;"
|-
! style="width:30%;" | Description
! style="width:40%;" | Code
! style="width:30%;" | Notes
|-
| All [[Analyst|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|Contact's]] [[Location|location]] is the same as the logged in person's [[Location|location]]
| location = @cnt.location
|
|-
|}

== [[Configuration Item|Configuration Items]] ==
<br>

== [[Knowledge Tools/Keyword Search|Knowledge]] ==
<br>

----
<div align='center'><font color="red">To make corrections or additions to this article, select the ''edit'' tab above.<br>
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div>

[[Category:Miscellaneous]]

SDU - User contributions [en]

Stored Queries