'where' in Category Section

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

Archived
Reply
Reply

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-

Re: [aev] 'where' in Category Section

Archived
Reply
Reply

By Jason - June 8, 2010

Hi,

There isn't an option in getCategories that allows for a "where" statement. What you could do is select all of the categories, then filter out the ones you don't want when you're doing your foreach loop.

Hope this helps.

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/