AQL that returns all attributes where value is TRUE (boolean type)?

[Barret Margin Jr]

I am working on a HR portal/project that is connected to JSM Assets.  One of the object types is Role where I have a matrix of what company resources is needed for that role.

I'm struggling with creating a query that will return all attributes for that role where the value is TRUE.

Let me know your thoughts or any questions you may have. Thank you!

[Kris Dewachter]

Hi @Barret Margin Jr ,

Welcome to the Community.

I'm not sure I understand your question correctly. Do you want to create an AQL query that finds your object(s), where any of their attributes is TRUE ?

If so, I don't think AQL supports that. You will have to include all attributes indivudually in the AQL.

Best regards,

Kris