Postgres Pro
Downloads
Home   >   mailing lists

Fwd: Filter by Selection on Grid - Mailing list pgadmin-hackers

From Robins Tharakan
Subject Fwd: Filter by Selection on Grid
Date
Msg-id 36af4bed0801312038y1191aaa1o1eff61b4fab9aa28@mail.gmail.com
Whole thread Raw
Responses Re: Fwd: Filter by Selection on Grid
List pgadmin-hackers
Tree view
Hi,

[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.

Regards,
Robins Tharakan

---------- Forwarded message ----------
From: Robins Tharakan <tharakan@gmail.com>
Date: Jan 30, 2008 8:05 AM
Subject: Filter by Selection on Grid
To: pgsql-admin@postgresql.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.

Thanks
Robins Tharakan


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


Hi,

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

pgadmin-hackers by date:

Previous
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r7027 - trunk/pgadmin3/pgadmin/schema
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by hiroshi: r7029 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/ctl