Unable to combine an exact match advanced search on a column with a sort
Chemistry's Hotwire instance has a view which contains a research_group_id column (ie a foreign key on a table of research groups; Hotwire also has a research_group_hid view to map the id to a name) and a hardware_name column which is an ordinary varchar. We have research groups named 'SPRI', 'Spring', and 'Sprik'. We want to generate a list of all rows whose research group is 'SPRI', sorted by hardware_name. To exclude 'Spring' and 'Sprik' we need to use 'Actions'>'Advanced search', pick 'SPRI' for the 'research group' and tick 'Exact match'. This generates the right set of rows. But when we then click on the column header for the 'hardware name' column in the results the exact match setting is lost, and the sorted results include 'Sprik' and 'Spring' rows. We can work around it by sorting on research group and then hardware name and ignoring the non-SPRI groups so it's not a major issue.
I observe the same problem in our instance when the column being searched on is a plain varchar rather than a foreign key column; eg in a personnel view searching on exact match for surname 'Smith' and sorting by another varchar column gives me results including 'Goldmsith', 'Arrowsmith' and so on.