question Re: What's the opposite of INSTANCEOF? in Developer forum

What's the opposite of INSTANCEOF?

grosch — Tue, 20 Oct 2015 21:55:21 GMT

I have a given class name, such as 'cmdb_ci_linux_server'. Now I want to find all the cmdb_model entries that would be a valid choice for an asset of type cmdb_ci_linux_server, so I started off like so:

var gr = new GlideRecord('cmdb_model');
gr.addQuery('status', '!=', 'Retired');
gr.addNotNullQuery('name');
gr.addQuery('cmdb_ci_class', 'INSTANCEOF', 'cmdb_ci_linux_server');
gr.query();

But that INSTANCEOF is backwards. Is there a way to flip that around? So basically I want to return all models where the cmdb_ci_class belongs to a table that cmdb_ci_linux_server inherits from. I want a PARENTOF type qualifier

Is there an easy way to do that, or do I just have to use TableUtils() and manually build up a big or statement?

Re: What's the opposite of INSTANCEOF?

paulmorris — Wed, 21 Oct 2015 02:10:06 GMT

Unless there is a undocumented operator that someone is privy to, you'll have to use TableUtils()

Re: What's the opposite of INSTANCEOF?

James Fricker — Sun, 30 Oct 2022 23:39:58 GMT

I would do it this way

var gr = new GlideRecord('cmdb_model'); gr.addQuery('status', '!=', 'Retired'); gr.addNotNullQuery('name'); gr.addQuery('cmdb_ci_class', 'IN', j2js(GlideDBObjectManager.get().getTables('cmdb_ci_linux_server'))); gr.query();

Re: What's the opposite of INSTANCEOF?

Rafał Rataj — Wed, 05 Mar 2025 10:12:57 GMT

you can use the class path

var childClass = gr.child.sys_class_path.toString();

if (childClass.startsWith("/!!/!2/!(/!!")){ // is Instance of server

children.push(childSysId);

}