AQL Filter query in custom field context

[Scott Schellhardt]

Hi All, I am trying to put together an AQL query filter that will only display certain location objects in a context for a custom field called Locations. For the sake of this exercise, We have a Locations asset, with Locations numbered 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15. I only want to show 1,2,3,4,5. 

Any help work be great!

Thanks 

[Marc - Devoteam · Accepted solution]

Hi @Scott Schellhardt 

The option from @Kai Becker will work if these values are set on the objects.

Can you show an object config and the context config of the custom field to be sure?

[Scott Schellhardt]

Hi Marc, 

Thanks for reaching out on this one, I was able so solve it internally. The context configuration that ended up working was :

Object schema: Locations

Filter scope (AQL): objectType = "Location"

Filter issue scope (AQL): objectType ="Location" AND Name IN ("Location 1", "Location 2", "Location 3","Location 4", "Location 5")

Allow search filtering by these attributes: Location

Object attributes to display on issue view: Location

Object attributes to display on customer portal request details view: Location

Field can store multiple objects: No

Display a default object when this field appears in a customer portal: No


I had forgotten the quotes around each name. 

[Kai Becker · Accepted solution]

Hi @Scott Schellhardt 

what is your current approach? What attributes does your object have?
You should be able to filter by label if the number is in the label attribute.

label in ("1","2","3","4","5")