2. PHPRunner General questions
  3. Sorting by clicking on columns bug 4.2/379
This topic is locked

Sorting by clicking on columns bug 4.2/379

 		9/15/2008 10:03:05 AM
PHPRunner General questions
S
 steveh author

When a users clicks the column header to sort the column, and that column is a lookup then the sort appears to be done on the ID and nto the lookup value.
Very confusing for users!
Sergey Kornilov admin 9/15/2008

Steve,
you cannot sort data by column that doesn't belong to the current table.
As a workaround you can modify SQL query in PHPRunner joining lookup table.
S
 		steveh author 9/15/2008

Agreed on that, you'd need to amend the sql - phpmaker does it his way.
Problem is, that without this, it makes sorting on lookup fields pointless?
You'd end up (like we usually do) adding in both a lookup and a join for each field that appears on the list screen.