Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

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

  • dweisser
  • dweisser's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 years 9 months 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.

 
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months 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.
The topic has been locked.
  • dweisser
  • dweisser's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 years 9 months 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?

 
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 9 months 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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose