AQL Query to find User account based on e-mail address?

Jeremy Wood

We have an asset library for all of our users. One of the attributes on the Assets is "User Account" This is a User Type Attribute and through automation ties the user object to the users account in Jira. 

What i am looking to do is use the AQL query filter to find a object based off of the User Accounts e-mail address. 

Something along the lines of {{UserAccount.EmailAddress}} = Email@email.com. 

This query as is, does not work so i clearly have it wrong. What Query would i need for this to work? 

Lori Brown

I also have an example where I have an Employee objectType with a User Type Attribute. Are you able to try AQL queries using the Advanced AQL option when you're filtering?

When I try "Jira User" = "myemail@companycom" I actually do bring myself back, which is kind of neat. I was expecting it to need a GUID or similar.

Are you trying it in the AQL filter or in a custom Assets field?