How to check for empty Insight attribute in automation conditional logic

[Charlie Misonne]

In an edit issue action I'm setting the value of the Affected Services field. In a previous step I have an "lookup object" action.

My objects have an attribute called Service and sometimes this attribute is empty. In those case I do not want to include it in the edit action.

{{#lookupObjects}}
{{#if(not(Service.equals("")))}}
{"id":"{{Service.Service ID}}"}
{{/}}

So far I am unable to check for an empty attribute.

I tried several notations including these but it always results in TRUE.

• {{#if(not(Service.equals("")))}}
• {{#if(not(exists(Service)))}}
• {{#if(not(Service.isEmpty))}}

[Manon Soubies-Camy · Accepted solution]

Hi @Charlie Misonne,

Would it work if you just excluded objects with empty Service attribute from the lookup action? Using the following IQL:

<your current IQL query> AND "Service" IS NOT empty

Hope this helps!

- Manon

[Charlie Misonne]

Simple and smart solution. Merci!

I still wonder why the conditional logic does not work but I won't spend any extra time on it.

[Reginaldo Souza Pereira]

Hello @Manon Soubies-Camy 

But I think when you have a scenario with many objects attributes, and someones of them are empty and others not empty. So in this case, you can't remove the object in the IQL, because this will remove the object with all attributes - the empties and not empties. In others words, I need a solution to be handled one by one attribute. Did you get my point?