What table(s) hold the survey question text

[geggolds]

I know that survey answers are stored in the RESPONSE and RESPONSEANSWERS tables (by ItemID). Now I need to find where the question text for each item is stored. Clues anyone?

[ncushing]

Hello,

The text of the question, and all texts in Checkbox, can be found in the ckbx_Text table. The textID in the table will vary depending on the type of item, but it will always end in /[ItemID]/text. So, if you want to find the text for item 2000, try searching for the value for the field TextValue in the ckbx_Text table where the TextID ends in '/2000/text'.

-Noah

[geggolds]

Thanks Noah.

Prezza's gotta be kidding on that one. That scheme makes it "impossible" to engage ckbx_text in a JOIN based on ItemID. That's nuts.

Have you ever had to JOIN to this table? If so, what did you do? The only solutions I can think of involve stored procs or temp tables.

Greg

[ncushing]

We don't join on that table. Since survey items and their configuration are self-contained and because the item infrastructure supports user/3rd party items, it is up to each item to maintain it's own text and other configuration. As a result, Checkbox core code can't assume that an item's text is maintained in that text table, though the out-of-the-box items do store that data in the table.

In Checkbox, all text is accessed through a Text Provider object with a text identifer and language code, so the database is queried for specific text strings rather than joins against item id. The text provider also has optimizations, such as caching, to improve performance.

A secondary reason text exists in this table is to support import and export of text data from the sytem for translation purposes. The table contains all application text, not just text for survey questions.

Thank you.

[pwiesner]

If you could explain in more detail what you are trying to accomplish we may be able to provide a suggestion on how to do it.