Search on an empty field

[christianv]

Hi everyone,

I'm trying to do a 'find' action with an empty field...

I tried '...&MyField=""', '...MyField=''', and nothing seems to works...

Anyone to help me?

Thanks!

[evildan]

Let me get this straight, you are looking to do a search FOR an empty field?

Meaning you want to find all the records that have nothing in the field named "MyField"?

[Garry Claridge]

Sometimes, for this type of thing I have used a caluclated field which uses the 'isEmpty()' function. This calculated field returns the string 'empty'; or something similar. I then do the search on this string.

Hope this helps.

Garry