Included tx_cycles in SELECT for treatments in local.sql. Displayed Cycles in treatment main table on main HMRN page.

RfC487 - order by name Outreach reports-to-print worklist; speed up slow query; provide direct print link

* fix outreach incomplete_dataset & missing_fields callbacks - returns 1 if data empty * replace all sql_lib->retr() with get_query() for use in outreach.t * amend local.sql to match month|week for followup_options * remove number of tests from column.t - keeps changing, use done_testing() instead * add worklists to outreach.t * replace broken incomplete_dataset() with missing_fields() on outreach questionnaire section

Refactor icdo_category table to include only sub-categories - renamed to icdo_sub_category

Genomics xml generation - replace sql-library queries with SQL::Abstract::More

fix non-utf8 apostrophe causing xml generation error

Genomics data - 9 new fields

add GQ to contacts list; new field for genomics_data

patch QueryLibrary to remove unwanted new-line marker caused by regex substitution

QueryLibrary always returns string via strip_comments() * no need to test for presence of comment as substutution regex fails anyway if pattern not present

QA - final tidy up of templates prior to merge

substitute remaining hard-coded 'hmrn' db-name with variable picked up from hmrn_db method * working hmrn_data.t

interim update; adapt HMRN model to load test hmrn database

add 3 new data items to genomics_data.pl; change die command to ok() for yml file check

Genomics - participant type evaluated by subroutine for genomics_data; use getopts for -t switch