Domain override via script

[davidmcdonald]

With domain separated records with overrides, I know that the overrides are obeyed using glideRecord.element.getRefRecord() (e.g. for a workflow or UI policy),

but is it possible to do so as part of a GlideQuery?

E.g. using gr.get(some_sys_id) to ultimately return the nearest domain override for a domain.

[Jim Coyne]

I think queryNoDomain() will do what you are looking for.

[davidmcdonald]

Afraid that queryNoDomain() just removes any domain separation from the query, I'm after a way to return the final result after all overrides are applied.

[The SN Nerd]

This should be what you are looking for:

http://wiki.servicenow.com/index.php?title=GlideRecord#addDomainQuery&gsc.tab=0

An example is provided on the wiki page.

[The SN Nerd]

Does the wiki example not solve this problem?

var domain = new GlideRecord('sys_user');
domain.addQuery('user_name', 'itil');
domain.queryNoDomain();
if (domain.next()) {
     var domainQuery = new GlideRecord('incident');
   domainQuery.addQuery('active', true);
   domainQuery.addDomainQuery(domain);
   domainQuery.query();
   gs.print('Number of Incidents for ITIL user: ' + domainQuery.getRowCount());
     while (domainQuery.next())
   gs.print(domainQuery.number);
}