Help appriciated: Contain keyword(s)

[magnus.kanholt]

Hi folks im trying to search thru some records of products(things). each things has a field called tags. in that field i store a comma separated string of color among others things. like color:Brown, color:White, color:Yellow

when i search with one or two keyword i get items returned but when i search with three key words i get no items returned - although the keywords exists in a number of things.

have i mised something on their behaiviour of contain keyword(s)?

[magnus.kanholt]

more information on this:
my query looks like this:

the above dosnt work.

however this works:

this does not work:

I would so appriciate if someone would share their thoughts on this.