Hooks/item browse sql

Parameters

  • $select -- an Omeka_Db_Select object
  • $params -- additional params for the query

Example

function categories_item_browse_sql($select, $params)
{
    if (($request = Zend_Controller_Front::getInstance()->getRequest())) {
        $db = get_db();
        $category = $request->get('category');
        if (is_numeric($category)) {
            $select->joinInner(
                array('ci' => $db->CategoryItem),
                'ci.item_id = i.id',
                array()
            );
            $select->where('ci.category_id = ?', $category);
            $select->group('i.id');
        }
    }
}