Import Jira fields in confluence

[Michael Strickler]

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

[Vero Rivas]

Hi @Michael Strickler 

    Look at this post, maybe can help you

    https://community.atlassian.com/t5/Confluence-questions/Import-data-from-Jira-to-fill-out-fields-in-Confluence/qaq-p/1180595

Cheers