Hello everyone,
in the company i work for we startet using item attributes.
For example some articles have been getting the attribute "exclusive" (attribute id 17) with the values "exclusive - Germany" (attribute value id 345) or "exclusive - Dicount" (attribute value id 346)
If I am in the item list I can filter for the attribute "exclusive" with the value "exclusive - Germany". But I would like to see all items that DON'T have an attribute "exclusive". How do I do this?
And I am actually asking because I want to create a report (with Jet Reports) with exclusive items in one excel sheet and all non exclusive in a different sheet. The first part is easy. I filter all items that have the attribute id 17 and attribute value id = "*". But I struggle with the second part. Nothing I have done works so far. If I say attribute value id <>345&<>346, or attribute id <> 17 it still lists all the items because they do have a lot of other attribute ids and attribute value ids.
I hope can help me with it.
Thank you very much.
