Lookup Table

eudosia · Post by **eudosia** » Wed Sep 24, 2014 11:29 pm

Hello. I need to have in the lookuptable more than one field in 'Order By' option.
THis in phpmaker v 10 from the gui is not possible. It is possible to obtain the same result (more than one field in the Order by)
in server events ? If possbile, how ?
Thanks

mobhar · Post by **mobhar** » Thu Sep 25, 2014 8:57 am

Currently, only one field is supported for ORDER BY in the Lookup Field.

However, you may create a Database View based on that Lookup Table, and put the ORDER BY clause as you want in that Database View.

eudosia · Post by **eudosia** » Thu Sep 25, 2014 10:51 pm

Nice hint mobhar!
Precious.