Creating a filter by SubProduct multiselect

[Julian Haines]

Hi,

I am trying to create a filter to show all items with a subproduct of ""

BUD (Budgeting - Outturn and Plans)

I am using the following AQL but its returning no results, the SubProduct field is a multiselect and it should be returning lots of results.

subproduct IN aqlFunction("SubProduct like \"BUD (Budgeting - Outturn and Plans)\"") ORDER BY created DESC

[Himanshu Tiwary]

Hi @Julian Haines ,

You are using the wrong syntax for this.
aqlFunction() is for JQL issue searches when you are searching on an Assets field within Jira issues. If you are searching directly within Assets, you need to use normal AQL syntax instead.
Try:SubProduct = "BUD (Budgeting - Outturn and Plans)"

If you are still getting nothing back, you can also try putting quotes around the attribute name
"SubProduct" = "BUD (Budgeting - Outturn and Plans)"