order by ViewValue ?

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
nyukuri
User
Posts: 123

order by ViewValue ?

Post by nyukuri »

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?


arbei
User
Posts: 9284

Post by arbei »

Note that the ordering is by the field in the table/view. So you should create a database view that filled the empty value with the data from another database, then order the table by this field.


Post Reply