Using aqlFunction in JQL for Multi Select Assets Field

[Scott Boisvert]

I have an Assets select field called Facilities, this field is configured to select multiple asset objects. I'm looking to write a JQL statement that will return the issue if the Assets field contains at least one Facility object where the Name = "XXXXXX"

Here is the JQL that I came up with that half works. This will bring back issues if there is only one Facility selected, if there are multiple those are not returned.

project = FACSD AND "Customer Request Type" = "Business Meal Request" AND Facilities in aqlFunction("Site.Name = \"XXXXXX\"")

For example this issue is not included and should be:

How should I update my JQL/AQL to pull in issues that have multiple Facilities selected where at least one matches the AQL criteria?

[Manoj Gangwar]

Hi @Scott Boisvert could you please replace = to with Like function. Below is the example. 

"Site.Name LIKE 'XXXXXX'"

[Scott Boisvert]

@Manoj Gangwar Yep, tried that too... No luck returns the same set of issues.