Hello Carly,

The idea of both table social_fields and social_fields_data is that the social_fields store the information for each field. For example, Address field. let say the ID for Address field is 134. This ID will be later used in social_fields_data table. Then, we go to the next table: social_fields_data. This table is used to store the data for each user's field. The field_id column is where the ID of the field is stored. Example here is the ID of the Address field: 134. The uid column is the user ID and the data column is the data for that field and for that particular user ID.

Hope this explanation helps.

Hi Nik,

Thanks for the reply.
That's exactly what we needed.

A further question - the datakey in the social_fields_data table is sometimes blank but on other occasions have the data in - for example JOOMLA_FULLNAME have datakey = name / last / middle and first.

Is there a way to always have the datakey to contain the content type - ie MOBILE has a blank datakey.

Hope that makes sense.

Thanks
Carly

Hey Carly,

I am really sorry for the delay of this reply as it is actually a public day off for us here. The "datakey" column on the fields data table is just a friendly unique identifier for apps or APIs to be able to retrieve field specific values.

For instance, if there is 2 textbox fields with a different id, it is impossible to distinguish them. Hence, we introduced the field key property which users can define if they need to.

Hi Mark,

Where would we define the field key property so we can always have the friendly version for each column.

Thanks
Carly

Go to your profile type, click on the custom fields tab. Then, click on any custom fields that are on the form and there is a properties that would appear beside the field. Then, click on the advanced tab.

Hi Mark,

We have a value in the unique_key on the advanced tab but that doesn't appear in the social_fields_data under datakey.
As an example, when we look in that table for the FULLNAME values we have datakey's with values of name, last, first and middle.
But for "GENDER" the datakey value is blank. Is it possible have the word "gender" in there?

Thanks
Carly

Sorry my bad, that is actually the `unique_key` column for the #__social_fields table. The datakey column on the #__social_fields_data are being inserted by the app itself. There's no way to automate inserting this. This is an identifier if the field stores multiple rows of record on the data table.

If you want to lookup for gender, you should join with the #__social_fields table by their unique key of GENDER