This topic is locked

sort columns on view page

3/27/2008 5:54:22 PM
PHPRunner General questions
K
kenhaley author

Evaluating phprunner...
When you create a new page for a database table, on the list/view page some column headings are links that allow you to sort..some are just plain text...not sortable. What determines whether sorting is enabled, and is that something you can override? I'd like to turn it off in some cases...on in others.
Thanks,

Ken

Sergey Kornilov admin 3/27/2008

All sortable fields will have a clickable header that allows to sort data.

Image/long text fields are not sortable.
In Visual Editor you can replace a clickable field header with a simple label. This will turn off the sorting.

K
kenhaley author 3/31/2008

Thanks for the reply, Sergey.

Image/long text fields are not sortable.


That's too bad since, in our PostGres environment, nearly all non-numeric columns are stored as text columns. I know this is a faux-pas in other databases--with varchar being the preferred choice for performance reasons--but it makes little or no difference performance-wise in Postgres (according to the docs and our own emprical measurements), and it's definitely convenient not to have to specify a max length. In any case, it's already done...not something we can easily change.
So this means we wouldn't be able to sort on our non-numeric fields--unless we have a work-around here.

In Visual Editor you can replace a clickable field header with a simple label. This will turn off the sorting.


I was aware of this alternative, but I'm hesitant to use it. Whenever I've worked with code-generation packages in the past, one maxim that I've tried to stick to is "don't touch the generated code unless you absolutely have to." Because, as soon as you modify it, you can't regnerate without losing your mods. I think one of the hallmarks of a good code generator is the use of sufficient user-configurable settings, events, and the like to minimize or eliminate the need to touch the generator's output.
Although I'm quite impressed with phpRunner's features overall, I'm afraid this is a show-stopper for us. We will continue to monitor the product's future versions.
Ken

Sergey Kornilov admin 3/31/2008

Ken,
you missed the point.
Visual Editor is the part of PHPRunner. Changes made in Visual Editor stay there and won't be lost after rebuild.