Developer forum

Forum » PIM » Shared query excluding products published to e-commerce channel

Shared query excluding products published to e-commerce channel

Davy Capiau
Reply

Hi,

Using shared queries for the workflow step, I want as a final required step to list all products that are not assigned to (a group in) the e-commerce channel. This allows the user to publish the products to the correct webshop category.

My products are assigned to warehouse groups. On a database-level it's the same thing, so I can't use group-system fields. Any idea which I can use in my query conditions to achieve this?

 


Replies

 
Søren Jensen Dynamicweb Employee
Søren Jensen
Reply
This post has been marked as an answer

Hi Davy,

I think you can use something similar as shown on below screendump..

Use the "Negate" function to get the opposite result

/Søren

 

Votes for this answer: 1

 

You must be logged in to post in the forum