'where' in Category Section

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

By aev - June 8, 2010

Hi,

I'm trying to use a 'where' statement to filter records in a Category Section, but I'm getting this error when viewing the webpage:
Category Viewer (nav1) errors
Unknown option 'where' specified
Valid option names are: (tableName, useSeoUrls, debugSql, selectedCategoryNum, categoryFormat, loadUploads, defaultCategory, rootCategoryNum, ulAttributes)


Here's my code:
list($productoverviewRecords, $productoverviewSelectedCategory) = getCategories(array(
'tableName' => 'nav1',
'where' => 'template="product" and _isFirstChild="1"',
'defaultCategory' => 'none', // Enter 'first', a category number, or leave blank '' for none
'categoryFormat' => 'showall' // showall, onelevel, twolevel
));

How can I solve this?

-aev-