Difference between revisions of "Stored Queries"

From SDU
Jump to: navigation, search
(→‎Requests, Incidents, Problems only)
(→‎All tickets)
Line 3: Line 3:
  
 
== All tickets ==
 
== All tickets ==
−
'''Active:''' active = 1<br>
+
== All tickets ==
−
'''Inactive:''' active = 0<br>
+
{| style="width:90%;"
−
 
+
|-
−
'''Has Assignee:''' assignee is not null<br>
+
! style="width:30%;" | Description
−
'''No Assignee:''' assignee is null<br>
+
! style="width:40%;" | Code
−
'''Assignee is the person logged in:''' assignee = @cnt.id<br>
+
! style="width:30%;" | Notes
−
'''Assignee is a specific contact:''' assignee = nnnnnn<br>
+
|-
−
 
+
| Active
−
'''Callback Today:''' call_back_flag=1 AND call_back_date < EndAtTime(\'TODO_TODAY\')<br>
+
| active = 1
−
 
+
|
−
'''Category or Area is specific:'''category.id = nnnnnn<br>
+
|-
−
 
+
| Inactive
−
'''Group is specific:''' group=nnnnnn<br>
+
| active = 0
−
'''Member of the Group is the person logged in:''' group.group_list.member IN (@cnt.id)<br>
+
|
−
 
+
|-
−
'''Created by the person logged on:''' log_agent = @cnt.id<br>
+
| Has Assignee
−
 
+
| assignee is not null
−
'''Priority is 1:''' priority = 5<br>
+
|
−
'''Priority is 5:''' priority = 1<br>
+
|-
−
 
+
| No Assignee
−
'''Resolved:''' active = 1 and status = \'RE\'<br>
+
| assignee is null
−
 
+
|
−
'''SLA has been violated:''' sla_violation != 0<br>
+
|-
−
'''SLA has not been violated:''' sla_violation = 0<br>
+
| Assignee is the person logged in
−
 
+
| assignee = @cnt.id
−
'''Created in the past 60 minutes:''' open_date > StartAtTime(\'PAST_HOUR\')<br>
+
|
−
'''Created in the past 24 hours:''' open_date > StartAtTime(\'PAST_DAY\')<br>
+
|-
−
'''Created in the past 7 days:''' open_date > StartAtTime(\'PAST_WEEK\')<br>
+
| Callback Today
−
'''Created in the past 30 days:''' open_date > StartAtTime(\'PAST_MONTH\')<br>
+
| call_back_flag=1 AND call_back_date < EndAtTime(\'TODO_TODAY\')
−
'''Created in the past 365 days:''' open_date > StartAtTime(\'PAST_YEAR\')<br>
+
|
−
'''Created last hour:''' open_date > StartAtTime(\'LAST_HOUR\')<br>
+
|-
−
'''Created last month:''' open_date > StartAtTime(\'LAST_MONTH\')<br>
+
| Category or Area is specific
−
'''Created last year:''' open_date > StartAtTime(\'LAST_YEAR\')<br>
+
| category.id = nnnnnn
−
'''Created this hour:''' open_date > StartAtTime(\'THIS_HOUR\')<br>
+
|
−
'''Created this month:''' open_date > StartAtTime(\'THIS_MONTH\')<br>
+
|-
−
'''Created this month last year:''' open_date > StartAtTime(\'THIS_MONTH_LAST_YEAR\')<br>
+
| Group is specific
−
'''Created today:''' open_date > StartAtTime(\'TODAY\')<br>
+
| group=nnnnnn
−
'''Created today after noon:''' open_date > StartAtTime(\'AFTER_NOON\')<br>
+
|
−
'''Created today before noon:''' open_date > StartAtTime(\'BEFORE_NOON\')<br>
+
|-
−
'''Created yesterday:''' open_date > StartAtTime(\'YESTERDAY\')<br>
+
| 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\')
 +
|
 +
|-
 +
|}
  
 
== Requests, Incidents, Problems only ==
 
== Requests, Incidents, Problems only ==

Revision as of 02:22, 14 January 2008

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

All tickets

All tickets

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
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\')

Requests, Incidents, Problems only

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

Configuration Items


Knowledge


Retrieved from "http://greggsmith.net/wiki/index.php?title=Stored_Queries&oldid=299"