define custom list of outcomes for questionnaire

[Alex]

For most of our questionnaires full list of available outcomes is not required (for instance household-related or with self-completion). I've counted 12 (from our 37 total) outcome_id's never used over past year and noted a lot of case outcomes re-defined by administrators, caused by operators mistakes at most.

Would be great to set a selection of required outcomes as an optional parameter on a questionnaire basis.
For instance, in system general settings Administrator defines "default" list of outcomes (with some permanent /mandatory outcomes ), that could be customized for a questionnare.

Then we can display to operators and administrators only questionnaire-specific list of outcomes to choose from.

[Adam Zammit (adamzammit)]

This is a good idea.

I think the best way to implement this would be a page called "Questionnaire outcomes" and allows for the selection of outcomes from all possible from a list on a questionnaire by questionnaire basis.

We could create a new database table questionnaire_outcomes and all it would need is questionnaire_id,outcome_id,exclude. Can do a left join when selecting outcomes and if exclude is set to 1 then exclude. If doesn't exist or exclude is set to 0 then won't be excluded.

Adam

[Alex (ddrmoscow)]

Well, it's also a way to do it, but I was thinking of more simple and elegant solution:

- add parameter in "settings" table like "default outcomes list" (would keep "default" outcomes list for installation)
- add page (or sub-page) like "Manage default outcomes list" - to edit and save "default list"
- and a column to "questionnaire" table smth like "questionnaire_outcomes"
 -Upon questionnaire creation/editing - edit + save either selected or "default" outcome_id's ! comma-separated !
(thus we'll have already prepared string of values for IN() or NOT IN () sql querry without additional table / join or querry required)

Alex