How to write AQL to access multiple objects and related data using Assets?

Sandra Lawrence

I have a simple schema reflecting organization of projects using Assets.  I have 3 object types set up as:

Division - Name

Program - Name, Division  (associated to Division) and other data

Project - Name, Program (associated to Program) and other data

 

I am trying to use Assets/Search for Objects AQL and cannot seem to show the following: 

For each division, show each program and all associated projects.

How can I do what seems to be a simple AQL or report?

 

Iman Attia

If you have already populated the Division under the program (in this example "Department") Objecttype, then when clicking on Division you should see in the top RHS all inbound objects.

If you wanted to list the projects on that Division you could filter on Program by: 

object HAVING outboundReferences("Division" IN (${Division}))