Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Sync select field from oracle database view

GG
GG
Contributor
February 7, 2021

Hi,

I have SQL database in JIRA. I want to update the values of custom fields in the JIRA from the view of another Oracle database. View of Oracle is FDN_FORM_PDO_VIW.

Is there a way to do this?

 

Regards

GG

Answer
Watch
Like Be the first to like this
449 views

1 answer

0 votes
Mohamed Benziane
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 7, 2021

Hi @GG 

So if i understood well you want to update a customfield in Jira with a value coming from an another database, yoy will need an addon like Elements Connect to link your Jira to an external database. You can even try Scriptrunner or create you own script using Jira API.

View More Comments
GG
GG
Contributor
February 7, 2021

Thanks for your response.

Exactly. I am using custom field option synchroniser plugin.  My problem is that I can not receive field values from Oracle Database View (FDN_FORM_PDO_VIW) with SQL statement. Is there any solution ?

Like
Mohamed Benziane
Mohamed Benziane
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 7, 2021

Maybe a issue right with the db user that you use in the plugin configuration

Like • GG likes this
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events