Back to Ideas
69
Like
Follow Idea
Query RecordLists
2035Views
12Comments
Implemented
Aggregates & Queries
OutSystems 10

the possibility to query a record list (ie. local/input variable) would rock!


instead of querying/manipulating one/multiple entities multiple times, untill you have all relevant data together.

why not query a record list already available? even if it consists only of structures


this would seriously increase performance and reduce complexity.


specially since you dont need those loops with an IF anymore, that simply skip all records untill youve reached the one you want.


thanks for liking!

25 Feb 2013
Copy link to comment
Indeed, a merge may be in order here.
08 Mar 2013
Copy link to comment
one thing im missing is the ability to query a record list (local variable)

which would reduce DB load, since data that has already been selected,
can be queried again, without having to access the DB again

and you can work better with record lists only made up of structures,
especially when it comes to recursion (ie. directory-tree's)
and complex logic

TreeExample

Merged from 'Query Record List' (idea created on 2013-01-30 17:00:36 by Manuel), on 2014-01-24 11:41:39 by Gonçalo Borrêga
30 Jan 2013
Copy link to comment
If this is possible it would be very usefull!

Merged from 'Query Record List' (idea created on 2013-01-30 17:00:36 by Manuel), on 2014-01-24 11:41:39 by Gonçalo Borrêga
01 Feb 2013
Copy link to comment
Yes! This would solve so many problems and cut down on database usage tremendously.

Merged from 'Query Record List' (idea created on 2013-01-30 17:00:36 by Manuel), on 2014-01-24 11:41:39 by Gonçalo Borrêga
13 May 2013
Copy link to comment
Absolutely. +1

Merged from 'Query Record List' (idea created on 2013-01-30 17:00:36 by Manuel), on 2014-01-24 11:41:39 by Gonçalo Borrêga
05 Jan 2014
Copy link to comment
UserImage.jpg
Parul Sinha
That is very useful +1.

Merged from 'Query Record List' (idea created on 2013-01-30 17:00:36 by Manuel), on 2014-01-24 11:41:39 by Gonçalo Borrêga
14 Jan 2014
Copy link to comment

Possibility to query a RecordList Variable as if it was a table.



Merged from 'Query a RecordList Variable' (idea created on 2010-09-10 17:52:06 by Fernando Santos), on 2014-01-24 11:42:05 by Gonçalo Borrêga
10 Sep 2010
Copy link to comment
Yeah, LINQ it guys! :)

Merged from 'Query a RecordList Variable' (idea created on 2010-09-10 17:52:06 by Fernando Santos), on 2014-01-24 11:42:05 by Gonçalo Borrêga
17 Sep 2010
Copy link to comment
LINQ!
29 Jan 2014
Copy link to comment
2016-11-21 23-23-05
Gonçalo Borrêga

Hi all,

Thank you very much for the feedback. A new capability that may have gone unnoticed with OutSystems 10 is the new set of List Actions, which basically allow you to "Query (Record)Lists".

This amazing set of operations represent a huge decrease on the amount of procedural logic that you used to have to model by hand. Plus, they're fully TrueChange aware, meaning, if you change the name of your structures, the filters or sort conditions get automatically refactored, and if you change/remove attributes from your structures, errors or type warnings popup to let you know the impact.

Happy LINQing

List Operations

New list operations have been introduced to make you even more productive. The operations, which are available both for client and server actions, are: ListAll, ListAny, ListFilter, ListIndexOf, and ListSort. Many patterns that required the use of ForEach loops can now be represented in a much more readable and compact form.


24 Oct 2016
Copy link to comment
2016-11-21 23-23-05
Gonçalo Borrêga
Merged this idea with 'Query a RecordList Variable' (created on 2010-09-10 17:52:06 by Fernando Santos)
24 Jan 2014
Copy link to comment