Filter query to filter out devices with a null value

(0) Share

Report

Posted on by DK-15111246-0

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.

and(
equals(item()?['sys_class_name'],'cmdb_ci_wap_network'),
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.

Categories:

Business Process Flows

All responses (1)

Answers (1)

Verified answer

MichaelFP 1,463 on at

Like (1)

Report

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.