Freigeben über

How to find user who have not completed the survey in database.

 

· At first find the content database where we have the survey list.

· Then look for the survey name and copy the corresponding  tp_id

· clip_image001

· Now run the query

SELECT    *

FROM         AllUserData

WHERE     (tp_ListId = 'eda75dbc-f91b-4a1f-a7a2-a9ef39d664ab')

· clip_image002

· It will give all the data is survey

· Now look at the end of the table you will find tp_CheckoutUserId if it null thenit is completed and if some value is there then it is not completed.

· Copy the tp_author for all those who are not completed

· Now open userinfo table and check the tp_login corresponding to tp_id

· clip_image003

· These are the users who still need to complete survey.

Comments