Filter by record with multiple recorded value

4 posts by 2 authors in: Forums > CMS Builder
Last Post: August 31, 2011   (RSS)

Re: [ht1080z] Filter by record with multiple recorded value

By robin - August 30, 2011

Hey,

So you have a multi-value field 'proor' that you want to check for only one value? If so, something like this should help:

'where' => "proor LIKE '%\ta2\2%'",

Mulit-value fields are tab (\t) separated, so we look for the value you want, surrounded by tabs.

Hope that helps,
Robin
Robin
Programmer
interactivetools.com

Re: [robin] Filter by record with multiple recorded value

By ht1080z - August 31, 2011

Hi Robin,

I also find Dave's answer on this in the topic:
http://www.interactivetools.com/iforum/Products_C2/CMS_Builder_F35/Filter_by_record_with_multiple_recorded_value_P89807/gforum.cgi?post=87794;search_string=multi-value%20field;t=search_engine#87794

so i changed:

'where' => "proor LIKE '%\ta2\2%'",
to
'where' => "proor LIKE '%\ta2\t%'",
and worked perfectly.

Thank you for your support on this!

Re: [ht1080z] Filter by record with multiple recorded value

By robin - August 31, 2011

Hey, I'm glad it worked out for you even with my typo.

Robin
Robin
Programmer
interactivetools.com