0
 Followers
284
 Likes

Simple query to advanced convertion

Backend
Implemented
on 31 Dec 2015
OutSystems 9


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.



Created on 30 Apr 2010
Comments (18)

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

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

Merged this idea with 'Transform Simple Query to an Advanced Query at a click of a button' (created on 2010-10-14 02:11:00 by Gonçalo Veiga)
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
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
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.
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
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
Perhaps a conversion from advanced to simple would be nice as well ;-)
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
Same here J.Ja,

it is one of the 1st ideas of WotC.
Or make it possible to have a IN condition for the Simple Query
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
Hi James,
I always thought abuot having the IN clause in simple query ...nice to hear it is happening in ver 9.
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.

Problem solved.


Thanks Hekhuis for your brilliant explanation.

views
1268
Followers
0