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?

[julia_gracia]

Hi did you tried 

aqlFunction("Site.Name IN (\"XXXXXX\""))

[Scott Boisvert]

@julia_gracia Yep.... Same results. (had to move the last quote outside the parenthesis (failed with it inside.

aqlFunction("Site.Name IN ( \"XXXXXXXX\")")

[julia_gracia]

Could you try this

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

 Change the Facilities in aqlFunction for Facilities is aqlFunction

[Scott Boisvert]

@julia_gracia looks like the is operator isn't supported for Assets fields...

[julia_gracia]

It dosen´t say that in the documentation 

https://support.atlassian.com/jira-service-management-cloud/docs/assets-jql-functions/

jajajaja just Atlassian 

[Scott Boisvert]

@julia_gracia That would be the cloud documentation, we're on Data Center (doesn't mention "Is" in that documentation (thought it doesn't mention supported operators either): https://confluence.atlassian.com/servicemanagementserver/assets-jql-functions-1087513360.html 

[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.