How to access an SQL agregate output data

I'm currently working on an exercise that contains a form with a button that fetches data using an SQL.

The data is fetched and working. However I need to display on some of the fields of that form the fetched data and to pre-populate the from before submiting.

The problem is that I don't have any idea how to access the agregate that I fetched, since the scope of the form I want the data to be populed, is not the same. 

I'm assuming that once I can access the fetched agregate, I'm able to point one of the form's fields to that data, on the properties.

Can someone help me out?


Thank you

Please use attached oml to solve this issue.

Bookings_TRU.oml

Hi Taigo, 

You can create a data action in your screen and use sql widget in data action. You need to set output structure/entity in sql widget. Map sql widget output to the data action output variable. 

You can use data action output variable in form widgets. 

Thanks

Hey Vinod, 

I did that,

However I cant seem to get the output var on the same context as the form field. Not showing!



Your output variable should be room not the room list. 


Please share OML file to resolve this.

Thanks

Ok I've correct that. But still can't access if from the form...

Please use attached oml to solve this issue.

Bookings_TRU.oml

Hi Tiago ,

Please find attached oml and demo url below 

https://rahul-jain-doitlean.outsystemscloud.com/Application/Sql

I hope this will help you

Thanks

Rahul jain

SQL.oml

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