Community
Q&A
Jira
Questions
Using aqlFunction in JQL for Multi Select Assets Field

Using aqlFunction in JQL for Multi Select Assets Field

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\"")

Assets Search.png

For example this issue is not included and should be:

Assets Search 2.png

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

3 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes

@Scott Boisvert Did you figure this out? I am having the same issue.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@Dan Knapton Nope, never figured it out. Worked with Atlassian on it for a while and they couldn't figure it out either. Seems like a bug to me, but with DC end of life announced, I doubt they will fix it.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

0 votes

Hi did you tried

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

Comment

Like

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.

Comment

Like

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

Assets Is.png

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

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.

Comment

Like

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

Comment

Like

Reply

0 votes

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.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Was this helpful?

Thanks!

DEPLOYMENT TYPE

SERVER

VERSION

9.17.2

TAGS

Community showcase