Query RecordLists

By enigma on 25 Feb 2013

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!

Kilian Hekhuis8 Mar 2013
Indeed, a merge may be in order here.
Manuel30 Jan 2013
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
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
Philip Prescott13 May 2013
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
Robbie Nati5 Jan 2014
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
Parul Sinha14 Jan 2014
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
Fernando Santos10 Sep 2010

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
Vítor Oliveira17 Sep 2010
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
Filipe Jacinto29 Jan 2014
LINQ!

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.