Text comparison while applying a constraint

[magnus.kanholt]

Hi folks,

hope every is doing well.

im doing search for things where im setting a constrain using text and numerical id

but when i test it ruten no data:

so i remove the second constrain, then it works but i dont get the accurate data because of the constraint i removed.

is there an issue setting up constraints like this?

[mmahirf]

Does it work when you remove the first constraint and keep the second? And does the text you mention refer to the Producttype?

How about if you use the :filtered operator (client side). Try putting the AppliesToProductType on the :filtered.

[magnus.kanholt]

Hi there,

thanks for your answer.

if i remove the first constraint, no data is returned.
yes, the the text refer to the product type…

i will meanhwile test the fitlered, i belive i did that once and had no sucess but i will try again.

thanks for you help

[magnus.kanholt]

so trieid filtering, no success.

this would of worked in SQL but this is ofcourse different.

it almost seems likes there is problem in using texts in the constraint.

here is what the search bings back, before filtering i have a list of things(sorry about the two part screenshoots: