86
Views
5
Comments
How do you display all records from Aggregate?

How do you display all records from Aggregate? 

So I want all records to show in a certain container, like if I type 1 in an input then all records like

for example <111,222,333> I want them all to be shown in a certain container.

What is the best way to do it? 

2026-02-26 06-29-24
Rahul
 
MVP

Hi,

You need to visit training material first.

https://www.outsystems.com/training/courses/

2026-02-26 06-29-24
Rahul
 
MVP

Hi @SeungHwan Kim ,

You can try with advance sql using this query.

https://database.guide/how-to-get-multiple-rows-into-a-comma-separated-list-in-sql/


Hope this will help you.

2023-02-13 15-34-45
BabyBear

On your aggregate there is a property called Max Records. you can set it up to any number of records you want to fetch

2023-03-16 04-58-56
Ashish Lonkar

Hi SeungHwan Kim,

I dont understand your question properly, please share your OML I can look into it for you.

Thanks !


2024-09-12 02-43-38
Deepsagar Dubey

Hi SeungHwan,

You can put a filter in your aggregate and maintain 2 parameters one for minimum and maximum number and put a condition like

Number >= minimum  and Number =< maximum,

and use reusable block to display these records separately in your screen, but don't forgot to update minimum and maximum parameters for every request.

I hope it'll help you.

Thanks

Deep

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.