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

Fwd: Filter by Selection on Grid

From: "Robins Tharakan" <tharakan(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Fwd: Filter by Selection on Grid
Date: 2008-02-01 04:38:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-hackers

[Attempting a last try at mailing to a list (this time without the image
attachment ! may be that's silently deleting my email from the list ?) Sorry
in case you are getting this mail again and again, but I can't find this
email in the archives so I guess it's getting lost somewhere.]

In case the patch is just unacceptable, please still do respond... it gets
frustrating when the first patch that you ever developed isn't even
responded to :(

The good part is that now the patch does the following:
1. Provide options for 'Filter by Selection' / 'Filter Excluding Selection'
/ 'Remove Filter'
2. Takes care if cells have NULL value
3. Takes multiple Include / Exclude selections and refreshes automatically

Limitations that I plan to remove soon:
1. The cell chosen is the 'Selected cell' and that may not be the one
right-clicked. I'd change that soon.
2. I am unable to evaluate strings if they are Empty, so including/excluding
empty-cells (not NULLs) doesn't do anything ! Frustrating ! May be I just
need a break, a bit of reading and I'll get that done soon as well!

In case this patch is considered by and large fine, and in case you are ok
with more additions, I'll try adding more features in the right click menu
(Filter by Custom String / Sort options etc..) similar to what we have in
the Access UI.

*Robins Tharakan*

---------- Forwarded message ----------
From: Robins Tharakan <tharakan(at)gmail(dot)com>
Date: Jan 30, 2008 8:05 AM
Subject: Filter by Selection on Grid
To: pgsql-admin(at)postgresql(dot)org

[I had sent this email to the pgadmin-hackers list earlier. Didn't get any
replies, so I thought may be that's the wrong list. Here I am sending it
again. Also, now the patch provides the first three options
FilterBySelection / FilterExcludingSelection / RemoveFilters and works
'by-and-large' for most cases, except NULLs]

Any and all kinds of feedback are welcome.

*Robins Tharakan*

---------- Forwarded message ----------
From: Robins Tharakan <tharakan(at)gmail(dot)com>
Date: Jan 29, 2008 9:36 PM
Subject: Filter by Selection on Grid
To: pgadmin-hackers(at)postgresql(dot)org


I have been using PgAdmin for a while now and since I've been quite used to
MSAccess, I feel quite limited by the options available while viewing data
in a table.

I have tried to add a simple ('Filter by Selection') feature such that on
right-clicking a cell of a table, only the rows that match the particular
value in the given column are displayed. Although the patch works (except
for corner cases like NULLs) I have absolutely no idea whether it conforms
to coding guidelines.

Since I plan to implement most of the basic features that MSAccess provides
on right-clicking a cell in a table, I wanted to ask a few questions:
1. Is this a good idea in the first place ?
2. Is anyone else working on it ?
3. Whether this patch needs any more work ?
4. If this is fine, should I start working on the other options as well ?

It'd be great if anyone could take a look at the patch.

Thanks a ton !
*Robins Tharakan*

Attachment: filter_by_selection_v6.patch
Description: text/x-patch (6.8 KB)


pgadmin-hackers by date

Next:From: svnDate: 2008-02-01 05:33:47
Subject: SVN Commit by hiroshi: r7028 - in trunk/pgadmin3: . pgadmin/ctl
Previous:From: svnDate: 2008-01-31 13:53:32
Subject: SVN Commit by dpage: r7027 - trunk/pgadmin3/pgadmin/schema

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