I need to create a stored query that display only parent incident in the Scoreboard.
How to create a stored query that display only parent incident ticket.
Here are the stored queries we use for open parent tickets:
For open parent incident tickets: active = 1 AND type=\'I\' AND major_incident = 1
For open parent request tickets: active = 1 AND type=\'R\' AND major_incident = 1
Hope that helps!Tammy
I think that you can display that type of relation over QREL:
persistent_id.[parent]children.id is not NULL
Otherwise you need to publish some spl customization to count child tickets or BREL which is more flexible.
I used the stored query and after 5 to 10 min I re-login only the Scoreboard tab display is inaccessible showing Delayed Server Response.
I remove the where clause persistent_id.[parent]children.id is not NULL and re-login again did the Scoreboard tab display return to normal.
that's the reason i do not recommend to use QREL/BREL/LREL in stored queries so, spl cusomization could be a way.
Retrieving data ...