Hi.
I need to make a Qyery that excludes a subset of products depending on wether a customfield ("internalnumber" as string) starts with a known string.
The expressions includes the "usual suspects": active, languageID and Parentgroup IDs all en one group.
Then i make another group set it to "Negate" and add internalnumber to Contains my known string ("000500") as my expression.
The result is "no results".
if i flip the "Negate" i get only the products where internalnumber starts with 000500.
I have tried every possible combination of setting the expressions up, different kinds of nesting and ordering, but cant get it to work.
Is it possible at all the to make that kind of quering ?
/Kenneth