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?
Hi did you tried
aqlFunction("Site.Name IN (\"XXXXXX\""))
@julia_gracia Yep.... Same results. (had to move the last quote outside the parenthesis (failed with it inside.
aqlFunction("Site.Name IN ( \"XXXXXXXX\")")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It dosen´t say that in the documentation
https://support.atlassian.com/jira-service-management-cloud/docs/assets-jql-functions/
jajajaja just Atlassian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Scott Boisvert could you please replace = to with Like function. Below is the example.
"Site.Name LIKE 'XXXXXX'"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.