How to query out fields that have an empty value with GlideRecord?

[Mitch Moses]

I tried this and it didn't work

current.addQuery('location', '!=', "");
current.addQuery('cmdb_ci', '!=', "");

[Mark Roethof]

Just tested with below code on Incident related list. No issues 😞 Only records with cmdb_ci are shown.

(function executeRule(current, previous /*null when async*/) {

// 	current.addQuery('cmdb_ci', '!=', '');
	current.addNotNullQuery('cmdb_ci');
	
})(current, previous);

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn

[Steven Herrmann]

Hey Mitch,

I believe using an encoded query will work for this.

Something like the below for example:

current.addEncodedQuery('locationISEMPTY^cmdb_ciISEMPTY');

If my reply helps you at all, I'd really appreciate it if you click the Helpful button and if my reply is the answer you were looking for, it would be awesome if you could click the Accepted Solution button!  🙂

I hope this helps, have a great day!

Steve

[Mark Roethof]

Ah that's a nice thought too!

[Mitch Moses]

I tried this one and went to another ticket that has some empty and some filled ones, but it gets rid of all of them 

[Mitch Moses]

This is so weird. So without trying anything you guys suggested I get this: 23 incidents 

And this for another incident: 9 incidents

Now when I add current.addQuery('cmdb_ci', '!=', "NULL"); or current.addNotNullQuery('cmdb_ci'); It gets rid of the empties in one incident, but not the other one??

21 incidents now:

9 incidents still: 

 Maybe this one incident is bugged?