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!!!
