Getting a list of the field values

Hi,

I'm trying to retrieve a list of field values for a particular field. I've tried tabs, getField, etc, with no luck.

I've finally managed to just do it through joomla query, but was curious if there's a way to do it using CB?

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('fieldid', 'fieldtitle', 'fieldlabel')));
$query->from($db->quoteName('#__comprofiler_field_values'));
$query->where($db->quoteName('fieldid') . ' = '. $db->quote('56'));
$db->setQuery($query);
$results = $db->loadObjectList();

thanks.

We just use a database query. See the below file for core field code where you can review how select fields are built.

/components/com_comprofiler/plugin/user/plug_cbcore/cb.core.php