Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report conditions not working

pennieturner
Mega Guru

I'm trying to create a report on the sc_req_item, to show certain RITMs.   See below:

find_real_file.png

I want to put another filter condition on for the Scheduled Release version field, so it doesn't show any RITMs where 'iCABS Next Generation Release' is in the field. When I do this, it also ignores any where its empty and filters those out too:

find_real_file.png

I can't seem to be able to get it just ignore certain words and show everything else.

The scheduled release field is a string field with a choice of suggestion.


Any help would be appreciated

Regards

1 ACCEPTED SOLUTION

Hi Simon



I seem to have got this working by adding another condition:



OR



Scheduled release version 'is empty'



And it works! Thankfully!



Thank you all for taking your time to help


View solution in original post

6 REPLIES 6

Hi Pennie,



Could you check the error log on your instance to see if you are seeing any exceptions around the time you run the report?



Kind regards,



Simon


Hi Simon



I seem to have got this working by adding another condition:



OR



Scheduled release version 'is empty'



And it works! Thankfully!



Thank you all for taking your time to help