Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Sort By Form Display, not Column Name = Fundamental Usability Issue

Quote Reply
Sort By Form Display, not Column Name = Fundamental Usability Issue
Version: 2.1.0

In the default search form, the column list for 'Sort By'
shows Column Names.

This would be meaningless to our users. Every other
field in the form shows the Form Display. Does anyone
know how to fix the search form so that users can sort
by Form Display names?
Quote Reply
Re: [YoYoYoYo] Sort By Form Display, not Column Name = Fundamental Usability Issue In reply to
Just add 'view_name' => 'Desrciption' into column's properties in .def files.

E.g:

...
'price' => {
'binary' => '1',
'form_size' => '20',
'form_type' => 'TEXT',
'not_null' => '1',
'pos' => '2',
'size' => '25',
'type' => 'CHAR',
'view_name' => 'Price',
},
....

Hope that helps.

TheStone.

B.
Quote Reply
Re: [TheStone] Sort By Form Display, not Column Name = Fundamental Usability Issue In reply to
We think if we have to edit the def file every time we modify the database, we will get side-effects sooner or later.

However ... this seems to work ...
... in admin/Dbsql/HTML.pm, approx line 145, edit
Code:
$hash->{$col} = $c->{$col}->{view_name} || $col;
to
Code:
$hash->{$col} = $c->{$col}->{form_display} || $col;


GT: we are happy with the result, but will it create a problem anywhere else?
Quote Reply
Re: [TheStone] Sort By Form Display, not Column Name = Fundamental Usability Issue In reply to
The .def files are not for manual touching (usually).
The 'view_name' => 'displayname', should be added into admin interface.

Can you confirm, that this 'view_name' text field will be added into admin interface in next release?

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...