nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Walter Buggenhout

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!

All comments

Walter Buggenhout

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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk-server

insight

iql

jira-service-management

jira-service-management-server

aql