Insight Lookup objects in automation module

Krzysztof Hotiuk

Hi, 

In automation module, there is a Lookup object to filter objects from Insight.

I have a custofield with id 10073 and name "User Name". this is a Inside's type custom field type

Object type name is  "UserList"

I need to find this one, where a "Name" attribute equals with value in custom field.

 

in Query I wrote: 

objectType="UserList" and "Name" = {{issue.User Name}}

or:

objectType="UserList" and "Name" = {{issue.customfield_10073.value}}

and other combination..

 

all cases I've tried ends with error message:

{"errorMessages":["IQL \"objectType=\"UserList\" and \"Name\" = and objectSchemaId == 5\" has invalid syntax at position 39 with error message \"extraneous input 'objectSchemaId' expecting {<EOF>, ' '}\""],"errors":{}}

 

(or similar)

What is proper syntax or how to get results I need?

Thanks, 

Krzysztof

 

 

Dirk Ronsmans

Hey @Krzysztof Hotiuk ,

As you can see in the error the IQL you are trying to get to is resolving to:

IQL \"objectType=\"UserList\" and \"Name\" = and objectSchemaId == 5\"

meaning that your customfield value is not being pulled/resolved.

Since customfield_10073 is an Insight custom field I would suggest trying to use:

{{issue.customfield_10073.label}} or {{issue.customfield_10073.Name}}