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?
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}))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.