All of the answers to all of the questions are in the usd_ResponseDetails table.
...answers when you need them
Hi
I'm trying to learn some SQL querying and one of the things I've been looking at is learning the structure of the Ultimate Survey database under SQL.
My sample survey uses a matrix scale to pick a value of satisfaction. Out of interest where would these values be stored in the database/tables?
Cheers.
All of the answers to all of the questions are in the usd_ResponseDetails table.
John Fischer
Prezza Technologies
**This message post is provided with no warranties as to accuracy.
OK, thanks, can you point me in the direction of which column I should be looking for and does this column enter the actual value selected or reference elsewhere to a list of values?
For example, may scale has options 1-5, and 5 questions, if say someone chose all 3s, would 3 be the value shown in the row for that column.
I'm only just starting to work this all out; and as so much referenes other tables it's quite confusing for a beginner ;o)
Cheers.
We generally do not provide support that delves that deeply into the structure of the database. If you are a customer though, you can request a database diagram through our Help Desk.
John Fischer
Prezza Technologies
**This message post is provided with no warranties as to accuracy.
Thanks John.
I'm not sure that will help as I'm trying to identify specific answers through a survey I've created; hence just wanting to know if the values are stored as a value, number etc, obviously free text is easy to track down, but I'll check it out, got to be easier than the great big database diagram SQL Server produced!