Simple query to advanced convertion

By André Ramos on 30 Apr 2010


There could be some magic feature that would make this time saver feature. :-)


Then we could make a simple query to build the 'skeleton' of a query and then introduce the aditional rules that cannot be defined in a simple query.




It is simply to frustrating and inneficient when you get to the point where your simple (but complex)  query needs a change and the simple query editor is no longer sufficient to express your needs, and you don't have a simple way to tranform the query into and advanced one


Merged from 'Allow transforming a Simple query into an Advanced query with a click' (idea created on 2010-08-10 11:05:43 by Francisco Menezes), on 2010-08-19 10:02:59 by Pedro Oliveira
Remco Dekkinga11 Aug 2010

I believe that this is the same idea:
http://www.outsystems.com/wisdomofthecrowds/IdeaComment_List.aspx?IdeaId=49


Merged from 'Allow transforming a Simple query into an Advanced query with a click' (idea created on 2010-08-10 11:05:43 by Francisco Menezes), on 2010-08-19 10:02:59 by Pedro Oliveira

This would be super! It is a common use case having to evolve a simple (but complex) query into a an advanced one and we could save so much time and useless effort

Gonçalo Veiga14 Oct 2010
Happens a lot... you start off with a Simple Query, things get complicated and you have to go to an Advanced Query, doing it from scratch!

Merged from 'Transform Simple Query to an Advanced Query at a click of a button' (idea created on 2010-10-14 02:11:00 by Gonçalo Veiga), on 2010-10-14 14:00:30 by Pedro Oliveira
Goncalo Borrega14 Oct 2010
This is the same as http://www.outsystems.com/WisdomOfTheCrowds/IdeaComment_List.aspx?IdeaId=49

Merged from 'Transform Simple Query to an Advanced Query at a click of a button' (idea created on 2010-10-14 02:11:00 by Gonçalo Veiga), on 2010-10-14 14:00:30 by Pedro Oliveira
Gonçalo Veiga14 Oct 2010
Agreed.

Merged from 'Transform Simple Query to an Advanced Query at a click of a button' (idea created on 2010-10-14 02:11:00 by Gonçalo Veiga), on 2010-10-14 14:00:30 by Pedro Oliveira
This is a must have in a future version. Perhaps on 6.1 ? ;)
This happens a lot on new projects. It happened to me today.

Please guys. Give us this one.
João Costa9 Aug 2013
Imagine right-clicking a Simple Query and have the option to transform it into an Advanced Query. Wouldn't that be nice?

Merged from 'Option to transform a Simple Query into an Advanced Query' (idea created on 2013-08-09 16:06:53 by João Costa), on 2013-08-12 08:52:01 by Davide Marquês
Pedro Gonçalves10 Aug 2013
I like it!

Although it is possible with a couple of clicks - e.g. using Test Query - once you see all those SQL alias and the trouble to indent the SQL statements, you wish there was something more faster.

Merged from 'Option to transform a Simple Query into an Advanced Query' (idea created on 2013-08-09 16:06:53 by João Costa), on 2013-08-12 08:52:01 by Davide Marquês
Hans Dollen28 Apr 2014
Perhaps a conversion from advanced to simple would be nice as well ;-)
Justin James22 May 2014
I came to the ideas board tonight to put this in there.

And then I saw it already there. And I already liked it.

:(

J.Ja
Matthias Preuter14 Jul 2014
Same here J.Ja,

it is one of the 1st ideas of WotC.
Matthias Preuter14 Jul 2014
Or make it possible to have a IN condition for the Simple Query
Justin James17 Jul 2014
The good news folks, is from the version 9 demos at Next Step, this sure looks like this is no longer needed. Including the much-wanted IN clause.

J.Ja
Pramod Jain28 Aug 2014
Hi James,
I always thought abuot having the IN clause in simple query ...nice to hear it is happening in ver 9.
Kilian Hekhuis13 Mar 2015
Well, since Simple Queries are no longer amongst us, and Aggregates are meant to replace most Advanced Query use cases, I think we can safely retire this Idea.

Also, we've had the "View SQL" in Simple Queries for quite a while, and it's added to Aggregates since 9.0.0.36, and it's quite easy to convert that SQL to an Advanced Query.