Query RecordLists
1596
Views
12
Comments
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!

2016-04-21 20-09-54
J.
mvp_badge
MVP
2020-09-15 13-07-22
Kilian Hekhuis
mvp_badge
MVP
Indeed, a merge may be in order here.
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
2020-12-08 09-54-08
Evert van der Zalm
mvp_badge
MVP
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
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
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
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

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
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
LINQ!
2016-11-21 23-23-04
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.


2016-11-21 23-23-04
Gonçalo Borrêga
Merged this idea with 'Query a RecordList Variable' (created on 2010-09-10 17:52:06 by Fernando Santos)