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', '!=', "");

[ivaoen]

Looks like you have old sys id's stored in the CI field - so they are not empty - they have a sys_id that no longer has a refrence so using like NULL or isEmpty will not work here.