Question.

I know the Voter ID, and the Survey ID. How can I find out via a SQL Query, if the user.

1. Completed the survey
2. Passed (there is a score bound to each question, and I display the Completion Condition (with passing score rule) to disply a differnt screen

Hello,

Through Sql:

* completed survey example: 
Select * from vts_tbvoter where surveyid = 22 and voterid = 1057
If: Votedate is not null and validated = 1 -> survey is completed

* to check if a voter 'passed' (i.e. reached a certain score)
- you will have to create a query to (re)calculate the score based on the voters voteranswers and the scores as registered in the answers table
- there is no single field registering what completion message was shown


 

---

Kind regards,
Survey™ Project Coordinator


SP Community: http://www.surveyproject.org
SP Sources & Downloads: https://github.com/surveyproject
SP Test & Demo: http://www.surveyproject.net
SP Founder: http://www.w3devpro.com