Developer forum

Forum » PIM » PIM query that finds all products with NULL or 0 as value

PIM query that finds all products with NULL or 0 as value

E-mail notifications
Søren Jakobsen
Reply
Posted on 23/09/2021 10:53:25

Hi community,

is it some how possible to create a query in PIM that returns all products with NULL or 0 as a value in any field on the product?

Can it be done without adding all fields to the query as below?


Replies

 
Nicolai Pedersen
Posted on 23/09/2021 13:05:05
Reply

Hi Søren

That is not possible out of the box. You would have to add a field to the index that can return true or false if any field is empty. Potentially that can be 1000s of fields per product....

BR Nicolai

 

You must be logged in to post in the forum