the issue (in my experience) is that it won’t return unique values… because you can’t do an search:fieldname=”=exactmatch”... and without the “=exactmatch” you may get returned results that you don’t want
let’s run through an example:
fieldname = artist_medium
options:
ink
pastel
oil
pencil
chalk
soil (i put this one in to support my example… although there may be some soil artists out there…)
I create a template to pull articles about different media (mediums?)
mysite.com/mediumtalk/article/
and in this article page, I use {segment_3} to drive the content…
{exp:channel:entries channel='medium_articles' search:artist_medium='{segment_3}'}
So I load up my URL:
mysite.com/mediumtalk/article/oil
This *should be* a list of all my oil articles… but those blasted soil people keep crashing my party:
BECAUSE the field_id_123 field is storing the checkbox content as pipe delims:
Ink/Oil/Chalk article is stored like this:
“ink|oil|chalk”
Pencil/Soil is stored like this:
“pencil|soil”
BOTH return positive for
search:artist_medium=‘oil’
AND NEITHER return positive for
search:artist_medium=’=oil’
{exp:channel:entries channel='medium_articles' search:artist_medium='={segment_3}'}
.... SO - you can do a search on the fields, but you can run into problems with getting the exact results you are looking for…
and, no, I have no idea about a plugin that will solve it - although there may be one out there.