Difference between revisions of "Stored Queries"

From SDU
Jump to: navigation, search
m (→‎Workflow & Issue Workflow)
m
Line 5: Line 5:
  
 
== Examples ==
 
== Examples ==
−
=== [[Request|Requests]], [[Incident|Incidents]], [[Problem|Problems]], [[Change Order|Change Orders]] & [[Issue|Issues]] ===
+
=== Requests, Incidents, Problems, Change Orders & Issues ===
 
{| style="width:100%;vertical-align:top;"
 
{| style="width:100%;vertical-align:top;"
 
|-
 
|-
Line 20: Line 20:
 
|
 
|
 
|-
 
|-
−
| 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 End User]] is the person logged in
+
| Affected End User is the person logged in
 
| customer = @cnt.id
 
| customer = @cnt.id
 
| Requests, Incidents & Problems only
 
| Requests, Incidents & Problems only
 
|-
 
|-
−
| [[Affected End User]]'s Location
+
| Affected End User's Location
 
| customer.location = U\'A26C98F436C43149A700CC0ED3BA74E5\'
 
| customer.location = U\'A26C98F436C43149A700CC0ED3BA74E5\'
 
| Requests, Incidents & Problems only
 
| Requests, Incidents & Problems only
 
|-
 
|-
−
| [[Affected End User]]'s Site
+
| Affected End User's Site
 
| customer.location.site = 400001
 
| customer.location.site = 400001
 
| Requests, Incidents & Problems only
 
| Requests, Incidents & Problems only
 
|-
 
|-
−
| [[Affected End User]]'s Location is the same as the person logged in
+
| Affected End User's Location is the same as the person logged in
 
| customer.location = @cnt.location
 
| customer.location = @cnt.location
 
| Requests, Incidents & Problems only
 
| Requests, Incidents & Problems only
 
|-
 
|-
−
| [[Affected End User]]'s Site is the same as the person logged in
+
| Affected End User's Site is the same as the person logged in
 
| customer.location.site = @cnt.location.site
 
| customer.location.site = @cnt.location.site
 
| Requests, Incidents & Problems only
 
| Requests, Incidents & Problems only
 
|-
 
|-
−
| [[Affected End User]] is the person logged in
+
| Affected End User is the person logged in
 
| customer = @cnt.id
 
| customer = @cnt.id
 
| Requests, Incidents & Problems only
 
| Requests, Incidents & Problems only
 
|-
 
|-
−
| Attached [[Change Order|CO]]
+
| Attached CO
 
| (change IS NOT NULL AND change != 0)
 
| (change IS NOT NULL AND change != 0)
 
| Requests, Incidents & Problems only
 
| Requests, Incidents & Problems only
 
|-
 
|-
−
| [[Affected End User]] is the person logged in
+
| 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
 
|-
 
|-
−
| [[Affected End User]]'s Location
+
| Affected End User's Location
 
| affected_contact.location = U\'A26C98F436C43149A700CC0ED3BA74E5\'
 
| affected_contact.location = U\'A26C98F436C43149A700CC0ED3BA74E5\'
 
| Applies to Change Orders and Issues only
 
| Applies to Change Orders and Issues only
 
|-
 
|-
−
| [[Affected End User]]'s Site
+
| Affected End User's Site
 
| affected_contact.location.site = 400001
 
| affected_contact.location.site = 400001
 
| Applies to Change Orders and Issues only
 
| Applies to Change Orders and Issues only
 
|-
 
|-
−
| [[Affected End User]]'s Location is the same as the person logged in
+
| Affected End User's Location is the same as the person logged in
 
| affected_contact.location = @cnt.location
 
| affected_contact.location = @cnt.location
 
| Applies to Change Orders and Issues only
 
| Applies to Change Orders and Issues only
 
|-
 
|-
−
| [[Affected End User]]'s Site is the same as the person logged in
+
| Affected End User's Site is the same as the person logged in
 
| affected_contact.location.site = @cnt.location.site
 
| affected_contact.location.site = @cnt.location.site
 
| 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 88: Line 88:
 
|
 
|
 
|-
 
|-
−
| [[Category]] or [[Request/Incident/Problem Area]] is specific
+
| Category or Request/Incident/Problem Area is specific
 
| category.id = nnnnnn
 
| category.id = nnnnnn
 
|
 
|
 
|-
 
|-
−
| [[Group]] is specific
+
| Group is specific
 
| group=U\'7D15BCD6D0B7E8468E58EA600E61F484\'
 
| group=U\'7D15BCD6D0B7E8468E58EA600E61F484\'
 
| For pre-r11 releases, just reference the id.
 
| For pre-r11 releases, just reference the id.
Line 104: Line 104:
 
|
 
|
 
|-
 
|-
−
| [[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 238: Line 238:
 
|}
 
|}
  
−
=== [[Contact|Contacts]] ===
+
=== Contacts ===
 
{| style="width:100%;"
 
{| style="width:100%;"
 
|-
 
|-
Line 245: Line 245:
 
! style="width:30%;" | Notes
 
! style="width:30%;" | Notes
 
|-
 
|-
−
| All [[Analyst|Analysts]]
+
| All 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|Contact's]] [[Location|location]] is the same as the logged in person's [[Location|location]]
+
| Contact's Location is the same as the logged in person's Location
 
| location = @cnt.location
 
| location = @cnt.location
 
|
 
|
Line 271: Line 271:
 
|}
 
|}
  
−
=== [[Configuration Item|Configuration Items]] ===
+
=== Configuration Items ===
 
<br>
 
<br>
  
−
=== [[Knowledge Tools/Keyword Search|Knowledge]] ===
+
=== Knowledge ===
 
<br>
 
<br>
  

Revision as of 17:44, 30 June 2008

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

Stored Queries Reference

  1. Time-Based Queries

Examples

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
Affected End User's Location customer.location = U\'A26C98F436C43149A700CC0ED3BA74E5\' Requests, Incidents & Problems only
Affected End User's Site customer.location.site = 400001 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 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 = 400001 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

Description Code Notes
Assignee is logged in person assignee = @cnt.id
Assignee is a specific Group assignee=U\'7D15BCD6D0B7E8468E58EA600E61F484\'
Logged in person is a member of the Group set as the Assignee assignee.[group]group_list.member IN (@cnt.id)
Group is specific group=U\'7D15BCD6D0B7E8468E58EA600E61F484\'
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



To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.
Retrieved from "http://greggsmith.net/wiki/index.php?title=Stored_Queries&oldid=2076"