I need the option of querying CANQL by Supra-region in the Region filter.
It is done when:
‘Northern’ can be in the region filter with a value of 'northern_supra'
‘Midlands & East’ can be in the region filter with a value of 'midland_east_supra'
‘South West Supra’ can be in the region filter with a value of 'south_west_supra'
This can be applied to cases and patients
Alter the existing 'patient.registry' filter to use value with region names (eg. 'eastern') as opposed to registry ID (eg. '96')
'68' will now be 'thames'
'72' will now be 'east_mids'
'93' will now be 'yorkshire'
'73' will now be 'north_east'
'94' will now be 'north_west'
'99' will now be 'west_mids'
'84' will now be 'south_west'
'70' will now be 'wessex'
'95' will now be 'London'
'96' will now be 'east'
'01' will now be 'limbo'
'00' will now be 'england'
As a person using CANQL,
I need the option of querying CANQL by Supra-region in the Region filter.
It is done when: ‘Northern’ can be in the region filter with a value of 'northern_supra' ‘Midlands & East’ can be in the region filter with a value of 'midland_east_supra' ‘South West Supra’ can be in the region filter with a value of 'south_west_supra' This can be applied to cases and patients Alter the existing 'patient.registry' filter to use value with region names (eg. 'eastern') as opposed to registry ID (eg. '96') '68' will now be 'thames' '72' will now be 'east_mids' '93' will now be 'yorkshire' '73' will now be 'north_east' '94' will now be 'north_west' '99' will now be 'west_mids' '84' will now be 'south_west' '70' will now be 'wessex' '95' will now be 'London' '96' will now be 'east' '01' will now be 'limbo' '00' will now be 'england'