Developer forum

Forum » PIM » Query for all products not in a group

Query for all products not in a group

Kim Søjborg Pedersen
Reply

Hi, I what to find all products not in a group so I can add them to one, but how do I make that query?

Ragards
Kim


Replies

 
Steffen Kruse Hansen Dynamicweb Employee
Steffen Kruse Hansen
Reply

Hi Kim,

I looks like the 'IsEmpty' operator is missing on array types, and this is a bug.

However there is a small workaround:

In the index you use for your queries, you can add a new field (see FieldSetup.png), and then you use that field in your query together with the 'IsEmpty' operator. (see QuerySetup.png)

Now you should get a list of all the product, which are not in a group.

Best regards

Steffen

 

 

FieldSetup.PNG QuerySetup.PNG

 

You must be logged in to post in the forum