Hi All,
I want to group the data which is same (collapse ).I'm getting data from API and stored it in structure and in table records I'm giving source record as list (localvariable) so
I'm having number ,name ,date columns I want to group the rows if the number is same(collapse format) and It should show the grey color when it is in collapsed But After expand it should show the normal view for remain same numbers.
Please help on this how to group the similar row data .
Hi Pavani Lankalapalli,
Please give me sample data from API and the structure details.
Expert result.
Thanks,
Ramesh
sorry I'm not able to post the API Details
Hi
please see this sample project on Forge https://www.outsystems.com/forge/component-overview/15145/pattern-sql-result-to-grouped-nested-list which shows how to group data in a nested structure. This one is using a SQL Result, but the same principles can be used for API results.
Hope that helps
Stefan
Thanks for you response I'm not having much experience with Outsystems ,I will be happy If there is any OML using API
Hi,
API and Database queries both return a result. In your case your api returns a List of <Something>. The grouping asf. is independant of that as you will see in the pattern. If you already can successfully query your api then you can use the steps after the aggregate (from the screen above) to group your data in a nested structure. Check the OutSystems documentation to see how ListAppendAll, ListDistinct and ListFilter work.
Thank you but It would be helpful If there is any OML
Look at the Sample forge App. I provided the Link above.
Its not working for me
I want to achieve similarly like below image ,If It is beverages all the beverages should under the row in collapsed view