How to create JSON using data from websql

[Former Member]

Hi Experts,

                am trying to make list in sapui5 and the data in the list should be populate from the database.....so far success but i want to make a json of database

[mauriciolauffer]

I'm not sure if I really understood what you want, but I'll try a shoot.

If you just want to store your JSON Model in some new HTML5 storage feature you can take a look in these links:

Firebase - Build Realtime Apps

[Former Member]

Hi Mauricio Lauffer

using a websql database...and from database the value is populate in the list....when i click row the list another view appears.. but not showing the values that i have selected...so i think i need to store database values in json and the pass the values to the next view....am not sure if you have any idea how to do this please tell...

Regards

Kelvin

[mauriciolauffer]

Ok, I got it.
You have to store the data as a JSON object or get the data from WebSQL and convert to JSON before use it in your Model.

You can check the links below.

javascript - Inserting JSON data into Sqlite/webSQL database - Stack Overflow

javascript - How can I get JSON fton WebSQL - Stack Overflow

Hope it helps you.