I am using a filter array action to query a service now table and filter out CI's from the CMDB table which match a specific value in a custom attribute created. I am looking to update my query to exclude devices from the table if a specific attribute is blank.
My current query is below which filters devices in the cmdb_ci_wap_network table with the provisioning_status attribute value set to Ready for Provisioning.
equals(item()?['provisioning_status'],'Ready for Provisioning')
)
I am looking to update the query to filter on the same values, but also look at another attribute, in this case the MAC_Address, and exclude the CI if the mac address attribute is blank.
Filter query to filter out devices with a null value
you can try not(empty(item()['MAC_Addressfield']))
If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as answer ✔️. This is help the community.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
