Thread: Subqueries in Graphical Query Builder?

Subqueries in Graphical Query Builder?

From
Forrest Cahoon
Date:
I find myself using the Graphical Query Builder more and more, but the
one thing I wish it had is support for subqueries.  Are there any
plans to add that feature?

Forrest


Re: Subqueries in Graphical Query Builder?

From
Guillaume Lelarge
Date:
Le 19/05/2010 18:21, Forrest Cahoon a écrit :
> I find myself using the Graphical Query Builder more and more, but the
> one thing I wish it had is support for subqueries.  Are there any
> plans to add that feature?
> 

Nope. AFAICT, there are no plans on the GQB right now. Moreover I don't
see how we could do that (in a UI way, I mean).


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com


Re: Subqueries in Graphical Query Builder?

From
Forrest Cahoon
Date:
On Wed, May 19, 2010 at 2:43 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
> Le 19/05/2010 18:21, Forrest Cahoon a écrit :
>> I find myself using the Graphical Query Builder more and more, but the
>> one thing I wish it had is support for subqueries.  Are there any
>> plans to add that feature?
>>
>
> Nope. AFAICT, there are no plans on the GQB right now. Moreover I don't
> see how we could do that (in a UI way, I mean).

Here's how I thought it might work:

When you go to the criteria tab and click the "+" button, you get a
Set Value dialog box which comes up. Currently this gives you a tree
view of the tables you've joined, from which you can select a column.
A subquery button could be added to that dialog, which would bring up
a new query builder window (or create another tab at the top along
with "SQL Editor" and "Graphical Query Builder");

I'm sure there are a lot of details which would have to be worked out, though.

Forrest