JDBC store binder for Spreadsheet

Confluence User - 07 Apr, 2018

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.

spreadsheet

2


09 Apr, 2018
confluenceUser
1
confluenceUser

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}
09 Apr, 2018
confluenceUser
confluenceUser

thanks Panda

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print