Hey,

This seems really strange to me, when using a node body exposed filter with the "contains" operator on a view containing fields from a CCK content type everything works fine for a single word but when using 2 words no results are returned everytime.

Using the same filter with multiple words works for every other text filed in the view including the node title. From what i can see the SQL query looks fine and the same as for the other fields which work.

I really can't figure this out, hope someone has more insight into this

Thanks

AlxM

Comments

dawehner’s picture

dawehner
Primary language German
commented

if the sql is quite the same, it could be a bug in mysql. did you checked whether the two words are behind each other in the body?

AlxM’s picture

AlxM commented

Yes the words are in the same order as they appear in the body, including a space just seems to give a blank result but only when used on the body field

esmerel’s picture

esmerel commented
Assigned: Unassigned » esmerel

This seems like it should be testable; assigning to myself.

Letharion’s picture

Letharion commented
Status: Active » Closed (cannot reproduce)

I can't reproduce this. If it's still an issue, please 1) try with a new version of views and 2) try running the query directly to the DB. If the problem persists, it's unrelated to views.