null in encoded query

[samadam]

I am trying to check if the field is null in an encoded query, tried using =NULL and ="" and doesn't seem to be working.

gr.addEncodedQuery('owner_group=wintel^state=6^assigned_to=""^EQ');

Any ideas?

Thanks

[Chuck Tomasi · Accepted solution]

Try ISEMPTY.

gr.addEncodedQuery('owner_group=wintel^state=6^assigned_toISEMPTY^EQ');

Don't forget, you can always build your query using the list builder and then right click on the breadcrumb and select Copy Query.

[Chuck Tomasi]

Example of what I described above...

active=true^ORassignment_groupISEMPTY

[samadam]

That worked. Thank you.

[Midhun1]

Hi,

You can use :

target.addNullQuery('field_name');