Update issue custom field base on external database

[Ansar Rezaei]

Hi

I want a read only string/date field that it's value came from an external database. My update query need to pass issue Created / Due Date to external database and return its corresponding value from another column.

For example if I set due date on 10 April for an issue, this custom filed value must set/changed to b.

external database:

            | column1 |  column2 |

row 1  | 10 March |        a       |      

------- |----------  |---------- |

row 2  | 10 April    |        b      | 

------- |----------  |---------- |

row 3  | 10 May    |        c       |

------- |-----------|-----------|

[Tzu Hau Chai]

You will need third party plugins for this, you might want to give this a try: https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.databasecf/server/overview