Insight - get a list of objects with empty references

[Marek Mikeš]

Use case:

I would like to delete several objects (which could include references). They are all of different object types. And I would like to be certain that I do not erase objects with active reference (inbound or outbound).

Normally, if the objects were the same type I would be able to use IQL query ('object not having inboundReferences() AND object not having outboundReferences() ') and determine such objects.

But I struggle with finding the suitable answer for different object types. Is there a way to query a list of all objects which do not have filled inbound or outbound references? Either in Insight or SQL?

[Nader Nassif]

Hi Marek,

Currently you can use the following IQL : 

objectType in objectTypeAndChildren(ObjectTypeName) AND object not having inboundReferences() AND object not having outboundReferences()

However, You will have to replace ObjectTypeName with each of your objectType as it only supports objectType names and their IDs.

You can open a feature request if you wish to add wildcard for example to that query. To do that kindly visit https://jira.riada.se which is Insight's open ticket system for feature requests and verified bugs. You can view, watch, vote etc for issues reported by anyone.
If you can't find an already opened feature request for this, feel free to create a new one.

Cheers!

Nader