[% # requires corresponding entry in M::Roles::Query::_build_search_fields_map()
options = {
'Biopsy site' => 'biopsy_site',
'Clinical details' => 'clinical_details',
Comment => 'comment',
Diagnosis => 'diagnoses.name',
'First name' => 'first_name',
'Gender' => 'gender',
'Gross description' => 'gross_description',
'Last name' => 'last_name',
Location => 'display_name',
Morphology => 'morphology',
'NHS number' => 'nhs_number',
'Patient notes' => 'patient_notes.detail',
'Presentation' => 'screens.description',
Referrer => 'referrers.name',
'Request notes' => 'request_general_notes.detail',
'Results summary' => 'results_summary',
Specimen => 'sample_code',
'Trial/study' => 'trial_name',
'Unit number' => 'unit_number',
'Remote ID' => 'foreign_id',
'Fluidx vial ID' => 'vialId',
# Reporter => 'report_by', # more complex - needs a 2-col search
# Screener => 'screener', # - " -
# 'New diagnosis' => 'new_diagnosis', # need to know ENUM opts
# 'Molecular result' => 'molecular_result', # combined into 'results summary'
# 'Flow result' => 'flow_result', # - " -
# 'FISH result' => 'fish_result', # - " -
# 'Genetics result' => 'genetics_result', # - " -
};
IF c.cfg('settings').item('_centre').match('^genomics$');
options.${'Family ID'} = 'family_id'; # view table only exists in genomics db
END;
admin_options = {
'Patient ID' => 'patients.id',
'Request ID' => 'requests.id',
};
%]
[% PROCESS site/popup.tt height=800, width=650, top=50 # defines onclick_event %]
Simple SQL Query
[ Help ]
[% div_name = 'simple_sql'; INCLUDE site/snippets/toggleview.tt %]
[% class = c.query.param('sql_simple_search') ? 'visible' : 'itemhidden' %]
[% IF dfv_errors; # PROCESS dumper.tt dump = c.stash.errs %]
Error - one or more fields missing:
[% END %]