- Posts: 115
- Thank you received: 4
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
- Topic Author
- Offline
- Premium Member
Less
More
2 years 9 months ago #217645
by dweisser
Where is the participant's Custom Attributes' name stored? was created 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.
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10099
- Thank you received: 3589
2 years 9 months ago #217647
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Where is the participant's Custom Attributes' name stored?
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
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 115
- Thank you received: 4
2 years 9 months ago #217649
by dweisser
Replied by dweisser on topic Where is the participant's Custom Attributes' name stored?
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?
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:
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10099
- Thank you received: 3589
2 years 9 months ago #217652
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Where is the participant's Custom Attributes' name stored?
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
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.