I have a view that displays a list of data from a table (I'm targeting Joomla! 3.5+). However, I fabricated a column that stitches data together after some manipulation. I do this in the
getItems() method after the data has been pulled from the database.
The column and manipulated data display properly in my view, but I need to be able to sort the column.
Typically ordering is established in the
getListQuery() method. Unfortunately I don't have a column in the table that corresponds to the fabricated column which is built after each query.
I might be able to order by multiple columns, but I'm using lookup tables which complicates things. I guess I can write my own sort (the data is text) and apply it in
getItems(). Is there's a better way to accomplish my goal?