Обсуждение: Easier sorting & searching in the edit grid?
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. Regards Andreas
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
Dave Page a écrit : > Andreas wrote: >> 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. > 1 and 2 were something I wanted to do but don't have the time right now. So, if Andreas wants to work on this, I completely agree :) I also wanted to add a combobox for each column, showing unique values. Choosing one of the unique values will filter by this value. It seems to me more interesting than 3. Moreover, I would be great to have this (1 and 2) for server status window. Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com