histology block refs displayed in year groups; changed date ref to 16 char string for recorded delivery info; returned list of records updated instead of redirect to redisplay block ref worklist

bugfix to outreach/demographics.tt - patient_id => patient.id; minor tweaks to get_request_id_from_lab_number()

replaced M::Request::get_request_from_lab_number() method using multiple db lookups with get_request_id_from_lab_number() using single db lookup

moved previous doi sample lookup to RecordHandler::_get_request_options()

record summary displays previous doi warning if previous doi but not current record; outreach questionnaire fixes; new diagnosis validation - submission of sub-category requires icdo3

error codes at registration logged in history file

fixed missing specimen error - caused by submission of 'BMAT.PB' - RDBO 0.80 truncated at 4chars; moved specimen split regex to Local::Utils & added validation of specimen length; fixed ErrorHandler error in assuming exists - didn't for devel server; added Sphinx search facility - switchable on/off via config; changed bcl1 to cyclinD1 in gallium trial data feed

added new params to outreach biochem; began Sphinx search integration

added more testing for specimens in new_request - still have issue with null entry in request_specimen table; new request validation forces specimen code to uppercase; gallium trial script tweaks; t/test-lib.pl switches off foreign_key_checks before re-building tables

added RIE/SMS logger; patched M::Request::new_request() to catch empty @specimens array; minor tweaks to outreach path_request_forms; updated Makefile.PL with deps

patched C::Search::do_search() & M::Request::get_request_id() to capture undef request_id error - occured when request_specimen entry was empty (should be impossible)

completed outreach overdue pack notification function; moved logic to skip if notification already sent from template to model; separated outreach worklists from other worklists; switched off PDS lookup for test scripts; patched validation_profiles/admin.t consistent with change to username validation

MAJOR CHANGE: moved sql_lib() from M::Base to new M::Role::Query; moved all M::R::QueryFormatter methods into M::R::Query; removed sql_lib() from ScriptHelpers - using new M::Roles::Query method; removed lims_dbix() from M::Base - now loaded via M::Role::DBIxSimple on demand; moved get_sql_with_constraint() from M::R::DBIxSimple to M::R::Query; method gets dbh from lims_db not lims_dbix in M::LabSection::update_lab_sections() & M::Specimen::update_specimens(); added elements() to Local::QueryLibrary

query speed enhancements

fixed M::Request::get_new_and_relapsed_cases() to correctly handle org_code as scalar or arrayref; simplified print-run section to retrieve request ids from excluded locations; refactored & speeded up some slow audit queries