Skip site navigation (1) Skip section navigation (2)

Re: Easier sorting & searching in the edit grid?

From: Dave Page <dpage(at)postgresql(dot)org>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Easier sorting & searching in the edit grid?
Date: 2007-11-09 09:19:49
Message-ID: 47342635.5000703@postgresql.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
Andreas wrote:
> Hi,
> 
> I'd like to propose a tiny addition to the edit grid that shows tables
> and query results.
> The sorting&filter dialog is most of the time overkill when I just want
> to look something up.
> 
> I'd be nice to have additional command buttons like you find e.g. in
> MS-Office:
> One clicks into a column and then
> 
> 1)   a)   "A-->Z"
>       b)  "Z-->A"   to sort the grid by this column.
> 
> 
> 2)   a)   A button that asks for a value to search within this column.
>      b)   continue
> 
> 
> Or set filters on this column:
> 3)  a)    show just records that have the same value in this column as
> the cell that has the focus right now.
>     b)   NOT (1)
> 
> 4)   ask for an expression X and set a filter on the current column.
> This might be more work so it isn't a priority but it'd be really helpful.
> E.g.   mouse click in column   "some_number".
> Then click button and enter :    ">100 and <900 or null"
> pgAdmin would expand this to:   (some_number > 100) AND (some_number <
> 900) OR (some_number IS NULL)
> 
> 
> I think even just 1) - 3) would save a whole lot of typing and retyping
> b/c of wrong spelling.

1 & 2 sound good. I'm on the fence on the usefulness of 3, and for 4 you
might as well use the existing dialogue.

Any danger I can persuade someone to take a stab at this?

Regards, Dave

In response to

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2007-11-09 09:41:43
Subject: Re: Easier sorting & searching in the edit grid?
Previous:From: AndreasDate: 2007-11-09 01:39:00
Subject: Easier sorting & searching in the edit grid?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group