Insight AQL - please help! Cannot get it to work.

[Sandra Lawrence]

I am racking my brain - can someone help?

I have 2 object Types

Organization

    Attribute: Orgshort     value = Superstore

                                       value = funstore

Directorate

    Attribute:  Directorate_org      (outbound to Organization Object Type)

I am trying to find all Directorates that are part of Organization = Superstore

I've used the following queries and get zero hits...augh

objectType = Directorate AND "Directorate_org"."Orgshort" = Superstore

I've also tried without " " -  

objectType = Directorate AND Directorate_org.Orgshort = Superstore

What am I doing wrong?

[Walter Buggenhout _ACA IT_ · Accepted solution]

Hi @Sandra Lawrence,

Have you tried the following:

objectType = Directorate AND Directorate_org = Superstore

assuming that Directorate_org is an attribute of the Directorate object type

Hope this helps! 

[Sandra Lawrence]

WooHoo!  It worked great!  If I may, let me ask you this next-level question:

How would you set up a query if you had 4-levels of Object types you needed information/data from?  For example:

I have 4 object Types

Organization has 1:x Directorates which has 1:x Divisions which has 1:x Programs

Organization

    Attribute: Orgshort     value = Superstore

                                       value = funstore

Directorate

    Attribute:  Directorate_org      (outbound to Organization Object Type)

Division

    Attribute: Division_Directorate (outbound to Directorate Object type)

Program

    Attribute:  Program_Division (outbound to Division object type)

Am I able to write a query that would allow me to see for a selected Organization:

- all Directorates, and within each Directorate, all divisions, and within each Division, see all programs?

Organizaiton A

[Sandra Lawrence]

Here is a layout of logic (not necessarily a format):

Organization A   

    Directorate A

                Division A

                      program a1

                      program a2

                Division B

                      project b1

    Directorate B

                Division C

                      program C1

                Division D

                      program D1

                       program D2

I am not sure if I can (for lack of a better term) "group" this way in a query.  Any guidance would be awesome!  Thank you!