Thread: Enhancement request - Data Grid sort controls
<div class="WordSection1"><p class="MsoNormal">Hi,<p class="MsoNormal"> <p class="MsoNormal">I’d like to request that thequery data grid incorporate the column sort controls often available in data grids.<p class="MsoNormal">Typically thecolumn header indicates an order. Clicking on the header resorts the grid in the reverse order.<p class="MsoNormal"> <pclass="MsoNormal">Would eliminate the need to rerun the query to change order, or cut/paste resultsto excel to sort.<p class="MsoNormal"> <p class="MsoNormal">Thanks<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"><b><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif"">Doug Little</span></b><p class="MsoNormal"><b><spanstyle="font-size:12.0pt"> </span></b><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Sr.Data Warehouse Architect | Business Intelligence Architecture| Orbitz Worldwide </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">500W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 |Fax 312.894.5164 | Cell 847-997-5741</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""></span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><a href="mailto:Douglas.Little@orbitz.com"title="mailto:dlittle@orbitz.com"><b><span style="color:blue">Douglas.Little@orbitz.com</span></b></a></span><b><u><spanstyle="font-size:13.5pt;font-family:"Times NewRoman","serif";color:blue"></span></u></b><p class="MsoNormal"> <img alt="cid:image001.jpg@01CABEC8.D4980670" border="0"height="61" id="Picture_x0020_1" src="cid:image001.jpg@01CC2C02.FD010140" width="83" /> <a href="http://www.orbitz.com/"title="http://www.orbitz.com/"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">orbitz.com</span></a><span style="color:blue">|</span><a href="http://www.ebookers.com/" title="http://www.ebookers.com/"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">ebookers.com</span></a><span style="color:blue">|</span><a href="http://www.hotelclub.com/" title="http://www.hotelclub.com/"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">hotelclub.com</span></a><span style="color:blue">|</span><a href="http://www.cheaptickets.com/" title="http://www.cheaptickets.com/"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">cheaptickets.com</span></a><span style="color:blue">|</span><a href="http://www.ratestogo.com/" title="http://www.ratestogo.com/"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">ratestogo.com</span></a><spanstyle="color:blue"> |</span><a href="http://www.asiahotels.com/" title="http://www.asiahotels.com/"><span style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">asiahotels.com</span></a><p class="MsoNormal"> </div>
Hi, On Thu, 2011-06-16 at 08:54 -0500, Little, Douglas wrote: > [...] > > I’d like to request that the query data grid incorporate the column > sort controls often available in data grids. > That would be interesting. > Typically the column header indicates an order. Clicking on the > header resorts the grid in the reverse order. > Yeah, we have that in the server status window, but not in the data grid. > Would eliminate the need to rerun the query to change order, or > cut/paste results to excel to sort. > Nope, that would not change. It'll fire the query anyway, it would only change the ORDER BY clause. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Thu, Jun 16, 2011 at 3:45 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote: > Hi, > > On Thu, 2011-06-16 at 08:54 -0500, Little, Douglas wrote: >> [...] >> >> I’d like to request that the query data grid incorporate the column >> sort controls often available in data grids. >> > > That would be interesting. Unlikely to ever happen though, as we'd have to re-sort the data in the PGresult structure that's used as a virtual table for the grid. Avoiding that would mean copying the data into a private data structure first, as we used to do in v1.2 and older (or whatever the last release was before we changed that). That has a host of other problems associated with it, and we're not going back to those days! >> Would eliminate the need to rerun the query to change order, or >> cut/paste results to excel to sort. > > Nope, that would not change. It'll fire the query anyway, it would only > change the ORDER BY clause. That's the Heath-Robinson approach. It would be *extremely* hard to do reliably as it would have to rewrite user defined queries. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Thu, 2011-06-16 at 15:50 +0100, Dave Page wrote: > On Thu, Jun 16, 2011 at 3:45 PM, Guillaume Lelarge > <guillaume@lelarge.info> wrote: > > Hi, > > > > On Thu, 2011-06-16 at 08:54 -0500, Little, Douglas wrote: > >> [...] > >> > >> I’d like to request that the query data grid incorporate the column > >> sort controls often available in data grids. > >> > > > > That would be interesting. > > Unlikely to ever happen though, as we'd have to re-sort the data in > the PGresult structure that's used as a virtual table for the grid. > Avoiding that would mean copying the data into a private data > structure first, as we used to do in v1.2 and older (or whatever the > last release was before we changed that). That has a host of other > problems associated with it, and we're not going back to those days! > > >> Would eliminate the need to rerun the query to change order, or > >> cut/paste results to excel to sort. > > > > Nope, that would not change. It'll fire the query anyway, it would only > > change the ORDER BY clause. > > That's the Heath-Robinson approach. It would be *extremely* hard to do > reliably as it would have to rewrite user defined queries. > I thought we were talking about the edit grid, not the query tool. I may be wrong. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
On Thu, Jun 16, 2011 at 4:00 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote: > On Thu, 2011-06-16 at 15:50 +0100, Dave Page wrote: >> On Thu, Jun 16, 2011 at 3:45 PM, Guillaume Lelarge >> <guillaume@lelarge.info> wrote: >> > Hi, >> > >> > On Thu, 2011-06-16 at 08:54 -0500, Little, Douglas wrote: >> >> [...] >> >> >> >> I’d like to request that the query data grid incorporate the column >> >> sort controls often available in data grids. >> >> >> > >> > That would be interesting. >> >> Unlikely to ever happen though, as we'd have to re-sort the data in >> the PGresult structure that's used as a virtual table for the grid. >> Avoiding that would mean copying the data into a private data >> structure first, as we used to do in v1.2 and older (or whatever the >> last release was before we changed that). That has a host of other >> problems associated with it, and we're not going back to those days! >> >> >> Would eliminate the need to rerun the query to change order, or >> >> cut/paste results to excel to sort. >> > >> > Nope, that would not change. It'll fire the query anyway, it would only >> > change the ORDER BY clause. >> >> That's the Heath-Robinson approach. It would be *extremely* hard to do >> reliably as it would have to rewrite user defined queries. >> > > I thought we were talking about the edit grid, not the query tool. I may > be wrong. The Edit Grid already has sorting. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company