Import Jira fields in confluence

Michael Strickler August 21, 2018

Hello everyone

We are working with Confluence as a intranet tool together with Jira as a issue / sprint planning tool.

I have created a new confluence form with Imput fields.

Now I would like to inserst / import the existing data to my fields from the jira database automaticly into this confluence fields.

 

*** First function: ***

For example I have tree fields with

1) Jira-Number

2) Created

3) Reporter

 

Now, if the user would set the Jira Number "KLM-2033" into the "Jira-Number" field,  I would like to check in the background in the jira databse if the number is available (is existing)... Similar to the Confluence-Macro "Jira Issue / Filter import" I would like to have a process, with a query like (pseudo-code):

{jira-issue:jira-url=https://issues.myCompany.lan|issue-key=$Jira-Number|display-fields=Jira-Number}

$Jira-Number: What I insert into this field

display-fields=Jira-Number: What the field have to display

 

I can define and adapt this query somewhere in the edit mode of the appropriate field. For every field I can adapt the query itself.

 

*** Second function: ***

If the user insert a new value in the "Jira-Number" field or change / edit a value in the "Jira-Number" field, I would like automaticly update the field "Created" like (pseudo-code):

{jira-issue:jira-url=https://issues.myCompany.lan|#listenToField=$Jira-Number|display-fields=Created}

#listenToField: Special command, listen for the input if the user update the value there.

That means the field "Created" takes the new or edited value from field "Jira-Number" -> KLM-2033 and search the appropriate Created date for KLM-2033.

 

For the Reporter field:

{jira-issue:jira-url=https://issues.myCompany.lan|#listenToField=$Jira-Number|display-fields=Reporter}

That means the field "Reporter" takes the new or edited value from field "Jira-Number" -> KLM-2033 and search the appropriate Reporter person for KLM-2033.

 

Have you any idea how we can work with Confluence in this way? With what macro or process we can solve this problem?

Thank you for answering me.

Kind reagards

Michael Strickler

1 answer

0 votes
Vero Rivas
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 15, 2022

Suggest an answer

Log in or Sign up to answer