Hello,
is there a way of ordering table values by their ViewValue - without having a lookup table where I set the ORDER BY ?
I am doing the foolowing where I'd need this:
- I have a view, that has a simply empty field (column) with no values taken from my own database tables.
- In RowRendering of that view, I am looking up values from a complete different database and put these values into the CurrentValue of my empty field in that view
- In RowRendered I then set the ViewValue
so far all works fine, but I can't order the view since PHPMaker still considers the empty values the view had before I changed the CurrentValues...
What can I do?