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
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}}
Thanks for your answer.. yes, it works now!
next question related smart values...
from object a need get value from attribute "Email" and to new object only prefix.
ex. Email attribute value is: kh_makii@makii.pl
in new object I need only: kh_makii
I've tried with this:
{{lookupObjects.Email.substringBefore("@")}}
but.. dosn't work :(
any Idea?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
is the lookupObjects actually returning something and if so what?
i would suggest doing a "log" action and go step by step. First output the full attribute to be sure that it returns something and then start cutting it up.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
lookupObject.Email works fine. I can see all email address in log as expected.
but {{lookupObjects.Email.substringBefore("@")}} is empty :(
Thanks,
Krzysztof
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
Any other suggestions / ideas ? :)
Thanks,
Krzysztof
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey Krzysztof,
You can try {{lookupObjects.Email.split("@").first}}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.