List of Assets NOT Exists

[swright]

I'm trying to create a query where one of the conditions is a field without a value.  Under the Operators for List of Assets, I see an operator of EXISTS, but not an option for when the field has no value.

path: "currentItem.assetCustom.fields.Server Type",

        operator: NOT EXISTS,

        value: ""

Or Value is NULL?

I have the option to check for NOT EXISTS in the Branch, but I don't want to loop through all assets every time the I run the flow.

Any ideas?

[swright]

Thanks for the quick response.

[Vicente_SC · Accepted solution]

You can filter for fields that exist/not exist in the Filters section of the "List of Assets" action with an expression like this one:

{

    conjunction: AND,

    conditions: [

      {

        path: "asset.general.serial_number",

        operator: EXISTS,

        value: "true"

      }

    ]

  }

However, take into account that we don't support all the fields in that filter section. The fields we support for that filtering option can be found here: https://community.lansweeper.com/t5/connectors/lansweeper-connector/ta-p/85179#toc-hId--13128466

If you want to filter by a field not in that list, the best option is to use a "Filter" action after the "List of Assets" step.

In the future, we plan to add more pre-filtering capabilities, so the workflows can bring only the needed data and be more efficient.