Hello,

I am trying to create a profile completeness bar module for the canidate profiles by using the profile completeness of CB.

I found the query build as belows:

//Build the query.
//SELECT fieldid AS value, name AS text, type
$allowed_types = "'text','multiselect','predefined','image'";
$query = "SELECT name AS value, name AS text
FROM #__comprofiler_fields
WHERE published = 1 AND type IN ($allowed_types) ";
// Set the query and load the options.
$db->setQuery($query);
$options = $db->loadObjectList();

By the way

Which table of jsjob has all the userfields?