JDBC store binder for Spreadsheet

 
1
0
-1

Hi,

I'm trying to use the JDBC store binder for Spreadsheet. The curly brackets are pointing to the spreadsheet field names. It works only for one record but not for multiple records. Are there any INSERT and UPDATE JDBC samples for spreadsheet? Thanks.

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Hi, work ok on my test. Below is my config of jdbc store binder.

      select id from app_fd_spreadsheet_line where id = {id}
 
insert into app_fd_spreadsheet_line (id, c_field1, c_field2, c_field3, c_field4, c_fk) values ({uuid}, {field1}, {field2}, {field3}, {field4}, {foreignKey})
 
update app_fd_spreadsheet_line set c_field1 = {field1}, c_field2 = {field2}, c_field3 = {field3}, c_field4 = {field4} where id = {id}
 
delete from app_fd_spreadsheet_line where id = {id}
        CommentAdd your comment...
      1.  
        1
        0
        -1

        thanks Panda

          CommentAdd your comment...