Обсуждение: Request for features - filtering options.
Hello, I am not a subscriber of mailing list so maybe such idea wasalready presented. It would be nice to see (for me) 2 features in pgAdmin: 1. Table -> View data -> new option: View Bottom 100 Rows which would beuseful in case of checking last changes - otherwiseI have view to Top 100 and change ordering 2. Additional select box in View Data Options: "History" - after selectingoption remembered text (by table) would be pastedinto Filter textarea.It would be useful for often/similar filtering which are done duringdata maintenance :) The bestwould be saving this history on the disk - touse in the future. -- best regards ml.
On Tue, Feb 3, 2009 at 10:36 AM, Marcin <marlag@fr.pl> wrote: > Hello, > > I am not a subscriber of mailing list so maybe such idea was > already presented. > > It would be nice to see (for me) 2 features in pgAdmin: > > 1. Table -> View data -> new option: View Bottom 100 Rows which would be > useful in case of checking last changes - otherwise I have view to Top 100 > and change ordering The Top 100 option simply shows the first rows in the arbitrary order that the server reads them. 'Bottom 100' is meaningless without a defined order which would obviously be table-specific. At best it would mean 'the last 100 rows read from disk' but to get those, we'd need to get all the preceding ones first which makes it pointless limiting the size of the dataset in the first place. > 2. Additional select box in View Data Options: "History" - after selecting > option remembered text (by table) would be pasted into Filter textarea. > It would be useful for often/similar filtering which are done during > data maintenance :) The best would be saving this history on the disk - to > use in the future. Yes - I'd like to add something similar to the query tool. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
--- On Tue, 3/2/09, Marcin <marlag@fr.pl> wrote: > 1. Table -> View data -> new option: View Bottom 100 > Rows which would be > useful in case of checking last changes - otherwise I have > view to Top 100 > and change ordering > That would be a nice little touch. I do to 100 and reorder all the time.
--- On Tue, 3/2/09, Dave Page <dpage@pgadmin.org> wrote: > > Hello, > > > > I am not a subscriber of mailing list so maybe such > idea was > > already presented. > > > > It would be nice to see (for me) 2 features in > pgAdmin: > > > > 1. Table -> View data -> new option: View > Bottom 100 Rows which would be > > useful in case of checking last changes - otherwise I > have view to Top 100 > > and change ordering > > The Top 100 option simply shows the first rows in the > arbitrary order > that the server reads them. 'Bottom 100' is > meaningless without a > defined order which would obviously be table-specific. At > best it > would mean 'the last 100 rows read from disk' but > to get those, we'd > need to get all the preceding ones first which makes it > pointless > limiting the size of the dataset in the first place. > I see. It'd be nice if there could be some sort of option "order top 100 by primary key" - then perhaps would the last 100be possible?
On Tue, Feb 3, 2009 at 10:59 AM, Glyn Astill <glynastill@yahoo.co.uk> wrote: > > I see. It'd be nice if there could be some sort of option "order top 100 by primary key" - then perhaps would the last100 be possible? Probably - not sure how to make it presentable in the menu though :-). Patches welcome!! -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com