View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
06692Bug reportsImport/Exportpublic2012-10-12 17:502012-10-13 08:03
ReporterDenisChenu Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06692: Unable to use filter for export survey answers.
Description

If you try to export survey answers with:
Completed responses only : all responses are exported
Incompleted responses: OK, working
Range : from 1 to 2 : all responses exported.

Steps To Reproduce

Try to export completed answers only a survey with some incompleted responses.

Additional Information

The system use
public function exportresults (from controllers/admin/export)
This one fill information ExportSurveyResultsService Class FormattingOptions. And after this one don't work like (from helpers/admin/export_helpers).

Something i don't understand :
Export from/to is a filter not a formatting option: need to put a WHERE on select
responseCompletionState too : put a WHERE in sql.

Here we SELECT whole survey DB (100 by 100), and after make some test if it's OK to write the row. (work for inc, not for filter *)

For example, with incomplete responses only, you can have a 1000 line select for just 6 line ...

(* quickly try some patch but no way :( )

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)121011
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionMysql 5
Server OS (if known)debian/linux
Webserver software & version (if known)apache
PHP VersionPHP Version 5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-10-12 18:19

administrator   ~21273

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9750
c_schmitz

c_schmitz

2012-10-13 08:03

administrator   ~21280

2.00+ Build 121013 released. Please update.

Related Changesets

LimeSurvey: master fb473126

2012-10-12 11:19

c_schmitz


Details Diff		 Fixed issue 06692: Upper range limit ignored on exporting results Affected Issues
06692
mod - application/helpers/admin/exportresults_helper.php Diff File
mod - application/helpers/common_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-10-12 17:50 DenisChenu New Issue
2012-10-12 18:18 c_schmitz Assigned To => c_schmitz
2012-10-12 18:18 c_schmitz Status new => assigned
2012-10-12 18:19 c_schmitz Changeset attached => LimeSurvey master fb473126
2012-10-12 18:19 c_schmitz Note Added: 21273
2012-10-12 18:19 c_schmitz Resolution open => fixed
2012-10-12 18:20 c_schmitz Status assigned => resolved
2012-10-12 18:20 c_schmitz Fixed in Version => 2.00+
2012-10-13 08:03 c_schmitz Note Added: 21280
2012-10-13 08:03 c_schmitz Status resolved => closed