If you just want to display a select field with all possible values in a column you can use the
{joodb groupselect} function.
If you want just custom search terms you must write a plugin and load it into
/components/com_joodb/plugins/PLUGINNAME.php
Example for
countries.php<?php
// no direct access
defined('_JEXEC') or die('Restricted access');
$db = $this->joobase->getTableDbo();
$db->setquery("SELECT `name` FROM `countries` ORDER BY `name` ASC");
if ($slist = $db->loadCollumn()) {
$output .= '<select name="search">';
foreach ($slist AS $var => $val) {
$output .= '<option ';
if ($val==$this->params->get('search')) $output .= ' selected="selected"';
$output .= '>'.$val.'</option>';
}
$output .= '</select>';
}
}
