Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
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.
In your spreadsheet, configure the load and store binder to use Multirow Form Binder
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.