Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

I am racking my brain - can someone help?

I have 2 object Types


    Attribute: Orgshort     value = Superstore

                                       value = funstore


    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?


1 answer

1 accepted

1 vote
Answer accepted
Walter Buggenhout _ACA IT_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 11, 2023

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! 

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


    Attribute: Orgshort     value = Superstore

                                       value = funstore


    Attribute:  Directorate_org      (outbound to Organization Object Type)


    Attribute: Division_Directorate (outbound to Directorate Object type)


    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

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!

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events