Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Excluding a substate

KathersC
Kilo Explorer

Hello,

This is my first post so apologies if I get anything wrong!

I have a report feeding from alm_hardware which shows me which machines with a state of In Stock or In Use are due to be retired this quarter. However, I want to exclude any devices with a substate of Pending Disposal from this report, but when I select that as a pending condition (substate is not pending disposal), the result excludes all devices with a state of In Use. 

Am I missing something really simple?! Screenshots attached to show the selected conditions.

 

1 REPLY 1

Naveen20
ServiceNow Employee

Try this fix
Fix it with an OR clause so empties show - Change filter condition
Substate is not Pending disposal OR Substate is empty