I am able to filter requests by Active or Inactive. I am having some trouble formatting syntax to exclude anything marked as Resolved in the Status field. Can anyone provide some direction with how best to achieve this?
Maybe you can try this...
from the list of requests, click on Show Filter button and then click on "more..." a couple of times until you see Additional Search Arguments field and enter this
And then click on Search button?
In the Additional Search Arguments field, enter:
(status != 'RE')
Please see the attached...
From the 2nd screen capture, it looks like you are searching the status object and not the request object. You should be using the code that J_W gave you in the 1st screen.
As far as I know (I am not a power user of this interface nor programmer for it), this query is based off the following hierarchy Assignment Group --> Active=TRUE. I've modified the queries for other attributes successfully in the past but have been unable to successfully filter out resolved cases.
I have that backwards. Hierarchy is ACTIVE --> GROUP
No other filter criteria that I can see.
Jim, please let us know from where you want to filter the Resolved status for request search? It could be the status search field, additional search argument, data partition, etc. Thanks _Chi
Trying to filter from the Scoreboard. The base query is only filtering active tickets for my assignment group. I only want to add the additional criteria to filter out cases marked resolved.
Try adding the following criteria
status.sym != \'Resolved\'
Same error. Just 'Resolved' instead of 'RE'
AHD03053:Bad where clause: Parse error at : "( ( delete_flag = 0 AND (status.sym != \'Resolved\') ) AND ( cr_flag= 1 ) ) AND ( code != 'CL' )" (syntax error)
Please provide the complete stored query syntax
I cannot. I am an analyst trying to clean up my Scoreboard.
Jim, if you don't have access to Administration tab, you would need to contact SDM administrator so he/she can give you the stored query for your scoreboard node. And then he/she would need to modify the stored query to query resolved requests only. Thanks _Chi
Boo. Thanks for the reply. Doesn't really help me as a tech/analyst trying to clean up my view.
That seems to have done the job!
Kudos!! ***happy dance***
So it seems that the query I was working from is based on Requests. Thus it filtered out all of my Incidents. Fortunately our CASDM admin finally got something for us to put up on the Scoreboard Thank you for the assists!
Retrieving data ...