1
0
-1

hello,

i've a question about how to retrieve data from database to spreadsheet?

data in database is

column_name : Detail

[{"c_spec_Detail":"(Core i7/Ram 16GB /SSD 512 / VGA 4 GB /u201d) ","spec_Detail":"(Core i7/Ram 16GB /SSD 512 / VGA 4 GB /u201d) ","id":"1ad320f0-c056-4690-9112-cfd368301390","c_spec_Title":"Spec (Desktop Type D2)","spec_Title":"0"},{"c_spec_Detail":"(Core i5/Ram 8GB /SSD 256 + HDD 1 TB / u201d)","spec_Detail":"(Core i5/Ram 8GB /SSD 256 + HDD 1 TB / u201d)","id":"751717f4-27c1-4379-ab41-87c00bc2ae87","c_spec_Title":"Spec (Desktop Type D1)\r\n","spec_Title":"1"}]


form : Show Detail

i use spreadsheet to retrieve data but i can't to get it

my query is : select c_Detail from infodetail where id='#requestParam.id#'

config in spreadsheet form : field id = spec_Detail , spec_Title , Amount

result : it show all data within column_name : Detail but not seperate data as field id. pls look below


spreadsheet form i need :

spec_Detail | spec_Title | Amount

xxx             |  aaa          | 1


how to retrieve and seperate data into spreadsheet form?


thank you everyone.

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      In your spreadsheet, configure the load and store binder to use Multirow Form Binder

        CommentAdd your comment...