Hi, I'd like to sort table of patiens with lastname, firstname in the same column. Of course in the model Patient there are two columns, which I need joined while sortable. Is there any way to do that with SortHelper?
Regards, Zdravko
Can you be more explicit in what you want to sort on? Do you want to sort by lastname and then within those with the same lastname then sort by firstname? If so then just specify something like @patients.order(:lastname, :firstname)
Colin
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?
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?
No idea as I don't know what SortHelper is, and a quick google revealed nothing that looked in any way current. Why would you not want to do this the most efficient way which is likely to be when fetching from the database?
Note that if you just concatenate the columns you will be unlikely to get what you want, as you need it to sort on lastname then firstname, which may not be the case if you just concatenate the strings.
Colin