[
http://mifosforge.jira.com/browse/MIFOS-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau resolved MIFOS-2861.
-----------------------------
Resolution: Fixed
Fix Version/s: (was: Release E - Unscheduled)
New QG functionality replaces this
> Improve ease of reporting in surveys
> ------------------------------------
>
> Key: MIFOS-2861
> URL: http://mifosforge.jira.com/browse/MIFOS-2861
> Project: mifos
> Issue Type: Improvement
> Components: 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
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
