Hi All,
I am using group by in aggregate ex aggregate1 for 2 columns and in listfilter on this aggregate giving condtiion that the key chosen for group by column in aggregate1should be ex current key in outer for each loop.
iterating the listfilter on agregate1 ,I am always getting only 1st record.
Please suggest,want to see all rows in aggregate1 in listfilter.filterdlist done on aggregate1
If any example,Please provide.
Regards.
Hello ujwala,
Hope you're doing well.
Just according to your description, it is really hard to help you and to understand your problem.
As a suggestion, maybe some screenshots of your code could be good. And a better explanation of what you're trying to achieve.
Kind regards,
Rui Barradas
Hi ujwala,
It would be easier for us if you shared an example or a table diagram to know the relationships.
most likely the solution is using SQL Query and subqueries.I recommend you practice and read more about this topic.
https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/SQL_Querieshttps://docs.microsoft.com/en-us/sql/relational-databases/performance/subqueries?view=sql-server-ver16https://docs.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql?view=sql-server-ver16
CheersMany successes!Postscript: I need work with technology in outsystems to test my skills.
Hello,
Thank you for the reply,
I need to select all the data from the table1 ,the table data will be huge and dynamic ,
I need to iterate the loop from some other table and pass the current to table1 and select all records,
will the general sql will be performant ,to fetch all records huge data that will be increasing always.
Regards