Reporting on Reporter Attributes

[Jane Crampsey]

How can I report (JQL) on reporter attributes? i.e. I have a reporter with 'AD Department' as an attribute - so I want to show all tickets logged where the reporter has AD Department = DEPT NAME.

[Sarah Wright]

Hello and welcome,

Part of the answer is here on this related community post 

which explains how to search for assets using JQL. However this depends on having an asset custom field value to search against. In your case, if reporter is not an asset field, then I don't believe you can use the aql function in JQL to find the reporter AND the attribute.

Example of the AQL that could work

customField in aqlFunction("objectType\"AD Department\" = \"DEPT NAME\"")

customField in this case needs to be an asset field so that it can go look up that asset object then find the match on attribute. Just using the reporter field won't work as reporter is not an asset. 
You'll also want to ensure the asset field is able to be searched by the AD Department attribute.