retrieve multiple assets in lookup

Question

I have a form and when i run an automation to pull back the values of some assets it works perfectly well with single values. If i have 2 or more selected i get a null return - whats wrong with the query i have here?

If the below has one group its fine, but 2 or more and i get nothing back

objectType = "EIS Group" AND KEY in {{issue.EIS Group}}

{{issue.EIS Group}} is a custom field looking at the values in the asset object EIS Groups

Mikael Sandberg · Answer

This is what I would do, I would add a log action that has the value of {{issue.EIS Group}} so you can see what the format looks like. You can then from there use smart values to remove/replace characters so that if fit with what AQL is expecting. I have an automation that gets approvers based on department that is multi-select and I have a smart value that remove [] and commas like this:

steven.allcock · Answer

Ah so what i have done is made the scope of this field to single values i think by using the = thinking it would pickup everything in that field. Below is the form and the AQL scope.

What do you suggest doing with the scope as these can all have multiple values and i guess i need something not so rigid.

The scope is for the authority level below which is blank because the group field contains 2 values

Mikael Sandberg · Answer

You want to check what the value is for {{issue.EIS Group}} when it has multiple values, I suspect that it is not in a format that AQL understands and that is why it if not returning anything. AQL is expecting it to look something like this:

KEY in ("key-1", "key-2")