How to know which User Submitted Survey and Which user does not?

How to know which User Submitted Survey and Which user does not?

Smile ,

This article is useful to know which user submitted complete survey and which user doesnot complete survey.

Just simply put condition on u list query "tp_level = 255" for getting all non-submitted (incomplete) responses. The below query just gives you the result for “ALL NON SUBMITTED (INCOMPLETE) responses”; for getting all submitted responses query will change to “tp_level = 1”.

Query Example

Non Submitted Response
=============================
Select userdata.tp_author,
(Select tp_Title from UserInfo where UserInfo.tp_ID=userdata.tp_author and tp_siteID='SiteID') As UserName
from USERDATA
where tp_ListId like 'LISTID'
and tp_level = 255

FOR Submitted Complete Survey
===================================
Select userdata.tp_author,
(Select tp_Title from UserInfo where UserInfo.tp_ID=userdata.tp_author and tp_siteID='SiteID') As UserName
from USERDATA
where tp_ListId like 'LISTID'
and tp_level = 1

	If you cannot love a person whom you see, Then How can you love GOD whom you have never seen -- Mother Teresa
From Pritesh Public Profile