I have a small project that I'd like to get a bid on, and would like
to do the project is such a way that it can be incorporated back into
the 1.92 source (and 2.0 source, if it's still relevant there, I'm
hoping it's not needed there).
First, the project. I'd like a new table created that maps the survey
results table fields to question codes, and have this created upon
survey activation. In its basic form, the table would be
question_id (points back to the questions table)
SGQA field name (from the results_nnnnn table)
question_code (from the question) <redundant, since it can be looked
up from the questions table>
answer_code (if relevant)
misc (the COMMENT, OTHER, the exta fields that are sometimes
associated with a question or answer)
code: unique (within a survey) code that is made up of
<question_code>__<answer_code> and possibly (_OTHER or _COMMENT, if
Once that table is created, it will be much easier for me to write
custom reports based on the survey results. I can do an inner join
with the question table to get the questions and associated answer
options, and easily figure out how to display the responses in a
While I'm sure I can figure out a way to do this, I'd rather have it
done by a developer who already has the ability to commit, so others
can use this if they'd like.
Ideally, Expression Manager, Import/Export Responses and the email
templates would also be able to use these new codes, so that a csv
file could imported with row names like
"name,congressional_district,political_party" instead of
"21242X24X12", but that's where I hope version 2 will be different.
What is the best approach to find a developer who can add this table
to the core, assuming there's agreement that it belongs there.