Thread

I’m an EE noob, but have a lot of experience working with Drupal, Wordpress, and back in the day I rolled my own CMS quite a bit. I’ve done some hunting around the forums, wiki, and user guide and have struck out finding an answer for a pretty basic question (which may be way I’ve struck out).

I just want to filter the entries of a channel based on a key/value pair.

This is my channel code in the template:

{exp:channel:entries channel="boxes" limit="3"}

I just want to add something like “WHERE position=“left”. The expression engine equivalent to:

SELECT * FROM somewhere WHERE something="boxes" AND position="left" LIMIT 3

Position is a channel field (select list) with options for left, middle, and right.

Possible answer my own question:

I was thinking about it, or a work around, and that would be to create 3 different channels, one for the left, middle, and right. Then include the same field group into each channel. Which from what I’ve read, is pretty much the purpose of field groups.

I’d just like to reduce confusion for the user by reducing their options when creating and editing content.

So, is that the answer? Create 3 channels and use field groups as opposed to one channel and filtering by a field’s value?

Hi,

You can use the search parameter for filtering

http://ellislab.com/expressionengine/user-guide/modules/channel/channel_entries.html#search-field-name

That’s exactly what I needed. Thank you so much.

Hey torqed,

I am glad to see that the community was able to help you out! That is so AWESOME!

Have a great weekend!

Cheers,