Back to Ideas
284
Like
Follow Idea
Simple query to advanced convertion
3665Views
20Comments
Implemented
Backend
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.



30 Apr 2010
Copy link to comment

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
10 Aug 2010
Copy link to comment

I believe that this is the same idea:
https://www.outsystems.com/ideas/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
11 Aug 2010
Copy link to comment

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

12 Aug 2010
Copy link to comment
2018-05-04 12-26-50
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
14 Oct 2010
Copy link to comment
2016-11-21 23-23-05
Gonçalo Borrêga
This is the same as https://www.outsystems.com/ideas/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
14 Oct 2010
Copy link to comment
2018-05-04 12-26-50
Gonçalo Veiga
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
14 Oct 2010
Copy link to comment
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.
05 Sep 2011
Copy link to comment
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
09 Aug 2013
Copy link to comment
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
10 Aug 2013
Copy link to comment
Perhaps a conversion from advanced to simple would be nice as well ;-)
28 Apr 2014
Copy link to comment
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
22 May 2014
Copy link to comment
Same here J.Ja,

it is one of the 1st ideas of WotC.
14 Jul 2014
Copy link to comment
Or make it possible to have a IN condition for the Simple Query
14 Jul 2014
Copy link to comment
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
17 Jul 2014
Copy link to comment
Hi James,
I always thought abuot having the IN clause in simple query ...nice to hear it is happening in ver 9.
28 Aug 2014
Copy link to comment
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.
13 Mar 2015
Copy link to comment
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)
14 Oct 2010
Copy link to comment

Problem solved.


Thanks Hekhuis for your brilliant explanation.

22 Aug 2018
Copy link to comment

Hi All,

I think the need is still there its not "Problem Solved". Simple example, If you have to write an aggregate to do a search in Database with matching logic for string (for example Janice) with the string has special character (for example Jânice) then it is not been differentiated by outsystems. It just assumes both the string are same and fetch both. To solve this only way is to write advance query with asciistr method to do it and then if the aggregate is having a join of 10 tables its like a nightmare to do the same manually. I still believe its a must need. Also if anyone have any better idea to do this comparison in aggregate itself and provide me a solution will be really amazing. 

Thanks.

08 Apr 2020
Copy link to comment

Hi Bipasha,

Your problem has nothing to do with this Idea. The reason it doesn't differentiate between "Janice" and "Jänice" has to do with the collation settings of the database. Using asciistr is just a crude workaround. But again, nothing to do with conversion of Aggregate to SQL.

24 Sep 2020
Copy link to comment