Where is the participant's Custom Attributes' name stored?

More
6 months 3 weeks ago #217645 by dweisser
Where in the database is the attribute name "Gender" stored? I expected it in in the ls_participant_ tables but these seem to be about the Central Database. 
I've tried adding participants in a tokens table then adding them to the central database. I cannot see where the name Gender gets attached to the attribute_1 as in the attachment. 

Thank you for any insight.

 
Attachments:

Please Log in to join the conversation.

More
6 months 3 weeks ago #217647 by tpartner
I found it in the lime_surveys table, attributedescriptions column.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
6 months 3 weeks ago #217649 by dweisser
Ok Thank you! I see it now....now I have to figure out how to disentangle this array so that I can pull it out and use it.
I am trying to present on a website the ability to query the responses by the token attributes as in "Show me all the Males."
In order to do this I'll have to show Gender and each value for Gender (M,F) in a dropdown or something. The attached array doesn't have Gender's values associated....so any thoughts on where those are?

 
Attachments:

Please Log in to join the conversation.

More
6 months 3 weeks ago #217652 by tpartner
You will find the attribute values in the lime_tokens_[SID] table. The column names there are attribute_1, attribute_2...

Or, with the API list_participants method.

- api.limesurvey.org/classes/remotecontrol...od_list_participants

- forums.limesurvey.org/forum/can-i-do-thi...tom-attribute#203392

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now