Trouble using aqlFunction(), can't sucessfully query what I need

[Eli Devlin]

Hi all,

I've been trying to understand aqlFunction() and am unable to figure out why I can't limit the query to a single Schema or Object Type in the aql.

Here's the relevant details:

Users is the object type

Office Location is the attribute

Wellington is the attribute value I want to query for

Master Object Schema is the schema I want to query against

Reporter's Profile is the custom field which yields the corresponding Users object to match the issue Reporter

So using a JQL search, I'm trying to identify issues where the Reporter is in Wellington.

This one works fine: "Reporter's profile" IN aqlFunction("\"Office Location\" = \"Wellington\"")

This one yields nothing: "Reporter's profile" IN aqlFunction("Users.\"Office Location\" = \"Wellington\"")

I could use the first query, but it takes a couple of seconds to load only 170 results.

The documentation says I should try to be as specific as possible, so I thought I could limit the search to a single Object Type: Users. But I can't make it work the way that the examples here are supposed to work.

Can anyone please advise where I'm going wrong here?

Thank you!!!