Get Single Column List From Multiple Column Response SQL[Json] Alternative for Deephost sql extension

As Many of them using Deephost Mysql extension , now it has stopped bcz of new kodular update
deephost extension had feature of getting list from response

so i prepared a guide to get list without his extension
i searched so much in community and most of them were using foreach block and it is not good for the app bcz if there are thousands of row then app may crash
here is the easy way to get it

First you all know how to call query , there are tutorial about it in community

previously select query used like this and this method gets as table

instead of using it , Use this method
"SELECT json_object(‘email’,email,‘name’,name,‘refer’,refer) FROM mytable; "
This method returns response as json

Next use this extension


This how you get Single List
Hope you understood my guide
hope this helped you

1 Like

I used deephost mysql extension but after kodular new update our app is not open. So please tell me how to use MySQL in our app.

For more info search in youtube

list position value is best block till i also use this block with spreadsheet app helper project.

1 Like