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
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
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
