Project

General

Profile

SortHelper combined columns

Added by Zdravko Balorda over 9 years ago

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
name

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
with?
Best regards, Zdravko