AQL/IGL for all top level Object Types in a specific schema

Brian Peters_piqzwm

This seems like a very basic, fundamental question and I've googled and looked through online doc but am having no luck with this so far. 

I'm writing a groovy script using some classes that access the Insight API written by Peter-Dave Sheehan (which are quite useful, thank you Peter-Dave).  What I need is a list of keys for the object types populated in a given schema. 

I'm fairly new to Insight so my vocabulary may not be exactly correct so I'll try to describe it.  Let's say I have an Insight Object Schema called "Divisions" that defines an Object Type named "Department", each with an attribute named "Office".  We then create 3 Departments and fill out their Office attribute.  The hierarchy might look like this (please forgive my primitive formatting since this text editor tool is limited):

Example Object Schema

  Object Schema: Divisions

                        -----> Object Type: Department

                                                                 ------> Attribute: Office

So, the Divisions object schema contains an object type named Department with an attribute called Office. 

Example Object Types 

  Object Schema: Divisions

                        -----> Facilities

                                          ------> Office 123

                        -----> Marketing

                                          ------> Office 561

                        -----> Human Resources

                                          ------> Office 35

So, there are 3 Departments (Facilities, Marketing, Human Resources), each with an associated office attribute (Office 123, Office 561, Office35).

I need an IQL/AQL statement that returns a list of all the Department keys that have been added to the Divisions Object Schema (I ultimately be using the result to create JSON for a REST Endpoint) but I can't figure out how. 

Later I will need to grab the attribute values for each of these Departments as well.   

Thanks in advance!     

 

PD Sheehan

An IQL to return all the Department objects should be quite simple, it's just "objectType = Department".

Running this either in the Assets/Insight Search screen, or in the InsightUtils.findObjects()  method should return 3 objects. 

E.g.

import com.qad.common.jira.utils.InsightUtils

def iql = 'objectType = Department'
def departmentObjects = InsightUtils.findObjects(iql)
def departmentKeys = departmentObjects.collect{it.objectKey}
def departmentOffices = departmentObjects.collect{deptObject ->
    InsightUtils.getAttributeValueFromDotNotation(deptObject, 'Office', false)
}