Querying Questions of Survey

[Joanne James]

I am querying the checkbox survey database. I can get the answers, but not the questions. I am trying to get the questions.
The question text I want to retrieve is in the ckbx_text.textvalue
I see that the textid which will link me to that is in
ckbx_ItemData_Message - (example textid: /messageItemData/12268/text)
but the Itemids that link to that string in ckbx_ItemData_Message,
are not the itemids in my ckbx_responseanswers table
can anyone tell me how to retrieve this
ie how to get the MessageItemData string from ids in the ckbx_responseanswers table. Are there some other tables that need to be linked to in between?

[pwiesner]

You do not see item id 12268 in the ckbx_responseanswers table because responses are not collected for message items. For answerable questions, select one, select many, single line text, etc the text is found in the ckbx_Text table as well. The TextID column is used as the key when retrieving text and is formatted ItemType/ItemId/text. For example /selectItemData/1258/text

When building reports and exporting responses, Checkbox dynamically generates the query used to retrieve the question text and answers. I would suggest connecting the SQL Server Profile to your database and running the export in order to capture an example of the logic used.