[
http://mifosforge.jira.com/browse/MIFOS-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukasz Chudy resolved MIFOS-2861.
---------------------------------
Resolution: Won't Fix
> Improve ease of reporting in surveys
> ------------------------------------
>
> Key: MIFOS-2861
> URL: http://mifosforge.jira.com/browse/MIFOS-2861
> Project: mifos
> Issue Type: Improvement
> Components: QuestionGroups/Surveys/PPI
> Reporter: emilytucker
> Assignee: mifosdeveloperqueue
> Fix For: Release E
>
>
> From Lassaad at enda:
> Those are the 2 main issues that I've had met when I tried to create queries
> from the surveys module:
> 1. Multiple values separated by a comma:
> Exple :
> The user will check the suitable choice:
> Marital status:
> Married
> Single
> Divorced
> The value in the database will be:
> RESPONSE_ID INSTANCE_ID SURVEY_QUESTION_ID FREETEXT_VALUE
> CHOICE_VALUE DATE_VALUE NUMBER_VALUE MULTI_SELECT_VALUE
> 95777 22103 60 ,1,1,0
> To make the data useful i was obliged to split the MULTI_SELECT_VALUE by
> creating a new table in another database with 3 separated values :
> RESPONSE_ID SURVEY_QUESTION_ID Value Choice_ID
> 95777 60 1 1
> 95777 60 1 2
> 95777 60 0 3
> 2. New questions are handled by lines instead of columns, that means : If
> we have 3 questions in our survey , to extract the data we will have to join
> 3 instances of the table survey_response.
> we have more than 80 variables query with 80 joins of 80 instances of the
> same table (survey_response) .
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
