Developer forum

Forum » Ecommerce - Standard features » Finding empty values in the index

Finding empty values in the index

E-mail notifications
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Posted on 23/03/2016 14:14:45

Hi there,

How can I find products that have an empty string / null value for a speciifc custom field? I don't see anything like "Is Null" or similar.

Thanks,

Imar


Replies

 
Nicolai Høeg Pedersen
Posted on 29/03/2016 08:55:16
Reply
This post has been marked as an answer

Tough one to begin the day with!

If a field has no value, it is not indexed - the field does not exist on the document. So what you want to do is search for records that has a value, and negate that.

You do that by adding an expression group, choose the field to search, choose a BETWEEN criteria, and specify an array of min and max value. Searching for an empty string would then be between * and zzzzz. See screen dump.

NP

Capture.PNG
Votes for this answer: 1
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 30/03/2016 00:55:56
Reply

Excellent, thanks. We'll give that a try.

Imar

 

You must be logged in to post in the forum