where clause syntax - two conditions

2 posts by 2 authors in: Forums > CMS Builder
Last Post: October 14, 2010   (RSS)

By Deborah - October 14, 2010

I have a where clause filtering condition I've not needed before. I would like to filter detail page results matching these two conditions:

1) category match ("multi-checkbox list field from another table)
AND 2) not archived (single checkbox)

I currently have the category filtering fine with:
'where' => "category = \"Artist\"",

I've not been able to add the AND condition for the archiving without receiving a syntax error. Have tried the following:
'where' => 'category = \"Artist\" AND archived !== 1',
'where' => 'category = \"Artist\" AND archived !== "1" ',
'where' => " category = \"Artist\" AND archived !== 1" ,

I'm hoping someone here can help with the syntax. Thanks in advance.
~ Deborah