Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to run IQL query across multiple object schemas?

James Jam July 8, 2022

Hello,
is there any way to perform an IQL query on multiple object schema?

I have objects on one Object Schema that are related to multiple objects in different Object Schema like this:

 

sample.png

I would like to be able to perform a query that finds all objects connected to e.g. Object A1

 

this type of query is very important for my company, any help is greatly appreciated.

thank you

 

1 answer

1 vote
PD Sheehan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 11, 2022

The only way I know is to use a groovy script:

 

import com.atlassian.jira.component.ComponentAccessor
import com.riadalabs.jira.plugins.insight.channel.external.api.facade.IQLFacade
IQLFacade iqlFacade = ComponentAccessor.getOSGiComponentInstanceOfType(IQLFacade)

def iql = 'object having inR(objectType="Object A1") OR object having outR(objectType="Object A1"))'

iqlFacade.findObjects(iql)*.objectKey

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events