How to insert custom field data(in create issue screen) into a table in external database?

Question

I have a custome field called ' total no of leaves' in issue screen, need to insert this value into a table in external database. I used jira-database-values-plugin, it works perfectly for select queries but throwing  '[jira.plugin.databasevalues.DatabaseRowCache] Can not issue data manipulation statements with executeQuery()' for insert query. Can any one please suggest me how to insert data?

Anuradha Gopala · Answer

Thanks for the reply :-)

Nic Brough -Adaptavist- · Answer

The database fields are for reading external databases into Jira fields.  Not poking data into remote databases.

You'll need to code something to update external data.