Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Thursday, October 17, 2013 12:50 AM | 1 vote
Hi,
I'm a site collection administrator. But i'm not able to find the survey response which is incomplete status. so how to i find the incomplete survey response user names and inform them to complete. Please help
All replies (11)
Thursday, October 24, 2013 5:28 AM âś…Answered
Hello maxi prakash,
I think there is bit confusion so just bit more clarification about survey:
1. If you have implemented branching logic then you have "Save and Close" button to save incomplete survey in "show all responses view". Later you can open same survey response and you will be able to complete it by click on finish button. But if you click cancel then saved response will be deleted from view and there will be no response. (see both the pics, where second pic of saved response and "completed" is no).
Hope it could help
Hemendra:Yesterday is just a memory,Tomorrow we may never see
Please remember to mark the replies as answers if they help and unmark them if they provide no help
Thursday, October 17, 2013 5:15 AM
Hello,
SP does save incomplete survey until they finish so you can only view complete survey via UI. However you can query them in DB but not recommended so be careful when you query content DB.
http://yagyashree.wordpress.com/2012/09/26/how-to-find-total-number-for-incomplete-surveys/
Hemendra:Yesterday is just a memory,Tomorrow we may never see
Please remember to mark the replies as answers if they help and unmark them if they provide no help
Thursday, October 17, 2013 3:25 PM
I'm able to achieve with CAML query. Your CAML query should follow below.
1. Each question is created as Title. Example if my question title is 'Question1' you can see column named Question1
2.CAML query - where (question1 is null or empty) or (question2 null or empty) is your result.
3. You can find out all the column names from list settings.
4. Add viewfields as below.
<FieldRef Name="Question1" />
<FieldRef Name="Question2" />
<FieldRef Name="Author" />
Bala
Friday, October 18, 2013 12:03 AM
Hi Hemendra,
Thanks for your reply. I just want to know is any other way we can find the incomplete survey response details. because, i don't have access for the DB. is this one of the disadvantage of sharepoint 2010?
Friday, October 18, 2013 4:40 AM
I am not aware about any default way, which can give the incomplete survey result. Infect this was also problem with earlier version (MOSS 2007).
Hemendra:Yesterday is just a memory,Tomorrow we may never see
Please remember to mark the replies as answers if they help and unmark them if they provide no help
Friday, October 18, 2013 5:40 AM
Just figured out the simplest way of doing this job.
1. Export excel on survey list
2. Apply Filters on excel to see the incomplete responses.
Bala
Friday, October 18, 2013 11:24 AM
Bala,
I'd double check this. There's a difference between an incomplete survey that a user hasn't reached the end of and a full one that's had optional questions ignored.
Hemendra is right when he says that SP Surveys are only stored locally until they're fully completed.
Sunday, October 20, 2013 11:22 PM
Hi Bala,
Thanks for your reply with screen shot. I was done the export excel on survey list. but i can only export complete responses.
Wednesday, October 23, 2013 12:24 PM
Prakash-
This exports all the responses in the list. You can apply filters in excel to compute incomplete responses.
Bala
Friday, March 9, 2018 3:41 PM
So just to tack on an additional question for further clarification as I am in a same situation.
Where I have a survey, the survey reports result number of 11.
Now when I go to the Sharepoint CA server and use powershell and grab the list object.
$list.Itemcount results in 11.
But $list.items | Select Id, Name results in 4 items.
Where are the other 7 items?
What is exactly counted in the Item count of a survey list?
In other lists, the item count is comprised of folders and items.
So going down that path. I did a
$list.folders.count result is 0.
$list.rootfolder.subfolders result in 5 folder.
Ok we are getting somewhere.
But 5(subfolders.count) + 4 (items.count) only = 9 where are the other two counts coming from?
Are items that have been deleted from a survey still counted if they are in the recycle bin?
Tuesday, October 15, 2019 1:39 AM
Hi @Bala, does this mean you can see the incomplete survey answers for each question?