Insight IQL filter by Object Schema

[Dieter Gasser]

Hi all,

I am using two Object Schemas in Insight, both of them contain an Object Type with the same name.

I expose objects through a custom field to Jira. For this, I am using an Asset Type Configuration with the following IQL definition:

objectType="Software Asset"

This returns all objects of type "Software Asset" from both schemas.

How can I create an IQL query that filters by object schema so that only Software Assets of one schema are returned?

Any hint is greatly appreciated.

Regards,

Dieter

[Hakan Bahadir · Accepted solution]

Hello,

You may also filter according to the Object Type ID. For example IQL can be: 

objectTypeId IN (99)

Insight Cloud IQL documentation has more examples.

You can find the Object Type ID for your "Software Asset" on the Object Type configuration page.

(Using ID's is also better then Names. Because Object Type Names may be changed in time and that would mean an update for all IQLs.)

FYI

Hakan Bahadir

Solutions Engineer

[Dieter Gasser]

Hi Hakan, thanks so much for the reply, this fixed my problem. It's a shame I didn't notice this option myself :)

[omar infante]

I am also running into this exact same issue as Dieter, on Jira Cloud. I have to schemas and both include an Object Type named "Hardware." Any insight (no pun intended) would be greatly appreciated.

Thanks!

Omar