+ Reply to Thread
Results 1 to 5 of 5
Thread: Data Extraction help
-
04-17-2008 10:50 AM #1MLund Guest
Data Extraction help
When querying the database to extract user responses for a survey directly, I am pulling information from "outdated" questions.
EXAMPLE
If I deleted a question from a survey year-over-year, the answer remains in the database. When looking at the user response through the view user response feature, I do not see these old answers, however I am getting them in my extract query. What criteria can I use to limit out the responses from modified/deleted questions?
-
04-17-2008 11:05 AM #2
Administrator
- Join Date
- Mar 2007
- Posts
- 385
In both Ultimate Survey and Checkbox deleting a question deletes all associated responses. In an effort to prevent the accidental loss of data we switched to soft deleting many resources in Checkbox. I suspect you will want to modify your query to filter results based on the value of the Deleted column.
-
04-17-2008 11:17 AM #3MLund Guest
Follow-up
Thanks, however in most cases, I will not have the specifics for a deleted question, from the survey designers. Is there a way using the database that these questions and responses can be identified (deletion date)?
How does the system identify these outdated items, for the view individual responses feature?
-
04-17-2008 11:19 AM #4
Administrator
- Join Date
- Mar 2007
- Posts
- 385
I am not sure I am understanding your question. If the value of the Deleted column is set to 1 the item has been deleted.
Are you trying to do something other than filter out deleted questions? If so please explain what it is you are trying to accomplish in more detail.
-
04-17-2008 11:26 AM #5MLund Guest
Thanks
Nope, I think I am all good. Thanks for the help.
If I hit any snags, I'll repost.


LinkBack URL
About LinkBacks
Reply With Quote
