I'm trying to build an AQL query without restricting it to a specific objectType, and instead query objects based on attribute values.
My use case is to search across multiple object types using two attributes:
"Attr1".Name = "SOME TEXT"
AND
"Attr2".Name = ${customfield_XXXXX.label}
Observations
The first condition works as expected:
"Attr1".Name = "SOME TEXT"
It returns matching objects across different object types
However, when I add the second condition using the custom field reference:
"Attr2".Name = ${customfield_XXXXX.label}
the query does not return the expected results.
Question
Is there any limitation when using a Jira custom field variable within an AQL query that is not scoped to a specific object type?
Has anyone successfully used a custom field placeholder such as:
${customfield_XXXX.label}
for attribute matching across multiple object types? If so, are there any prerequisites or alternative syntax that should be used?
Any guidance would be appreciated.