addNullQuery

[Jamsta1912]

Hi all.

I'm trying to add a null query to a GlideRecord, eg "target.addNullQuery('myfield');". In this case, 'myfield' is a reference field, so I'm trying to return records where the reference field is empty. But no results are being returned, although I know there are records where the reference field is empty. Am I using the method incorrectly? How would I add a query condition to return records where a reference field is empty?

Thank you.

[Jamsta1912 · Accepted solution]

Ignore me please all... after returning to this after some sleep, I've realised I was overlooking something obvious!

[bianca_vaccarin]

Could you share your solution with the community, just in case someone searching for it stumbles upon this post. Thank you!