Hi Mark, thanks for the swift support!

I think you misunderstood, I didn't want to get every instance of a specific key in the database, I just wanted to retrieve a users data. The code you pasted is broken, the quotes and typos are preventing it from working.

I will past a working example here for other people having the same problem. Thanks for pointing me in the right direction though, it was a perfect starting point!

Raw query suggested, to retrieve all of a single unique key (birthday) from the DB

Select

  b.data,

  b.raw

From

  uktnm_social_fields As a Inner Join

  uktnm_social_fields_data As b On a.id = b.field_id And b.type = 'user'

Where

  a.unique_key = "BIRTHDAY"

Raw query to get a users data. Getting data for user UID 32

Select

  b.data,

  b.raw

From

  uktnm_social_fields As a Inner Join

  uktnm_social_fields_data As b On a.id = b.field_id And b.type = 'user'

Where

  b.uid = "32"

Final code, getting formatted, associated key data only for a single user (user UID 32) from the db

require_once(JPATH_ADMINISTRATOR . '/components/com_easysocial/includes/foundry.php');



$db = Foundry::db();

$query  = array();



$query[] = "select b.data, a.unique_key from #__social_fields as a";

$query[] = "inner join #__social_fields_data as b";

$query[] = "on a.id = b.field_id";

$query[] = "and b.type=" . $db->Quote('user');

$query[] = "where b.uid=" . $db->Quote('32');



$db->setQuery($query);



$result = $db->loadAssocList('unique_key');

Which all works fine! However getFieldData also works on !Joomla standard data, an inbuilt method to get everything really would be handy.

Thanks for updating Anthony and glad that you found a work around (Sorry I was blindly coding with gist earlier)