Thread: FW: Sorting and filtering in PgAdmin

FW: Sorting and filtering in PgAdmin

From
"Nicholas Thiele"
Date:
Hi, I am a big fan of PgAdmin and just joined the list.  There is one
thing, however, that could really be improved.  I think the sorting and
filtering of columns in the table view is less than intuitive.  Could
the columns be sorted by double clicking on the columns?  I know that
currently this action auto-fits the column width but that could be
limited to double clicking on the column border.  Another option would
be providing an arrow icon in the column header to control sorting and
filtering (as the V.S. .Net DataGrid does).  If the wxWidgets library
does not support this, as a minimum it would be great if the data
sorting and filtering tabs in the 'View Data Options' form had a list of
drag-and-drop columns.  Currently I have to change the sort order by
clicking remove on each existing column, activating the Available
Columns list, selecting a new column and then choosing the sort order.
What do others think??

Nic Thiele

Re: FW: Sorting and filtering in PgAdmin

From
Bastiaan Wakkie
Date:
Hi Nic,

I am with you. I think it should be changed too. The automatic sort on oid is useless anyway.. better sort on the first ' normal' column by default anyay.

Cheers,
Bastiaan

On Tue, 2006-02-07 at 10:19 +1030, Nicholas Thiele wrote:
Hi, I am a big fan of PgAdmin and just joined the list.  There is one
thing, however, that could really be improved.  I think the sorting and
filtering of columns in the table view is less than intuitive.  Could
the columns be sorted by double clicking on the columns?  I know that
currently this action auto-fits the column width but that could be
limited to double clicking on the column border.  Another option would
be providing an arrow icon in the column header to control sorting and
filtering (as the V.S. .Net DataGrid does).  If the wxWidgets library
does not support this, as a minimum it would be great if the data
sorting and filtering tabs in the 'View Data Options' form had a list of
drag-and-drop columns.  Currently I have to change the sort order by
clicking remove on each existing column, activating the Available
Columns list, selecting a new column and then choosing the sort order.
What do others think??

Nic Thiele

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: FW: Sorting and filtering in PgAdmin

From
lbates35406
Date:
I agree completely, but would like to be able to define a sorting order and
make it the default any time I view records in a table.  This would save
loads of time.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/FW-Sorting-and-filtering-in-PgAdmin-tp2156945p3278393.html
Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.

Re: FW: Sorting and filtering in PgAdmin

From
Guillaume Lelarge
Date:
Le 24/11/2010 14:31, lbates35406 a écrit :
>
> I agree completely, but would like to be able to define a sorting order and
> make it the default any time I view records in a table.  This would save
> loads of time.

If I try to list the different issues here:

 * sort with double click on a column
 * auto-fit with double click on a column border
 * arrow icon on the sorted column header (might get fun with sorting
   with more than one column)

BTW, neither of these are supported by wxWidgets 2.8 AFAIK.

There is no automatic sort on OID (there is no OID since quite some
time). Actually, there is no automatic sort if the user doesn't specify
one. And it'll stay that way.

I don't get the maintain last sort. It'll probably work if you keep
opening the same table, but if you open another one, there's good chance
the sorted column won't exist. I don't see how we can do that in a good way.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

Re: FW: Sorting and filtering in PgAdmin

From
Guillaume Lelarge
Date:
Le 26/11/2010 04:18, Larry Bates a écrit :
> when I filter a table, the results come back sorted on the first column
> (normally some sort of id).  I can sort it other ways under Data Sorting tab.
> What I'm saying is that when I define a new sort order it would be nice to be
> able to click on a button to make this the "default" sort order for the table
> whenever I look at the rows contained (see attached mock up of dialog).  A
> default sort order could be saved for each table.  After a while, you would get
> all of them sorted in the way that you wish to look at them MOST of the time.
>
> Since this is something that I encounter over and over, I thought I would make
> the suggestion because it is probably affecting others as well.
>

Which means you want to keep a specific order for each table. Which is
not that simple. It means we need to record "somewhere" that you want
that the table tablename in schema schemaname in database databasename
will be sorted this way. This could make pgAdmin's config file way
bigger than it already is.

Anyway, it's probably interesting to have. I still need to think about
the UI.

BTW, keep the list in your answer.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com