Help Needed with Asset Custom Field Filter in Jira

[Tarik Userli]

Hi,

I’m struggling with a Custom Field filter in Jira. We have "Personen" objects, which contain attributes like "Einsatzbereich" (which points to another object type) and "User" (which points to a Jira user).

My issue is that I can’t seem to filter the "Personen" objects that are in the same "Einsatzbereich" as the current user and the linked "Personen" object.

Here’s the query I’m using to filter "Personen" with an "Einsatzbereich" reference:
objectType = Personen AND object having outboundReferences(objectType = Einsatzbereich)

However, I’m trying to filter for "Personen" objects that are in the same "Einsatzbereich" as the current user’s linked "Personen" object, but I’m not sure how to achieve that.

Any help would be greatly appreciated!

Thanks,
Tarik

[Marshall Walker Lee]

Assuming the User attribute is on the "Personen" object type as described, then you need a nested AQL query within the main filter. This approach relies on fetching the current user's associated "Personen" object and then extracting its "Einsatzbereich" to use as a filter value. I'm not the best with queries, but I think it would be: 

"Einsatzbereich" IN object HAVING inboundReferences("User" = currentUser())

[Tarik Userli]

Thanks for the reply but it does not work. Got an error:

"AQL ""Einsatzbereich" IN object HAVING inboundReferences("User" = currentUser())" has invalid syntax at position 27 with error message "extraneous input 'HAVING' expecting {<EOF>, ' '}""

I guess its because of the ""Einsatzbereich" IN object HAVING".