I use SortHelper which provides for sorting by any column of the table.
With patient name I would like to have only one column. The combined
column could be 'name' as in:
select ..., lastname||', '||firstname as name from patients... order by
This column does not appear in the table itself. It is concatenated
column. Ordering by name would also provide for correct ordering. Can I
fool SortHelper to use such a fake column (not in the model) to work
Best regards, Zdravko