Documentation for Confluence 5.4.
Documentation for Confluence OnDemand and earlier versions of Confluence is available too.

Skip to end of metadata
Go to start of metadata

JIRA is the issue tracking and project management system supplied by Atlassian. By adding the JIRA Issues macro to a Confluence page, you can display one or more issues from a JIRA site. You can also choose to create an issue in JIRA, at the time of adding the macro to the Confluence page.

Before you can use this macro, your Confluence and JIRA sites must be connected via Application Links. People viewing the page will see the publicly accessible issues from the JIRA site. If your JIRA site has restricted viewing (that is, people need permission to view issues) then they will need to authenticate before seeing the restricted issues. See more about restricted JIRA issues below.

What you can do with the JIRA Issues macro

Using the JIRA Issues macro, you can:

  • Display a table of JIRA issues on your page, based on the results of a search using JIRA Query Language (JQL).
  • Display a table of JIRA issues onto your page, using a JIRA URL.
  • Display a single issue from the JIRA site, or a subset of selected issues from your JIRA search results.
  • Display a count of issues from the JIRA site.
  • Create new issues in JIRA and display the issues on your page without leaving Confluence.

Adding and updating the JIRA Issues macro – an overview

Quick guide to using the macro on a Confluence page:

  1. In the Confluence editor, choose Insert > Other Macros.
  2. Find and select the required macro.

Speeding up macro entry with autocomplete: Type { and the beginning of the macro name, to see a list of suggested macros. Details are in Using Autocomplete.

To edit an existing macro: Click the macro placeholder and choose Edit. A macro dialog window will open, where you can edit the parameters of the macro.

 

Screenshot: Example of JIRA issues macro on a Confluence page


Displaying issues via a JIRA Query Language (JQL) search

You can use the macro to display a table of JIRA issues on your page, based on the results of a search using JIRA Query Language (JQL).

JQL is a simple query language, similar to SQL, which works in JIRA. A basic JQL query consists of a field, followed by an operator (such as = or >), followed by one or more values or functions.

Examples:

  • The following query will find all issues in the 'TEST' project:

    project = "TEST"
  • The following query will find all issues in the 'documentation' component of the  'CONF' project:

    project = CONF and component = documentation

For more information about JQL syntax, see the JIRA documentation: Advanced Searching.

To display a table of issues based on a JQL search:

  1. Insert the JIRA Issues macro onto your Confluence page, as described above.
  2. Choose a JIRA server next to the Search button.
  3. If prompted, log in to the JIRA server.
  4. Enter the JQL query into the Search box.
  5. Choose Search.
  6. If you want to customise the display, choose Display options and adjust the columns and number of issues that will appear in your table of issues.
  7. Choose Insert.

Screenshot: Display options in the JIRA Issues macro browser.

Displaying issues via a JIRA URL

You can paste any of the following JIRA URLs into the JIRA Issues macro. Confluence will immediately convert the URL to a JQL search.

  • Any URL for a JIRA issue search or filter.
  • A URL for a single issue.
  • The URL of the XML view of a JIRA search.

Auto-convert: You can paste a JIRA URL directly into the Confluence editor (without calling up the macro browser). Confluence will automatically convert the URL into a JIRA Issues macro.

Displaying a single JIRA issue, or selected JIRA issues

To display a single JIRA issue, choose one of the following methods:

  • Paste the URL of the issue directly onto the Confluence page. (There is no need to use the macro browser.) Confluence will auto-convert the link to a JIRA Issues macro.
  • Or: Add the JIRA issues macro to the page as described above, and choose Recently Viewed to see the JIRA issues you have visited recently. Select an issue and choose Insert.
  • Or: Add the JIRA issues macro to the page as described above, and past the issue URL into the search box in the macro browser.
  • Or: Add the JIRA issues macro to the page, define your search criteria in the macro browser via JQL as described above, then select the check box next to the issue in the search results, within the macro browser.

To display a subset of JIRA issues from your search results:

  1. Add the JIRA issues macro to the page.
  2. Define your search criteria in the macro browser via JQL, as described above.
  3. Select the check boxes next to the required issues in the search results, within the macro browser.

Screenshot: Selecting a subset of issues to display

Displaying a count of issues

You can choose to display the number of issues returned by your search, rather than a table of issues. The JIRA Issues macro will display a count of issues, linked to the search in JIRA.

Screenshot: The JIRA Issues macro displaying an issue count on a Confluence page

To display an issue count:

  1. Add the JIRA issues macro to the page.
  2. Define your search criteria in the macro browser via JQL, as described above.
  3. Choose Display options, then choose Total issue count next to 'Display options' in the macro browser.
  4. Choose Insert.

Creating a new JIRA issue in the editor

While editing a Confluence page, you can create an issue in JIRA and display it on your Confluence page, without leaving the Confluence editor.

To insert an issue into JIRA:

  1. Add the JIRA Issues macro to the page, as described above.
  2. Choose Create New Issue.
  3. Supply the information about your JIRA server, project, and issue, as prompted.
  4. Choose Insert.

Confluence will send a request to JIRA, to add the issue to the JIRA site. Confluence will also display the resulting JIRA issue on the Confluence page.

Notes:

  • This feature works best with JIRA issue types whose mandatory field requirements have not been altered. With the exception of a JIRA issue's 'Component/s' or 'Fix Version/s' fields, You cannot use the JIRA Issues macro to add an issue whose issue type has customised mandatory field requirements. (Exception: customisations of the 'Component/s' and 'Fix Version/s' fields are accepted.)
  • If your JIRA project has customised fields, the JIRA Issues macro will not prompt you for information for those fields. In other words, those fields will not appear in the 'Create New Issue' dialog in the JIRA Issues macro browser.

Configuring Application Links to display restricted JIRA issues

Before you can use this macro, your Confluence and JIRA sites must be connected via Application Links.

If the JIRA site allows anonymous viewing of issues, you must configure an application link, but there is no need to configure any incoming or outgoing authentication between JIRA and Confluence. People viewing the Confluence page will see the publicly accessible issues from the JIRA site.

If your JIRA site has restricted viewing, or if some JIRA projects or issues are restricted to viewing by certain people, then people will need to log in before seeing the restricted issues.

In such a case, the outgoing authentication in the Confluence Application Links determines how the JIRA Issues macro handles restricted issues:

  • If the outgoing authentication is set to Trusted Applications, people can see restricted issues in JIRA if their username is the same in JIRA and Confluence, and if they have permission in JIRA to see the issue.
  • If the outgoing authentication is set to OAuth, people may need to choose Login & Approve, to gain access to the JIRA server and restricted issues.
  • If the outgoing authentication is set to Basic Access, users will need to login to see any JIRA issues that are visible to the user account specified in the outgoing authentication setting.

Rendering HTML from JIRA

Formatted fields from JIRA can be displayed in Confluence if you set up a Confluence-to-JIRA application link. Otherwise, such formatted fields will be escaped within the output of the JIRA issues macro. This is to prevent the possibility of malicious HTML being served by an untrusted JIRA server. The most likely field where you will notice this is in the description field.

This example shows how a description column may be displayed in JIRA:

Description

This is

  • the description
  • of my issue

If there is no application link between JIRA and Confluence, the description will appear in the JIRA issues macro like this:

Description

<p>This is<ul><li>the description</li><li>of my issue</li></ul></p>

Disabling the JIRA Issues macro

The functionality is provided by an add-on (plugin) called 'JIRA Macros'. To make the macro unavailable on your site, you can disable the add-on. See Disabling and enabling add-ons.

Notes

HTTPS: The JIRA Issues macro can access a JIRA site running under SSL provided the Confluence server is configured to accept the JIRA SSL certificate. See Connecting to LDAP or JIRA or Other Services via SSL.

Custom fields can be added as columns to the table simply by using the name of the field with no quotes. Earlier versions of the macro required you to use the custom field id, e.g. customfield_10100.

Code examples

The following examples are provided for advanced users who want to inspect or edit the underlying markup for a Confluence page. 

Macro name: jiraissues

Macro body: None.

Note: A number of additional parameters that are not available via the macro browser are available in storage format and wikimarkup.

Parameter name

Required

Default

Parameter description and accepted values

anonymous

No

false

If this parameter is set to 'true', JIRA will return only the issues which allow unrestricted viewing. That is, the issues which are visible to anonymous viewers, as determined by JIRA's viewing restrictions. If this parameter is omitted or set to 'false', then the results depend on how your administrator has configured the communication between JIRA and Confluence. By default, Confluence will show only the JIRA issues which the user is authorised to view.

Note: This parameter is available only if you insert the macro via wiki markup or by editing the storage format of the page. The graphic user interface (macro browser) for the JIRA Issues macro does not offer this parameter.

baseurl

No

The value of the 'url' parameter

If you specify a 'baseurl', then the link in the header, pointing to your JIRA site, will use this base URL instead of the value of the 'url' parameter. This is useful when Confluence connects to JIRA with a different URL from the one used by other users.

columns

No

By default, the following columns are shown:

  • type
  • key
  • summary
  • assignee
  • reporter
  • priority
  • status
  • resolution
  • created
  • updated
  • due

A list of JIRA column names, separated by semi-colons (;). You can include any columns recognised by your JIRA site, including custom columns. See the JIRA documentation for a list of names.

count

No

false

If this parameter is set to 'true', the issue list will show the number of issues in JIRA. The count will be linked to your JIRA site.

cache

No

on

The macro maintains a cache of the issues which result from the JIRA query. If the 'cache' parameter is set to 'off', the relevant part of the cache is cleared each time the macro is reloaded. (The value 'false' also works and has the same effect as 'off'.)

Note: This parameter is available only if you insert the macro via wiki markup or by editing the storage format of the page. The graphic user interface (macro browser) for the JIRA Issues macro does not offer this parameter.

height

No

480 (if render mode is dynamic)

The height in pixels of the table displaying the JIRA issues.
Note that this height specification is ignored in the following situations:

  • If the 'renderMode' parameter (see below) is set to 'static'.
  • When the JIRA issues are displayed in a PDF or Word document, in an email message or in an RSS feed.

Note: This parameter is available only if you insert the macro via wiki markup or by editing the storage format of the page. The graphic user interface (macro browser) for the JIRA Issues macro does not offer this parameter.

renderMode

No

static

If the value is 'dynamic', the JIRA Issues macro offers an interactive display which people can manipulate as follows:

  • Click the column headers to sort the output.
  • Drag and drop the columns into a different order.
  • Temporarily remove a column from the display.
  • View a page of issues at a time, for faster response times.

A value of 'static' will disable the dynamic display features.

Note: This parameter is available only if you insert the macro via wiki markup or by editing the storage format of the page. The graphic user interface (macro browser) for the JIRA Issues macro does not offer this parameter.

url

Yes

none

The URL of the XML view of your selected issues in JIRA Issue Navigator.

Note: If the URL in the 'url' parameter does not contain a tempMax argument, then the value of tempMax will default to 500. If your JIRA server is version 3.12 or earlier, this means that the JIRA Issues macro will return a maximum of 500 issues. If your JIRA server is version 3.13 or later, a value of 500 means that the JIRA Issues macro will return a maximum of 500 issues per page.

width

No

100%

The width of the table displaying the JIRA issues. Can be indicated either as a percentage (%) or in pixels (px).

Note: This parameter is available only if you insert the macro via wiki markup or by editing the storage format of the page. The graphic user interface (macro browser) for the JIRA Issues macro does not offer this parameter.

Storage format example

Example using a URL that points to the XML view of a JIRA search:

Example using JQL – note that Confluence will insert the server and serverId parameters, based on settings in Application Links:

Wikimarkup example

 

 

332 Comments

  1. Where can I find the source code for the V2.7 of the JIRA macros library?

    I cannot find it in the source for V2.8 of Confluence

    1. Hi Daniel,

      Feel free to check out its source code in the following repository:

      For JIRA macro version 2.7 specifically, you may want to try the following direct link:

      Cheers,
      Tony

      1. Anonymous

        These links 404.

  2. Trackbacks in JIRA does not detect the Confluence pages that use this {jiraissues} macro. We have to make an explicit reference to the JIRA issue URL from the Confluence page to make this work.

    1. Hi Ramkumar,

      I would suggest you to raise a support ticket at https://support.atlassian.com for further investigation to this issue. Please provide the wiki markup used for the problematic page. Thanks.

      Regards,
      MG

      1. I have raised the issue: https://support.atlassian.com/browse/CSP-19821

        An explicit URL reference from Confluence generate a Trackback link in JIRA but the same does not happen thru {jiraissues} macro.

  3. Tony, I suspect that the parameter "template" is not supported since it is not documented on this page. Is that right?

  4. I expect the problem's due to a saved filter in JIRA that's private, and the lack of authentication credentials passing between Confluence 2.7 and your JIRA.

    It may be that you only need to go into JIRA, manage your filters, and mark this particular one as shared (or global or whatever). Else, you need to look up the method of passing credentials in your jiraissues macro call – but you could instead try Setting Up Trusted Communication between JIRA and Confluence with an updated Confluence.

    Cheers,
    -jd.

  5. I posted a possible fix for the broken "Atlassian JIRA" link in the jiraissues macro (CONF-10564, among others), since JIRA 3.7-ish. Hopefully something like this will finally get into the release.

    Cheers,
    -jd.

  6. Quick question. The jiraissues macro does seem to work well now that we have trusted communications set up (Jira Enterprise Version 3.12.1 Build Number 299, confluence 2.8 enterprise); however not all the icons show up properly for the field type and priority. Looking at the html I see for the issues that it does show up for the hmtl looks like: src="https:ourservice/jira/images/icons/issue_subtask.gif; whereas for the ones that don't show up we have <img src="$icons.get( $item.getChild('type').getValue() )".

    Note that on Safari I see a broken image link. On Firefox I get the type or priority text as a hyperlink.

    Thoughts on what's going on? I suspect that the type and priority that aren't showing up are ones we created in JIRA, but we're using the default icons w/in JIRA so I'm curious about what we need to do to have the icons appear.
    thanks

    1. Hi Michael,

      Could you please check that the image's URL of the same issue type does match each other in Confluence and JIRA? You might also want to make sure that the icon mappings are correct, if you have any custom issue types:

      If that does not help, I would suggest you to raise a support request at http://support.atlassian.com. Thanks.

      Cheers,
      Azwandi

  7. G'day,

    I was just wondering which version of Jira Trusted Applications became available in? We are running Jira 3.11 and I'm unable it see the Trusted Applications link in the Administrator console.

    Cheers,

    John R

    1. trusted applications is available in jira starting at v3.12 (and confluence v2.7)

  8. Anonymous

    Hi, we are currently encountering issues when displaying {jiraissues}
     
     
    We have done various things to remedy this:
    1. Ensured user is logged in on both wiki and jira and is using the same userid
    2. Increased the Request timeout in Jira and Wiki (2000000)
    3. Ensured the IP Address Matches are correct on both Jira and Wiki Trusted App setup.
    4. We've checked the logs (catalina.out/access_log.2008-10-08) and we dont see any weird exceptions.
    5. We've tried flushing cache 
    But the error is still there. The most recent activity prior to this happening was we restarted our server. 
    Pls advice.

    1. this error may be caused by incorrect macro parameter usage (for example, putting something other than the url param in first spot and not marking it with "columns=" or whatever). not sure what was happening here but i guess you got it fixed because you give a new error below. (new errors mean progress, yay! (tongue))

  9. 2t

    Sorry for the duplicate...
    Hi, we are currently encountering issues when displaying jiraissues macro.

    We are using Jira3.12.13 and Confluence2.9

    "jiraissues: Could not download[http://jira.lawson.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?type=3&pid=10100&sorter/field=issuekey&sorter/order=ASC&sorter/field=status&sorter/order=DESC&tempMax=10] : caused by : Read timed out" 
     
    We have done various things to remedy this:
    1. Ensured user is logged in on both wiki and jira and is using the same userid
    2. Increased the Request timeout in Jira and Wiki (2000000)
    3. Ensured the IP Address Matches are correct on both Jira and Wiki Trusted App setup.
    4. We've checked the logs (catalina.out/access_log.2008-10-08) and we dont see any weird exceptions.
    5. We've tried flushing cache 
    But the error is still there. The most recent activity prior to this happening was we restarted our server. 
    Pls advice.

    1. Hi 2t,

      do you have a solution for your problem? We are a facing a similar error with the jiraissues macro and an own pluging using trusted application.

      Regards

      Boris

    2. Anonymous

      Free knowledge like this doesn't just help, it promote dmeocrcay. Thank you.
  10. We're running the jiraissue macro in Confluence 2.9 against Jira 3.11. If we link to an XML filter which returns no records in Jira, the macro produces the following output:

     jiraissues: Error on line 31 of document http://www.w3.org/TR/html4/loose.dtd: The declaration for the entity "HTML.Version" must end with '>'.

    Has anyone else seen this problem? Is it a problem with the macro, or the way we're using it?

    Cheers,

    John R.

    1. Hi again John~

      This error occurs when the macro has trouble parsing the XML returned from JIRA. This can occur if the url given to the macro points to something it shouldn't, but it could also mean the macro is encountering valid XML that it isn't expecting for some reason. We should probably have better handling of these cases...

      Two common ways for this to occur:

      • JIRA is down - the retrieved info could be an html error page that can't be parsed as xml because it isn't
      • url is not the XML view url

      If the above cases aren't the problem, please create an issue about this, including your JIRA Macros Plugin version and ideally the macro syntax you are using and the XML file that is returned by JIRA when you visit the url given in the url parameter.

      ~Cheryl

      1. Anonymous

        John, I found this happened if I didn't paste the link correctly. I did a simple copy paste, but you have to use the view-->XML–copy link way to create an XML request.

         

        I nice way to troubleshoot this app is to add it to a post in confluence, change parameters and keep hitting refresh in the preview screen. much quicker

         

        -Ezra

  11. Anonymous

    Hi do some one knows if the jira issue macro supports size option?

    {jiraissues:url and params|width=800|height=800}

    I entered width and height parameters. The height parameter seems to word, but the width has no impact to the display of the list in a confluence wiki page.

    It would be very usefull I could define a maximum width and height.

    1. the latest version of this plugin, which is currently used here on confluence.atlassian.com though the version of confluence this plugin is bundled with is not yet released (we're testing it out here), includes a height but not a width parameter. the previous version included neither height nor width parameters.

  12. This error occurred for me also.  I'm using Confluence 2.10 and JIRA 3.13.  In my case, it appears to be related to using a https url.  When I changed my url to point to the http address, the error did not occur and I could see my issues.

    1. That old chestnut. you need to import the Certificate Authority (CA) that signed your SSL certificate into the Java Runtimes trust store so that when Java connects with SSL, it is able to walk the chain of signers and verify its authenticity. No CA = untrusted certificate = no ssl connection. If you have a self-signed cert, just import that instead. Oh, and the SSL server FQDN does match the CN of the certificate, right?

      In addition to importing into the trust store you may need to explicitly identify its location and passphrase to open it. Default JRE trust store location is JAVA_HOME/jre/lib/security/cacerts. changeit is the default JRE password, really.

      Get the signer cert (exercise for the student (smile)) and do this from the security folder:

      keytool -storepass changeit -alias yourcacertalias -import -file yourca.cer
      

      (info) Of course, if you upgrade your JRE you will need to do this again, and if you take a copy of the cacerts file, eventually, ca's will expire, and it will be broken that way.

      ttfn

  13. Is there any way to parametrically specify the query parameters (ie. specify the same type of information like desired user, status, date range)?  Basically, generate a dynamic filter at page load time, rather than having to reference a pre-made filter in JIRA?

    For example, it would be nice to have a filter for "show me the issues marked 'closed' for user in the pastdays".

    Then, in some Confluence page, do

    or

    It appears to me the answer is "no, neither {jiraissues} nor JIRA itself can do that".  Without this capability, I'd have to create separate filters in JIRA for "Bob @ 30 days" and "Frank @ 7 days", which is not desireable.  Is that a correct assessment?  Where would I create such a feature request?  It would greatly improve Confluence<->JIRA integration, in my opinion...

    1. Hello David,

      If you wish to modify your JIRA Issues macro filter with the specific parameters you have described, you currently have to recreate the JIRA query as described in step 1 above.

      When you create a JIRA query with your specific filters, the parameter-value pairs that represent each specific filter will be present in the XML link URL. If you make a note of these parameter-value pairs, you could insert them directly into the URL contained within your {jiraissues} command in Confluence. However, be aware that we currently do not support this approach.

      Kind regards,

      Giles Gaskell
      Technical Writer
      ggaskell@atlassian.com
      ATLASSIAN - http://www.atlassian.com

  14. Is there a way to modify the link between the issues listed in a jiraissues list and the issues in the jira.
    Ideally we want to beautify the detail issue. ie. instead of linking ISS-123 to http://jira.acme.com/browse/ISS-123, linking it to http://customers.acme.com/issueportal?issue=ISS-123.

    1. the plugin simply uses the contents of the link element in the xml returned from jira to determine for each issue link. so no your request is not possible out of the box.

      the plugin is open source so if you really need the link substitution, you can modify the plugin. see our "how to build an atlassian plugin" documentation and the plugin source to get started

      another option might be creating a custom field in jira for the special link and then requesting that column with the jiraissues macro.

  15. I will adapt the plugin as the link should contain the key, and I can't expect that the users are going to fill in the custom field,
    unless there is a way to automatically generate the content of that custom field (question)

    Tx

    1. there should be a way to generate the field contents in jira, but i think if you can adapt the plugin that is the way to go since you can get more precisely want you want. (if you made a link custom field, the other columns in the jiraissues table would still use the non-preferred link and that could be confusing for users.)

  16. Version 2.8.7 of the issues macro really rocks, because now you can choose any JIRA column you like. There are only two annoying problems left:

    The description column does not support german umlauts, as for example the summary column does:

    Furthermore an automatic word wrapping would be very helpful for the description column, as those texts tend to be long...

    We are using Confluence 2.10 and JIRA 3.13.2.

    Thanx in advance

    Markus

    1. hi markus~

      is the text you give an example of contents of a description column where the umlauts are not displayed? i was able to make a test issue with umlauts in the summary and description and it seems to show up fine in the new jiraissues macro. the issue is at http://jira.atlassian.com/browse/TST-17248 and i used this macro syntax:
      {jiraissues:anonymous=true|url=http://jira.atlassian.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10420&status=1&sorter/field=issuekey&sorter/order=DESC&tempMax=10|columns=type;key;summary;description}
      let me know more about the problem you're seeing.

      about the description wrapping, i thought we had done this but i verified that it is not occurring and filed an issue: http://developer.atlassian.com/jira/browse/CONFJIRA-124

      ~cheryl

      1. We have the same error with the umlauts, but only on custom fields. (I have seen it in a custom text field (< 255 characters))

        1. hmm, i just added umlaut-containing text to the issue mentioned above in a custom text field called Random text. then i tried the jiraissues macro again, adding that column: {jiraissues:anonymous=true|url=http://jira.atlassian.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10420&status=1&sorter/field=issuekey&sorter/order=DESC&tempMax=10|columns=type;key;summary;description;Random text}
          i'm still not seeing the problem. does anyone have a public jira instance where it is occurring where they can point to an example?

          1. It works only, if the jira field is set to the Wiki Style Renderer. The error occurs only with the Default Text Renderer.

  17. Macro works fine, but I am wondering if there is a way to configure the display so that table hight automatically adjusts based on the number of issues. In some cases we do not have many issues and 'large' blank space between the issues and page number footer is looking ugly. If I remember correctly we did not have this problem with 2.5.6 version confluence we were using earlier. We are currently using confluence 2.10 and jira 3.13.2. Our users are complaining about this display and it would be nice to have a solution.

    1. no, you cannot have the height auto-adjust based on the number of issues returned. one reason is that the amount of space each row takes is browser and user settings dependent, so the correct height to auto-adjust to is not apparent.

      you are correct that the older version of the jira issues macro did not have this issue, because it wasn't dynamic and was using a different ui. you can force the old style ui to be used with the renderMode=static parameter, but you will lose the new dynamic features. you might instead use the height parameter to manually set the height you'd like.

      1. Hello Cheryl - your tip on the renderMode=static was exactly what I was looking for as I'd like to limit the real estate this macro takes up on the confluence page. I have a use case where I need to display a single issue and 3 fields. Is it possible to limit the macro with other parameters to get something like this (without the issues header to sort)?

        Desired output

        Description

        Key

        Status

         

         

         

        Current (with renderMode=static)

        1 (issues)

         

         

        Description

        Key

        Status

         

         

         

        1. Claudia... Did you ever find a solution?   I am trying to use the same exact concept and I am getting the same exact row 1 (issues)

  18. I still seem to have difficulty getting any custom fields displayed - I have Confluence 2.7.1 and Jira 3.11 and my macro is as follows (with the usual sensitive info changed to protect the guilty..)

    My regular fields show up just fine, but even when doing a 'view-source', it's like Confluence doesn't even see that column coming back.. I've played around with the order of the columns in the string as well as tried other customfield items with no luck.

    Any suggestions?

    1. hi jason~

      displaying custom fields with the jiraissues macro was added in a version of the plugin that is unfortunately not compatible with confluence versions less than 2.10 (and it is bundled there). also, the name of the field is used in the columns parameter rather than the id.

      ~cheryl

  19. Is there any workaround to put a width setting in.  It's important for the way our system is configured.  As 100% width is breaking things on our end.

    Just to followup, this page is suffering the exact problem our site is having.  We insert the tree on the left side of most of our pages.  If there is a jira object on the right it pushes the scroll bar all the way to the right, and it smooshes the tree navigation.

    Thanks so much

    Dan

    1. dan, it's not a workaround but it is something: there's an issue for it. and you may be interested in the related issue, where it is mentioned that width issues are high priority

  20. It's called "fixversion".

    You will find the field names in the xml export from Jira's Issue Navigator.

    Regards,

  21. hi adam~

    we can't see your syntax used because confluence is trying to render the jiraissues macro here. could you leave off the brackets or escape them with backslashes (one in front of the bracket)? thanks.

    ~cheryl

  22. Thanks for the tip

    jiraissues:anonymous=false|columns=key;summary;Ideal Days;assignee;fixVersion|url=http://xxxx.xxx.com:xxx/sr/jira.issueviews:searchrequest-xml/10038/SearchRequest-10038.xml?tempMax=1000

    The other thing I've noticed in the xml from Jira each issue is part of 2 Versions

    ' <fixVersion>Reporting - Iteration 2</fixVersion> <fixVersion>Reporting - Rationalise Reports</fixVersion>'

    Could this be causing the problem.....

    1. hi adam~

      you are right – thanks for pointing this out. unfortunately this is a bug triggered by multiple fixVersions. i filed a new issue for the problem.

      ~cheryl

      1. MMA

        I get the same thing in my jiraissue which looks like this:

        No multiple fixVersion at all. Course I have the multiple statuses...but removing those had no effect.

        1. Hi MMA~

          What error are you getting? In any case, you may want to create a support request about it if you haven't.

          ~Cheryl

      2. Anonymous

        Cheryl -

        I've run into the same issue. I've removed any 'sorter/<whatever>' parameters and still get the "jiraissues: Unable to determine if sort should be enabled." error.

        We are on Jira 3.13 and Confluence 3.1

        Any movement on this?
        The issue that you opened (CONFJIRA-130) doesn't seem to have been assigned or moved.

        This was a very helpful integration when it worked.

        Thanks.

        1. Hi~

          Although above comment says "Unable to determine if sort should be enabled", that wasn't actually the error Adam was seeing (CONFJIRA-130 was actually fixed – check the source tab to see the code changes). Confusingly, it is just the error when his comment tries to render an example macro with incorrect syntax.

          However, there was another issue for the problem you describe: CONFJIRA-154. (BTW, you'll notice that the issue was fixed by improving the error messages, so you may be able to get a better error message by upgrading your plugin version.) If you can't find the problem from that issue, you'll want to create a support request so our support team can help diagnose your individual situation.

          ~Cheryl

  23. Anonymous

    The size of a jiraissues macro pane defaults to about double the width of a standard browser, and fills most of the hight of a standard browser window.  The font is also unnecessisarily large and there is far too much whitespace and wasted space, even in the example on this page.  (The control bar seems reasonable, though).  Is there a way to reduce not just the width and height of the window, but to reduce the scale of the entire widget as a whole, including font size and table cel and header size and spacing?

    1. i don't think there is a built-in way to change the scale. you could try modifying the plugin's css to your liking, by creating a new version of the plugin itself or by using a tool such as greasemonkey to modify the css on the fly locally

  24. Dear Cheryl!

    I really like this makro - but I have one problem:
    We always use anonymous = false, and if I don'T have enought permissions, I get:
    "jiraissues: Error on line 6: The reference to entity "N" must end with the ';' delimiter."
    as an error massege in Confluence.
    This makes in quite unusable for us because we never want to see a customer of us to see a technical error massege like this.
    Is it possible to replace it quickly with one like "Sorry, you don't have permission to see the issues" in the next days?
    (We are using Confl 2.9.1)

    Thank you very much,
    Tido

    1. Hi Tido~

      What you describe sounds like it could be a bug. If you can provide more details, we can investigate it further. You can create an issue in the Jira Macros Plugin project. Please provide the macro syntax you are using and a saved copy of the XML that you get when visiting the location in the url parameter. If this information should be private, you can mention that in the issue and mark the security level as "Reporters and Developers".

      However, note that the latest version of the macro is not compatible with Confluence 2.9.x and there have been many bugfixes and new features since the older macro version was created. So, we may find that the best solution to your problem is to upgrade Confluence and the macro.

      ~Cheryl

  25. Hi Cheryl

    What I meant by "nicely" is in confluence 2.9 the summary field does not take over the whole space, you can see the other colums - it seems like the size of the summary column is dynamic and shrinks so the other columns can be displayed on the screen. With 2.10 version if summary if the first colum it fills the display window and you have scroll to see the other columns, So we have to place the other columns ahead of the summary column. In some instances that works ok, but in other places it makes the information a bit awkward in presentation.
    Does that make sense?

  26. Jira 3.13 and Confluence 2.9

    Have a filter in Jira that displays an Issue and it's substasks using two components to get the issue and subtasks I want. It displays correctly in Jira.
    when I copy the xml to Conflunce to do up the JiraIssues macros I get nothing but the header for the filter and no rows for the actual task and sub tasks. The name of filter is there with zero issues and column names are listed.

    code:
    jiraissues:cache=no|url=http://nnn.nnn.nnn.nnn:8080/sr/jira.issueviews:searchrequest-xml/10103/SearchRequest-10103.xml?tempMax=1000&os_username=wikiuser&os_password=wikipass

    Yet when I click on the filter name in the header I get the rss feed and everything is there - issues, sub taksks and descriptions.

    any ideas?

    1. I could not replicate this on a local instance. Perhaps, you can try creating a saved filter in our JIRA and see how it goes. I presume it does not affect unsaved filters or any other saved filters? Although it is not likely to be an issue, you might want to ensure the credentials are correct.

  27. Hi,

    I'm using Jira 3.12.3 and Confluence 2.9.2.  They are listed as trusted apps for each other.  When I tried to use this macro, I received the following error:

    "Errors were reported by the JIRA trusted connection.
    OLD_CERT; Certificate too old. Application:

    Unknown macro: {0}

    Certificate Created:

    Unknown macro: {1}

    Timeout:

    Unknown macro: {2}

    ; ["confluence:14638695","Fri Mar 27 16:25:53 GMT\-08:00 2009","10000"]"

    Any idea why?

    Thanks!

    1. Hi,

      Please have a look in the following page which may be useful for you:

      If you still encounter the problem, please raise a suport ticket to https://support.atlassian.com

      Cheers,

  28. That worked, thank you!!

    However, I have a new problem - I want to show the issue type, key, summary and description.  Everything shows up but the description.  Why would that be?

    1. Hi Sally,

      Is the column name correct (i.e "description")? You might want to test this macro which works for me:

      1. Hmm, I copied what you wrote and it's still only showing the Key, Issue type and summary.  (sad)

        1. Hi Sally,

          Sorry that I didn't realise that you are using Confluence 2.9.2, hence the latest plugin version compatible is 2.8.1.2. In order to get more fields displayed, you will need to upgrade to Confluence 2.10.x (plugin version 2.8.7 - a new plugin architecture has been implemented, hence incompatible with Confluence pre 2.10.x).

          Hope that helps,
          Azwandi

          1. Thanks, Azwandi!

  29. Anonymous

    Trying to display Jira issues into Confluence (2.10) and I cannot display the 'Affects version/s' field tried affectsversion and a ceratin number of case/spelling changes.

    Any ideas?

    Alex

    1. Some fields with a different syntax.
      Cheers,

      Jira Field Name

      jiraissues Column Key

      Info

      Affects Version/s

      version

      Attachment

      Attachments

      attachment counter

      Comment

      comments

      comment counter

      Component/s

      component

      Due Date

      due

      Fix Version/s

      fixversion

      Issue Type

      type

      Original Estimate

      timeoriginalestimate

      Remaining Estimate

      timeestimate

      Time Spent

      timespent

      1. Thanks for creating this list Bernhard, I think it will be useful for many people.

        In general, the column key you give to the Jiraissues Macro should match the name of the field as written in the issues XML. So if you are having problems getting a particular field, make sure those names match.

      2. from the latest sources (jiraissues-macro 2.8.8) i copied the available default fields:

        "description", "environment", "key", "summary", "type", "parent", "priority", "status", "version", "resolution", "security", "assignee", "reporter", "created", "updated", "due", "component", "votes", "comments", "attachments", "subtasks", "fixVersion", "timeoriginalestimate", "timeestimate"

        It's like Bernhard wrote, e.g. in JIRA its called Sub-Tasks in jiraissues its stated subtasks. There are quite some doubts with this "implementation", e.g. the subtasks are not rendering as links and they dont get linefeeds for each entry (more than one isnt displayed as from the second one it gets hidden).
        I hope the jiraissues-plugin gets a 3.0 that deserves this name, with complete documentation, nice scaling and maybe some more parameterized settings. Cant really enjoy myself with the new fixed height and with of the macro.

        Edit: After some digging, found some more interesting fields on time tracking (Aggregate fields):

        aggregatetimeoriginalestimate, aggregatetimespent

        aggregatetimeestimate, aggregateprogress do not work somehow

      3. Anonymous

        Hi,

        Than ks for the list Bernhard.

        timespent is not working for me. Even though I add it as timespent in the list of columns, the values are not displayed.

        Do you know what could be the reason?

        Regards

        Hande

  30. Hi,

    Is it possible to change the size of the jiraissueMacro render?

    I have a left side navigator and when I display this Macro the section is reduced. Even when I use only two parameters in the table (Type and summary) I have this problem.

    Thank you

    1. Hi Amina~

      It is not currently possible, but that feature has been implemented and is scheduled to be included in the next release of the Jira Macros Plugin.

      ~Cheryl

  31. Anonymous

    When following the procedure to include a JIRA issues list, I cannot get the XML url to correctly display all of the issues. Only the first issue is shown, but not the newly created ones. Any clues what I am doing wrong?

    My filter in JIRA does correctly show all three issues, and the MaxTemp parameter is set to 1000 but only 3 issues in this test project.

    Many thanks,

    Bernie.

    1. Hi Bernie~

      Two possibilities come to mind:

      • some of the issues are not visible to anonymous users, and you haven't provided the macro url with authentication parameters and trusted apps is not configured - if this is the case, see the Displaying Issues which have Restricted Viewing section above
      • you are getting a cached view of the issues - try clicking the blue refresh button to see if the additional issues show up and consider using the macro parameter cache=off

      ~Cheryl

  32. Anonymous

    When specifying the following, I only see Key, Summary, Status, Assignee displayed:

    columns=key;summary;description;fixVersions;status;assignee

    We are using JIRA Enterprise Edition, Version: 3.13.2 and  Atlassian Confluence 2.9.2

    1. Displaying custom fields with the jiraissues macro was added in a version of the plugin that is unfortunately not compatible with Confluence versions less than 2.10, because creating the plugin's new features required adding features to Confluence first.

  33. Anonymous

    We are currently using Confluence 2.10.2 and JIRA 3.13-#330. When we display the JIRA issues in JIRA the headers are in French. However, when using the jiraissues macro in Confluence the headers are in English. Both JIRA and Confluence are configured to display in French. How do I obtain the headers in French?

    1. it seems that the header's title is having a fix string. You may want to raise an improvement request to our jira:

      * http://jira.atlassian.com

    2. you can probably change that by changing the jiraissues.properties file. Either by compiling the plugin or maybe in the classes folder of the webapp. There you can specify the Column-names for your Confluence-installation (it will be consistent for all macros, its not parameterizable, so far), looks like:

      jiraissues.column.type=Type
      jiraissues.column.key=Key
      jiraissues.column.summary=Summary
      jiraissues.column.assignee=Assignee
      etc...

    3. analysed it a bit more. The jiraissues.properties file is the default one. It is already the i18n-file. So if you want a German locale you just copy this and rename it to jiraissues_de.properties (accordingly for french, of course). A German locale would look like:

      jiraissues.issues=Anliegen
      jiraissues.column.type=Typ
      jiraissues.column.key=Key
      jiraissues.column.summary=Übersicht
      jiraissues.column.assignee=Bearbeiter
      jiraissues.column.reporter=Melder
      jiraissues.column.priority=Priorität
      jiraissues.column.status=Status
      jiraissues.column.resolution=Lösung
      jiraissues.column.created=Erstellt
      etc...

      The point is, that Atlassian did not yet even translate all default fields here. So it is a bit more experimentall than just to copy the properties file.

  34. I have a custom 'User Picker' field which I want to display. When using the issue navigator in Jira, the persons full name is displayed, but the jira issues macro displays the username. Is there a way to get jiraissues to display the fullname rather than username?

    1. Hi Mike,

      jiraissues macro does downloading and extracting the data from an xml (if you click xml link from the issue navigator). By default, the xml link does not display the value of fullname but it does display username only. That's why jiraissues cannot display the fullname because the data is not there. In order to make jiraissues can display the fullname, you need to modify behavior of jira (customize jira core code) so that when you click the link xml (to generate an the data in xml format), it will give you fullname.

      Cheers,

  35. Is there any way to keep the user from having to scroll in two directions to see the content of the jiraissues macro?

    I can immaginge a couple possibilities:

    * Flag to ensure that All fields have SOME of the realestate

    * Ability to specify column widths/%'s

    Right now the table is big enough that it can not be reaonably displayed on out monitors.

    1. Hello Hasan,

      As far as I am concerned, user can now specify the height and width parameters of the table. Please refer to the the "Parameters" section above for more details.

      Cheers,
      Azwandi

      1. So the height and width allow me to ensure that the table fits into the page. That is great as far as it goes.

        The problem is that when you have say a long description and a long summary, the actual content is more than will fit in the width of the page. What I want to do is force word wrap in a column (say description) so that a user only need to scroll vertically to see all of the content of the table.

        As is stands now, the user will have to scroll both horizontally and vertically to see the entire table.

  36. Anonymous

    Confluence 2.10.1
    Jira Enterprise Edition, Version: 3.13.2-#335

    Trusted relationship has been set up between JIRA and CONFLUENCE.

    Imbedded Macro URL:

    {jiraissues:cache=off|url=http://jira:8080/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?sorter/field=issuekey&sorter/order=DESC&tempMax=1000\}

    Issues:
     Click on TYPE, KEY, or SUMMARY column two things happen:
      1. JIRA is requiring a login
      2. Back arrow to CONFLUENCE requiring a login.

    Questions:
     1. How do I eliminate the login requirement?
     2. How do I eliminate the back arrow requirement?

    1. Hi, there. Sorry if this is a little too late. Judging by your description, I'd suggest you to raise a support ticket at https://support.atlassian.com in case this problem has been unresolved.

  37. everytime someone comments here I get the page emailed to me. I'm not watching it, and have never commented before that I can see.

    I can't see any way to stop this - do I have to log an issue about Atlassian's confluence to figure this out?

  38. JIRA:Enterprise Edition, Version: 3.13.2-#335

    Confluence: 2.9.2

    I am not able to see Component/s column via jiraissues macro (usage ...|columns=type;key;summary;component) and I am not able to see the navigation bar ... any idea what version of JIRA/Confluence this two functionalities were introduced?

    Thanks

    1. Hello, Theodor. Those features were introduced in Confluence 2.10. I would suggest you to upgrade your Confluence to the latest version available, since the plugin version that contains those features is not compatible with Confluence 2.9.x. Hope that helps!

  39. Hi,

    I keep getting the error "jiraissues: Unable to determine if sort should be enabled". The xml search string seem to be ok, and were using Confluence 3.0.0_01 and JIRA 3.13.4 .

    Any ideas on how to go about with this?

    Thanks

    1. I just got this same error, but on 2.10.3, it transpired an apache server was down which was previously handling old URL redirects (error message wasn't terribly informative in this regard (smile) ). Validate your filter url in a browser, perhaps you have a DNS or similar lookup problem.

      1. Hi Andy,

        Indeed, the error message isn't very helpful. Thanks for your quick reply - I tried to view the filter url locally from the server and indeed, it cannot resolve the host name. Thanks for the pointer :)

  40. Would be really great if there was a parameter to make the dynamic list minimized by default, and only when the user "restores" it then the data will be revealed.

    1. Hi, Evgeny. I have created an improvement request at CONFJIRA-164 to address your requirement. Feel free to add in your comments, watch it and vote for it. Hope that helps!

  41. Is this Macro compatible with Confluence 3.0? We can not get it to work again and Atlassian support has asked us to confirm this, please let me know.

    1. Hi Bill~

      The macro should work in Confluence 3.0, because the plugin that contains it is supported for that version. (And I can confirm that it works for me personally.) So if you are having problems perhaps there is a Confluence bug or a configuration issue occurring. I see you've created a support case, and that is great because support should be able to help track this down.

      ~Cheryl

  42. We've currently got JIRA and Confluence on the same server both listening on port 8080.

    As we're getting more and more people on board we'd like to tidy up the URLs.  So we plan on moving both Confluence and JIRA onto Port80 and we'll probably move to a more meaningful URL.

    We use the jiraissues extensively and so we'll have to edit a lot of pages to fix up the URLs.

    Between now and when we do the URL tidying is there a way to soft code the Jira URL in the Jira Issues macro?  A sort of extension to the short cut links?  What is best practice? (Other than getting it right to begin with).

    N.

    1. Hi Neil,

      I am not sure which is the best practice. However, you might want to try the Global Search and Replace Plugin to
      change all the URL which is presented in all the page.

      Hope that helps.
      Best rgds,
      Zed

  43. Anonymous

    I've a problem with custom filds

    jiraissues:url=http://jira.abacho.net.local/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10140&fixfor=-1&resolution=-1&due=-1&sorter/field=priority&sorter/order=DESC&tempMax=50\|columns=priority;status;assignee;iRAnk;summary;

    the custom fild "iRank" is not be show - only an empty row "iRank". I've conf 3.0 and jira 3.13 and of course i've tried the id of the custom fild and it isn't empty in jira

    1. Hi there,

      I am using this macro (love it!)  and am trying to get the full length of the description field from Jira to show, regardless of length.  Any suggestions?  It keeps truncating.

      Thank you,

      Holly

  44. Anonymous

    Also a reason for this error might be insufficient "Trusted Applications" access for Confluence in JIRA for example.

    We tried to add a single Issue through the jiraissues macro, which has a different url than the issue list ( /si/jira.issueviews:issue-xml instead of /sr/jira.issueviews:searchrequest )

    That URL was not allowed per default in the "URL Paths to Allow" option, and thus the macro was returning that error message.

  45. Is it possible to disable the Issue Type text instead of the icon? We've created many custom issue types and they are all using the generic icon. We could create custom icons, but it would be simpler to just display the issue type as text

    1. Hi Jeff,

      Is it possible to disable the Issue Type text instead of the icon? We've created many custom issue types and they are all using the generic icon. We could create custom icons, but it would be simpler to just display the issue type as text

      You might want to try change the configuration in the Configuring Jira Issues Icon mappings

      I have provided steps shown below. Hopefully, this will give you a better understanding on it.

      1. Go to Configuring Jira Issues Icon mappings option.
      2. You might need to remove the icon which is set to the particular entity
      3. Now enter Jira entity and leave the Icon filename option to be empty
      4. Save the Changes
      5. Now flush the Confluence cache via Confluence admin >> Cache Statistics >> flush all

      However, this only work well in fire fox 3.0.14,in IE7 it will show image break icon.
      Hope that helps,
      Best rgds,
      Zed

      1. Thanks, Zed. That works exactly the way I want it!

      2. Hey Zed,

        We're running Confluence 3.5.13 and I cannot find:

        1. The "Configuring Jira Issues Icon Mappings" page in the 3.5.x documentation. It seems to have ended with 3.4.
        2. Any way to edit the icon mapping settings in 3.5 via the admin console.

        Was support for editing the icon mapping settings removed in Confluence 3.5?

  46. Hi,

    Thak you for this great stuff.
    I'm having a problem here, we have some custom field using datepicker data type, it's showing fine on the page view.
    but, when we try to send the page by email, it will showing a complete formate datetime just like this : Wed, 21 Oct 2009 00:00:00 +0800 (SGT)
    also on the received email

    is there anyway we can fix it in our side? or is it a bug?

    the second problem,
    I was creating a filter and forgot to add the share, and then the macro won't showing the issues event after I add the share, and i have to create a new filter to have it showing correctly. in other case, the issue not showing all the issues ont the filter, which is also fixed by creating a new filter. is there any synchronization problem on this macro?

    Regards
    Fahmi

  47. Anonymous

    Hi,

    I get an RSS feed under the XML view, which is not accepted by Confluence ?!?

    Thomas

    1. Hi,
      I'm uncertain on which RSS feed are you referring at, but I've tested the XML, RSS (Issues), RSS (Comment) at http://jira.atlassian.com, and they worked fine for me.

      XML http://jira.atlassian.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=&tempMax=10

      RSS (Issues) http://jira.atlassian.com/sr/jira.issueviews:searchrequest-rss/temp/SearchRequest.xml?jqlQuery=&tempMax=10

      RSS (Comment) http://jira.atlassian.com/sr/jira.issueviews:searchrequest-comments-rss/temp/SearchRequest.xml?jqlQuery=&tempMax=10

      Could you try the URLs above and see if they work for you? If I've miss-understood your question, please try to explain more on how & where you get the RSS link.

      Hope it helps. Please give them a try.

      Cheers,

  48. This is not a big deal but doesn't hurt to ask. I haven't seen it documented anywhere (I'm hoping it's there, but just not documented): is there a way to tell jiraissues to only show an arbitrary list/set of issues? i.e. show me QA-453, SYS-4432 and SYS-4431 only? They way I do it now is I just make sure I can search that set of JIRA issues, and that use that "XML link".

    1. Hello Juanchico,

      As far as I'm aware, there are no other parameters of this macro (apart from the url one) that you can use to control the filtering of results retrieved from a JIRA site.

      Furthermore, you should probably only restrict your results using the search and querying tools in JIRA itself (i.e. the way you're currently doing so), since the XML link is generated from these JIRA searches and queries. Editing this XML link to filter your result could be quite tricky and not a recommended approach.

      If you would like to see filtering features introduced into the JIRA issues macro, please raise a New Feature request on our JIRA site.

      Another suggestion, you could also request that the administrator of your Confluence site configure shortcut links to your JIRA site. Hence, if they configured a shortcut link key of JIRA with an expanded value of http://<URL of your JIRA site>/secure/QuickSearch.jspa?searchString=, then you could use [QA-453@JIRA] to create a Confluence link which leads directly to that issue on your JIRA site.

      Hope this information helps and kind regards,
      Giles Gaskell.

  49. I would like to track the status of a single parent issue and all its children on a confluence page.  I've tried feeding the jiraissues macro  the XML path from the parent issue, but the macro returns "jiraissues: Unable to determine if sort should be enabled".  Does jiraissues support this use case?

    Thanks,

    Eric

    1. Hi Eric~

      I don't think that use case is supported. I think the XML URL must be a search result URL. One possible workaround would be to put a label on the issues you want to track together (e.g. the parent and children) and then do a search for items with that label.

      ~Cheryl

  50. Hi,

    Is there a way to set the Issue Macro to Shrink in height based on the issues that are displayed?
    If number of issues exceed the height then we seen it traversing the pages which is fine but if the number of issues are less I the macro should shrink so that it does not eat up the space. Also it looks ugly

    Any pointers?

    Thanks
    Dave

  51. I agree with Dave, the display of issues is a bit ugly.

    1. New Feature request has been opened, pls vote

      http://jira.atlassian.com/browse/CONF-18822

      -Dave

  52. Hi,

    I have the following query where I am trying to display custom field but they showup blank.

    Any advice? This is JIRA 4.1 and Confluence 3.1

    jiraissues:http://jira.xxx.com/sr/jira.issueviews:searchrequest-xml/tempSearchRequest.xml?jqlQuery=project+%3D+%22QA%22+AND+fixVersion+%3D+130+ORDER+BY+key+ASC&tempMax=25|columns=priority,key,summary,Status,assignee,customfield_10053,customfield_10052|cache=off|height=500

    Thanks
    Dave

    1. Hi Dave~

      To display a custom field, use its customfieldname, not its id.

      ~Cheryl

      1. Anonymous

        Any suggestions for getting content from a "*Free Text Field" *custom field to wrap when displayed? We are using Confluence 2.0.

        1. I think you would need to modify the plugin (at least its CSS) to customize the display of particular columns. Might be worth making a feature request though.

      2. ....this works ...Thanks

      3. Yes that works ....not sure what I hit earlier on when I had tried

        Thanks for the prompt response

  53. Ho can I incorporate "Issue Links" in this macro? "Issue Links" is available in JIRA Issue Navigator and shows all the issues that are linked to this issue. I would like to have the same capability in my JIRA Issue Macro as well

    Any pointers are appreciated

    Thanks

    Dave

    1. You can get a not-super-pretty list of issue links by adding "issuelinks" to your "columns" parameter value. I created an issue for improving the display. Feel free to submit other bugs or feature requests there if you have them.

      1. thanks for the super fast response, appreciate that. I have casted my vote. I see the same issue with SubTask as well, its plain text rather then a link

        -Dave

      2. Cheryl,

        Adding issuelinks shows only one part of the relationship, currently it shows all the issues that are blocked by this issue, I would like to display what all issues are blocking my issue

        Thanks

        Dave

        1. Anonymous

          +1.

          Can the issuelinks output be displayed by its types, i.e., "Blocks", "Blocked By", "Duplicates", and "Duplicated By"? Furthermore, can each type be separated by EOL (end of line)?

          Thanks.

      3. Hi,

        I found a workaround for the not-super-pretty style of issuelinks field. You can use table-plus macro enclosing the jiraissues macro to insert some style attributes to the columns of jiraissues table. You will need to use renderstyle static. Here is a working example:

        This solution may not work in every environment (dependent to JIRA version, Confluence Version and browser). I was using JIRA 4.1.1, Confluence 3.1.1 and Firefox 3.16.13. The used CSS style attribute "white-space:normal;" is in conflict to HTML "no-wrap=true" that is embedded in HTML code of jiraissue macro.

  54. Cheryl,

    How abt using Shortcut links in the Macro instead of the URL. I tried it and I get

    Error formatting macro: jiraissues: java.lang.NumberFormatException: For input string: "1000@jira]"

    I have added my JIRA URL as a shortcut with jira being the key

    jiraissues:url=[/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=project%3D+%22B+QA%22+and+fixVersion+%3D+1&tempMax=1000@jira]|columns=type,key,summary

    Thanks

    Dave

    1. Shortcut links are actually created with another plugin, which wouldn't modify parameters to macros in other plugins. Anyway, I would think the shortcut wouldn't be so useful because most jiraissues URLs would be copied directly from JIRA, but maybe I am wrong, so you can create a feature request for that.

  55. Anonymous

    Hi,

    Everything is coming over from Jira nicely, however, the Jira field "Documentation Link" (which presents itself as a hyperlink when in Jira), is being displayed as simple text.  Is there a way to have the Documentation Link content act as a hyperlink?

    Thanks,

    Andrew

    1. Hi Andrew,
      Unfortunately, jiraissue macro is not able to render hyperlink. Please feel free to create a feature request to enable hyperlink in jiraissues macro, share your comment over there, vote on it , and add yourself as a watcher for future update. Please also take note on how we implement feature request.

      Hope it helps. Please feel free to ask again if you need further assistance.

      Thanks & regards,
      Jack

  56. When I am using this to show sub-tasks of a specific parent, I can't seem to get them to show in the order in which they are set within the parent task.  I've got my filter as a "parent = [parentkey]" query, but the order that the parent is allowing me to set on the sub-tasks doesn't seem to be exposed as a field that I can sort on.  Does anyone know the field name?  Or is that a part of the link itself, and not the record?  If so, is there any way to do this?

    Thanks,

    Chris

    1. Hi Chris,
      May I know which field is not exposed as a "sort-able" field? When defining the JQL, you should be able to sort the field with "ORDER BY", eg:

      parent = [parentKey] ORDER BY [columnName] 
      

      If auto-complete is turned-on, you should be able to see the available column name .

      Save the filter with jql similar to example above > copy the XML link to be used in jiraissue macro > you should be able to sort the issue list properly now.

      Hope it helps. Please feel free to ask a again if you need further assistance.

      Cheers,
      Jack

      1. Hi Jack,

        When looking at the sub-tasks shown on an issue, there are little "up" and "down" arrows that allow me to change the ordering of the sub-tasks as shown within that list.  When doing the "parent = parentkey" query to retrieve the sub-tasks, the records that are returned are not in the order set in the list shown on the parent record.  I'm not seeing a field that would seem to store this value on the sub-task itself (which are the only fields that appear to be available for use within the ORDER BY clause).  I'm thinking that the index is stored on the link between the parent and the sub-task?  Or perhaps I'm just missing the field?

        Thanks,
        Chris

  57. Anonymous

    • Log in to your JIRA system.
    • Go to the 'Issues' screen and create a new filter. Do not modify an existing filter.
      (info) This is the 'Find Issues' screen in JIRA 3.13.x and earlier.
    • Set up your search parameters and use 'View' to check the issues returned.
    • Once the filter is finished, go to the Filter's 'View' tab/section in the top-left area of the JIRA interface.
    • Copy the XML link. To do this, follow the appropriate steps below:
    • If you are using JIRA 4.0.x or later:
      • Click the 'Views' menu and use this menu to copy the XML link to your clipboard. For example, right-click the 'XML' menu item and choose the right-click menu option for copying that link.

    Where in the administration tab do I setup the different methods under views. Mine is currently blank and I am on jira 4.01. is this a plufgin that needs enabled or a permission schema?

  58. I have went thru and follow the instructions, used the macro browser to create this syntax

     

    and this is what the page displays to me after the save.

    jiraissues: Unable to determine if sort should be enabled.

    columns=key, summary

    anonymous=true

    title=CM Issues}


    any ideas, I am not currently using trusted apps becuase I have the ssl in an alt keystore and have not found all the places/ files I need to edit to point at that keystore.  

    1. Anonymous

      I had the same issue until I correctly get the link to filter. Following instructions in "Displaying a List of JIRA Issues from any accessible JIRA site" section.

      Mike Kosovan

  59. Anonymous

    I've followed the directions as listed and when I preview the results I get the following error:

    Error formatting macro: jiraissues: org.springframework.dao.IncorrectResultSizeDataAccessException: Incorrect result size: expected 2, actual 4

    What do I need to check to resolve this?

  60. Anonymous

    When I use Priority in the column list, it just shows the icon and not the text (e.g. 3 - Important ) unlike the status which shows Icon and text.

    1. Anonymous

      BTW, is any body know how to display the text for priority??

      1. Unfortunately, this is currently being tracked as an improvement request in:

        Feel free to cast a vote, comment on it, and add yourself as a watcher for future updates.

        This is the closest which I can find, if you think this is not as accurate as what you are looking for, feel free to create another improvement request for this.

        1. Any news on this yet? When I display a customized JIRA column in Confluence and set it to static some of the fields will not display the JIRA information, priority being one of them.

          When I change the RenderedMode parameter back to Dynamic everything is displayed in Confluence. Will displaying the field as text perhaps solve this problem?

  61. I'd like to modify the output format from this macro.  Is the source available?

      1. Perfect, thanks!  In the mean time I actually turned to the XSLT macro and was able to pull the and format items that I wanted.  The only problem there is that I needed to pass in a username and password (as is documented in the old jiraissues macro).  It would be great if you guys could implement a more generic solution that allowed any macro to talk to confluence from within an authenticated channel, without the macro needing to be aware of the auth.

      2. Meant to say "talk to JIRA".  Thanks.

  62. Anonymous

    Hi,

    after a while I found how to add a custom field to be displayed with the jiraissues macro. But I had to change the name from "My Custom Field" to "MyCustomField" otherwise the field will not get displayed. Did I miss something or is ther no way of adding human readable custom field names?

    Regards,

    Christian

    1. sorry christian, last i heard there was not

  63. Hello, I can't get the 'Component/s' field to display using 'component' value. I read before that it requires confluence 2.10 and above which we have. Any thoughts? Here's the XML:

    http://xxxx.xxx.xxx.xxx:xxxx/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?query=%22Do+not+allow+an+application+to+be+deleted%22&summary=true&description=true&body=true&environment=true&pid=10100&tempMax=1000\|columns=mrd id,key,description,component,status,priority|height=75|title= |renderMode=static

    Confluence: 3.0.0_01

    Jira: 3.13.1

    Cheers!

    -Claudia

    1. Hi Claudia~

      The reason it isn't working isn't obvious to me from looking at this. If it still isn't working you may want to create a support request.

      ~Cheryl

    2. components (plural) ?
      -jd.

    3. Anonymous

      Hi Claudia, did you manage to solve this? I have the same problem when selecting the renderMode=static i.e. the fields in my static column does not display in Confluence. Only when I leave the columns field empty will my information display correctly.

  64. Hi, is it possible to preset individual column widths? 

    I have added a custom field which can have quite a long string, but the default width (Summary is always the largest - and that is not what I always require..) means that the user has to manually resize every time the screen is loaded.  I haven't been able to see any discussion of this feature/requirement...

    Cheers

    James

    1. I'm having the same issue. I have a custom field to document an external release note and I have to use that field because of the character limit on the Summary field. Hopefully there's a workaround. Also, is there a way to concatenate fields? For example, put the contents of the Summary field and my custom external release note field into a single field when displayed in Confluence?

      Thanks,

      Dan

      1. I'm also having this issue. Would like to be able to set width of the column for a custom field.

        This this is a related - an outstanding issue for automatic column sizing here ->  https://studio.plugins.atlassian.com/browse/CONFJIRA-93

      2. I'm also having this issue. Would like to be able to set width of the column for a custom field.

        This this is a related - an outstanding issue for automatic column sizing here ->  https://studio.plugins.atlassian.com/browse/CONFJIRA-93

  65. Anonymous

    I'm running into this same issue. Is there any way to set column widths - specially for the summary field?

  66. Anonymous

    We are encountering a similar error reported by several: jiraissues: Unable to determine if sort should be enabled

    It came about when we upgraded from 2.10 to 3.2.1_01; our jira version is: 4.1.1#522).

    I followed the documentation instructions just to reinsert/copy the xml link.

    I tested the link by putting it into a separate browser window to make sure that it rendered correctly

    They are not setup with SSL, so a trusted connection between confluence and jira should not be necessary

    I tried with a specific user's set of credentials (as was necessary with our 2.10 version) and it still should have worked, even though it's not recommended -- but, it didn't.  I tried with anonymous set to TRUE as well.

    We uninstalled and reinstalled the plugin

    We reviewed the error logs to ensure we weren't getting an issue with host name validation -- couldn't locate any such error message.

    Does anyone have any other suggestions for how to troubleshoot this issue

    1. Hi~

      That error message is usually hiding some deeper problem (such as proxy issues). We have an issue for improving the message (CONFJIRA-154), and some progress has been made on that. So your first step should be getting the latest compatible version of the Jira Macros plugin to see if you get a more informative error message with the new version. If not, you may want to create a support request.

      ~Cheryl

  67. Hi,

    I am using this macro, in the following way, to show our custom field Release Notes Comments for different versions:

    {jiraissues:url=http://jira.mycompany.com/sr/jira.issueviews:searchrequest-rss/temp/SearchRequest.xml?jqlQuery=project+%3D+RPT+AND+fixVersion+%3D+14365+AND+"Release+Note+Comments"++IS+NOT+EMPTY+ORDER+BY+key+DESC&tempMax=1000\|columns=key,summary,fixVersion,Release Note Comments|cache=off|title=Release notes|renderMode=static|width=800}
    

    On this custom field Release Notes Comments, defined as type Free Text Field (unlimited text), we introduce all information we consider should be known by other teams about a particular issue on a language that's easy to understand for them. Then we automatically collect all those release notes using the jiraissues macro and that constitutes our release notes for a particular version.

    I am nevertheless experiencing two issues with it:

    First, it is not wrapping the lines of text, so that I actually have to insert breaklines at strategic points within the Jira's Release Note Comments field so that the lists of issues do not expand horizontally too much. The lines are being perfectly wrapped in Jira, where everything is displayed correctly, but they are not when the text of the Release Note Comments field is displayed by the jiraissues macro. I tried setting the width in different ways and nothing seems to solve that problem.

    Second, I cannot get the macro to show the 'fixfor' versions when there are more than one. I tried with "fixVersion", "fixVersions" and "fixfor", but I cannot get it to work.

    FYI, we are using Confluence 3.2 and Jira v4.1#519

    Could you help me with this?

    1. Hi Gerardo~

      Unfortunately, I don't think you can fix your first issue without modifying the Jira Macros plugin source. I believe the only field set up to wrap is the description field. (Perhaps a future feature could make wrapping of custom fields more customizable.)

      For your second issue, using "fixVersion" should work, though there have been some related bugs, such as CONFJIRA-184. You might try updating your Jira Macros Plugin to the latest version compatible with Confluence 3.2. If that doesn't work, you should open a support request.

      ~Cheryl

  68. Hi,

    I am using this macro to show jira issues in a confluence page. It works ok, but I received some complains from our users.

    the point is that when they click on the issue, jira is open in the same page. Is there a way or parameter that I can use to get JIRA open in a new Window?

    1. Hi Fabian,

      As far as I know, the feature requested is not available yet. However, feel free to launch a an improvement request in JIRA:

      Cheers,
      Zed

  69. Anonymous

    Hi there,

    i have a question about how to write names with sur- and lastname into my configure? For example: MYNAME: Max Mustermann MYPASSWORD: Test.

    jiraissues:url=CONTENT&os_username=MYNAME&os_password=MYPASSWORD

    If this question already exists - i'm sry, i read the most comments here but i didn't see a question about how to... and in the documentation i can't find an explanation.

    Best regards,
    Jan

    1. Hi Jan. You may be able to use the URL encoded space, which is "%20", in your URL. So it would look something like jiraissues:url=CONTENT&os_username=FIRSTNAME%20LASTNAME&os_password=MYPASSWORD

  70. Hi, someone faced this problem or know a solution:

    I have a page with the jiraissue macro included, it works well when I visit the page as authenticated user (same account in Confluence 3.1 and Jira 4.1.1). When I visit the page without login (anonymous) the I will get an error message: Error formatting macro: jiraissues: java.lang.RuntimeException: Bad Request

    Any Idea how to resolve this?

    This error message can be accepted, but it create tremendous exception entries in the log file. The log file is blown up when someone create an RSS feed setup which strive this page. The RSS is anonymous and triggers jira every minute....
    Thanks for help.

  71. I have the same problem @Wallabee described. Searched the internet for answers but none were to be found. I have my confluence server as a Truested Applications in JIRA, use the same usernames in both installations. I have verified the jiraissues macro is setup correctly (by using it to read Atlassian's public JIRA site). My macro is setup us:


    The error I get is:

    I have Confluence 3.4.7 and JIRA v4.2.3-b590#590.

  72. I have a question, can this Jira macro and Confluence not suck? wiki markup = fail.

    Just to get these columns to be fully expanded seems to be impossible. First of all why can't the descriptions column expand or any column expand to fit the actual width of the macro? Second, why is it set to be minimized every time the page or macro is loaded (see pic 2)? Having to constantly expand the height of this thing is a real annoyance. Yes I know I can set a height, setting a fixed height or width is stupid because with some instances there maybe 20 fields and other times 1 or 2. Turning renderMode to static solved a couple of those issues but now I'm getting requests to make it sortable again. If it's dynamic, make it DYNAMIC. Fit widths, columns and expand the view.

    Make the columns fit the width!

    I'm frustrated if you can't tell. Please do something to fix this.

    1. Hallo Noah
      I'm sorry to hear you're frustrated. Unfortunately, adding a comment to the documentation is unlikely to get the problem fixed. To communicate with our development team and product managers, please would you add an issue to our issue tracker at http://jira.atlassian.com.
      Cheers, Sarah

      1. Tried, no one can seem to help or explain why the jira issues macro behaves like that. Be dynamic, fill to the content, expand, etc.

  73. Anonymous

    If you receive java.lang.RuntimeException: Not Found error this is may be beacause you are using port redirection with firewall and both jira and confluence are on the same machine.

    Port redirection may not work correct when trying to access url from localhost.

    Workaround is to add original port number in urls.

    For example, if your jira instance is accessible for users via url: http://jira.myhost.com, and this location is transparently mapped via firewall to http://jira.myhost.com:8080 you should use second url form in jiraissues macro for it to work correctly.

    Or you may fix your firewall configuration :)

  74. Sorry, not sure why the syntax disappeared from my comment. But here it is again:

    1. Vidhi, it is probably best to raise a support case at https://support.atlassian.com, so we can help diagnose your problem.

  75. Anonymous

    How do i adjust the width of the columns?

    1. I found a way by inject some format attributes by using table-plus macro in addition.
      Please look into example that is inserted at this comment.

      1. Thanks Stefan that worked.

  76. Anonymous

    Hi everyone,

    Quick question, but first here's some background: One of Confluence 3.5's largest improvements is its ability to integrate with Jira. However, if you have a project key with alphanumeric characters, "Insert" does not work with Recently Viewed Jira issues. After you save or preview the insert, a macro error message pops up. I've run multiple tests to make sure that the alphanumeric characters are the issue.  I have found that if there is a number ANYWHERE in a Jira project key, Confluence will produce in error message when trying to display this project's issues. Has anyone had this problem? 

    Thanks,

    Eddie

    1. Sounds like that case didn't get tested. I'd file a bug on it at http://jira.atlassian.com/browse/CONF

      ~Matt

      1. Anonymous

        Thanks for the reply Matt, I've created one here just in case you are interested in the outcome: http://jira.atlassian.com/browse/CONF-22183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

        ~Eddie

  77. Anonymous

    With proper formatting this time...

    Is there a way to use the data from this macro within a chart? 

    For example, say that this jiraissues macro:

    {jira:project = "Jira50" and IssueType = "Enhancement" and "Story Points" > 0|columns=FixVersion;Story Points}
    

    returns 3 rows

    Fix Version

    Story Points

    5.2

    3

    5.2

    3

    5.3

    8


    Ideally, the data returned would be of the following format, so that I could wrap the chart macro around it

    || Fix Version || Story Points ||
    | 5.2  | 3 |
    | 5.3  | 3 |
    | 5.3 | 8 |

  78. I am using the Jira issues macro and love it, but was wondering if there is a way to add a row number to the table (other than explicitly defining a # in the Jira issues).  We use GHRank ordering, but the numbers don't start with 1 and aren't in order - I need my issues view to be numbered 1-n

    Thank you

    1. Hi Sarah,

      possibly you can use table-plus macro in addition with jiraissues. Table plus macros provides an "autoNumber" attribute, that could work for you.
      I used combination of these 2 macros for another case. Following you will find the details. http://confluence.atlassian.com/display/DOC/JIRA+Issues+Macro?focusedCommentId=236586816#comment-236586816

  79. Windows Server 2008 R2, Conf 3.5.4, Jira 4.3.4 (two instances of Tomcat on same server), Application links appear correctly configured for trusted apps. The issues list displays correctly in flexigrid in Confluence.
    However, the title row for the macro flexigrid displays a url instead of the title.

     
    the code that actually appears in the title row is this:

    In other words, everything seems to be working properly except the title row doesnt seem to be properly parsing the title.
    The correct title should be "JIRA issues", as shown appended to the URL.
    I vaguely recall seeing this problem before, but cant find it in my records ....any tips would be really appreciated.

  80. Hello,

    According to jiraportlet macro, in the help there is written

    {jiraportlet:url=http://jira.portlet.url}
    

    How to find in Jira v.4.x the portlet.url, please ?

    With jiraissues macro, I get this error on the page
    jiraissues: Unable to determine if sort should be enabled.
    What is the problem ?

    Here below the wiki code

    {jiraissues:url=https://jira.vsct.fr/jira/sr/jira.issueviews:searchrequest-xml/temp
    /SearchRequest.xml?jqlQuery=project+%3D+PILCSI+AND+issuetype+%3D+%22Action+%C3%A0+piloter%22+AND+status+in+
    %28%22En+attente+d%27info%22%2C+%22En+cours%22%2C+%22To+do+%28%C3%A0+faire%29%22%29+ORDER+BY+due+ASC&tempMax=1000}
    

    (I have put CR at end of lines here to enable you to see all)

    Thank you for your help

  81. Anonymous

    Few questions:

    1. Is there any way to specify default sorting (tried order by...didn't work)
    2. Is there a way to group jiras?  I want to group by fix version
    3. Is there a way to only show the main jira and not the sub tasks?
    4. Is there a way to filter the issues (if I can't do group by, want to have separate tables for each fix version)
  82. Anonymous

    Is there any way this macro can retrieve the SVN commits associated to the JIRA tickets? I would appreciate if you can give me an example to do the same. Thanks!

  83. I am attempting to display a list of the "New Features" in our next release in confluence.  We are creating a wiki page within confluence for each new feature to detail requirements, and attach assets.  I added a custom field in JIRA that I put in the link to the confluence page.  JIRA is picking up the fact that it is a link, so I can click on it, and get to the page, but when I display the list of issues in confluence using the macro, it shows the <a href="link"> tag, instead of providing a link.  

    Is there any way to have the link I enter in JIRA show up as a link within confluence?

    1. Above was what happened as free text.  I also tried it as a link, but in that case, it displays the url, but it is still not a clickable link

  84. Anonymous

    I am in the need to just pull the contents of a particular field without the table that is written by the JIRA issue type

    {jira:http://example.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=key+%3D+CONF-1181\|columns=description|title=}

    returns me the description with a box, but what I just need is that in ASCII so I can put it in a nice report. and format in a nice way via confluence.

    1. Anonymous

      Same here! Is this possible?

  85. Anonymous

    I used the jiraissues macro to create an issues table on my project wiki page.  The table is created but only the first field is populated the remaining fields are empty.  If I click on the first field it takes me to the issue.  We have Jira Studio.

    {jiraissues:url=https://audigygroup.jira.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=project+%3D+PULSE+AND+Status+%21%|columns=type; key; summary; priority}

     

     

     

    1. Hi, you may separate the columns by comma: e.g. columns=type,key,summary,priority
      This is the normal case it works, may the parameter description need to be fixed.

      1. Anonymous

        Sorry, I forgot to change the semi-colons back to commas before I cut and pasted.  Changing to semi-colons was one of my troubleshooting attempts.  Here is the modified script.

        {jiraissues:url=https://audigygroup.jira.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=project+%3D+PULSE+AND+Status+%21%|columns=type, key, summary, priority}

        1. Anonymous

          Ok, I figured it out (with a little help from a friend).  If you have a space next to the comma in the columns section it doesn't populate.  I removed the spaces and now it works.

          Thanks.

          1. Thanks, you saved my day.

            it' s a really annyoing behaviour / bug.

  86. Anonymous

    Our users would like to emphasize due dates using colours and different fonts. Similar to what this attempt achieves in JIRA: https://studio.plugins.atlassian.com/wiki/display/JODCF/Home

     

    Any ideas on how to do that?

    Thanks in advance!

  87. how am I supposed to pass parameter on JIRA 4.0 ? As I have no more access to the macro code ({jiraissues:...}), I would have expected the macro wizard to allow me to input those parameters... is this something that has been forgotten or am I missing something ?

     

    thank's.

     

    Nicolas.

     

    ------> my mistake, I was using the jiraissue and not the jiraissues...

    1. Anonymous

      I've got answer from support that so far you cannot input parameters for jiraissue (for jiraissues you can of course (smile) )

  88. Anonymous

    How can I use metadata inside the jiraissues link. For example:

    Code

    thanks for help.

    1. I'm having a similar problem where I want to make the query dnamic.

      but when the page renders, the macro just displays it as a URL link rather than as the JIRA issues widget.

  89. Hi all,

     

    i need help!

    I have the problem that one user get no issues displayed instead he gets "no item" message.

    He is admin in confluence and JIRA and belong as developer to the JIRA project.

    The JIRA issue filter is shared and he can view the result in jira.

    All other users do not have the problem.

    Any idea what the problem is?

    Thank you in advance!

    Alex

  90. Anonymous

    Greetings.

    I am a fairly new Confluence user, however I have been using the Jiraissues macro for some time. With the Confluence upgrade, a text field I display in my Jira query has embedded html <br> tags which causes the text to not wrap and be displayed as one huge long line. The custom field I am using is a simple text box. Are there any ideas on where the <br> tags are coming from? BTW, I did view the XML which is copied into my Jiraissues macro and the section of the XML I am concerned with looks like this: (? used to replace original text).

    <customfields>
     
     <customfield id="customfield_10455"key="com.atlassian.jira.plugin.system.customfieldtypes:textarea">
     
    <customfieldname>Acceptance Criteria</customfieldname>
     
     <customfieldvalues>
     
     <customfieldvalue>
    Item-715.01: ????????????????????????????. <br/> Item-715.02: ??????????????????????????????????? <br/> Item-715.03: ????????????????????????? <br/> Item-715.08: ????????????????????????????????????????  <br/> <br/> <br/>
    </customfieldvalue>
     
    </customfieldvalues>
     
    </customfield>

    Should look like:
    Item-715.01: ????????????????????????????
    Item-715.02: ???????????????????????????????????
    Item-715.03: ?????????????????????????
    Item-715.08: ????????????????????????????????????????

    One other question. Sorry. Is there a way to control the column widths in the Jiraisssues query (static mode)?
    Thank you very much for your time.
    Craig
    1. Hi Craig,

      look into Re: JIRA Issues Macro it will help you to set advanced column attributes.

  91. How can we construct a parameter with JQL query containing "+" symbol?

    For example, we need to get all JIRA issues with summary containing both words from the phrase "example phrase".

    The corresponding JQL quiry should be like this

    since space symbol acts like OR operator. That means

    returns all issues containing "example" or "phrase".

    When we are using the code like this:

    (with %22example+phrase%22 inside) we are receiving ALL ISSUES issues containing "example" OR "phrase".

    We have checked the request header and it contains

    So %22example+phrase%22 was substituted with %2522example%2520phrase%2522 that means "+" was substituted with " " space symbol.

    When we tried %22example%2Bphrase%22 in "jqlQuery=..." we have received the same incorrect list of all issues since  it was substituted with %2522example%2Bphrase%2522 

     We checked that the correct value for the GET request would be %2522example%252Bphrase%2522

    but we couldn't obtain this. Trying to put %22example%252Bphrase%22  "jqlQuery=..." we have received nothing since it was substituted with 2522example%25252Bphrase%2522  


     

    1. When I enter it in JIRA and get the XML link, it converts the + to a %2B, have you tried that?

      1. We have tried. Received "The JIRA server was not able to process the search. This may indicate a problem with the syntax of this macro...." 

        Your suggested

        was converted to

        Symbol "&" from your suggestion is converted to "%26" - its URL encoding. JIRA didn't like it.

         

    2. Indeed, it's very strange. Whether it is not possible to receive JIRA issues with summary or any other field containing more than 1 word?
      It is pretty simple to replicate this issue. The template is the following:

      Isn't it possible to get issues containing both "example" and "phrase"?

  92. We use the jira-issues macro inside Confluence 4.1.5 and want to display a custom field named 'scope' (data type 'textfield'). The data is being retrieved from JIRA, but unfortunately the custom field's content is wrapped in paragraphs (<p>) and jira-issues writes the content as-is.

    This is what we get in the XML-response. Note the wrapped customfieldvalue (<p>Access Management</p>).

    <customfield id="customfield_10002" key="com.atlassian.jira.plugin.system.customfieldtypes:textfield">
    <customfieldname>Scope</customfieldname>
    <customfieldvalues>
    <customfieldvalue><p>Access Management</p></customfieldvalue>
    </customfieldvalues>
    </customfield>

    This is what jira-issues renders:

    scope
    <p>Access Management</p>

    Is there any way to unwrap the custom field's content and get rid of the <p>s ?

    1. Anonymous

      Rendering HTML from JIRA

      Formatted fields from JIRA can be displayed in Confluence if you set up a Confluence-to-JIRA Trust as described above. Otherwise, such formatted fields will be escaped within the JIRA issues macro output. This is to prevent the possibility of malicious HTML being served by an untrusted JIRA server. The most likely field where you will notice this is in the description field.

      So, for example, without the trust relationship, a description column that rendered in JIRA like this -

      Description

      This is

      • the description
      • of my issue

      - would actually appear in the JIRA issues macro like this -

      Description

      <p>This is<ul><li>the description</li><li>of my issue</li></ul></p>

      Configuring Confluence-to-JIRA Trust as described above will enable the field to be rendered as expected.

       

  93. The macro works for us (we had to establish trusted applications between Jira and Confluence with a certificate), but only the "key" column is populated. I want to display status, summary, component, but that does not seem to work.  Ideas?

    1. you have to set status,summary,component without spaces

      1. That was too easy and too obvious, thanks!

  94. Hi everyone,

    I have successfully configured this plugin, but I would now like to disable the links from the JIRA issues displayed.

    My company does not want the clients to be able to jump from the Confluence pages into our JIRA. They should simply be able to see the summary of their Jira issues along with their current status, and that's all.

    Is there any way at all to do this? In principle, as far as I can see, this is not functionality built in to the plugin. But could there be another way of disabling the links, via some other confluence configuration ability?

    Thanks a lot for any help - yes, I am close to feeling desperate about this... (sad)

    Eduardo

  95. Anonymous

    Is it possible to show additional columns of the subtasks of an issue as status, summary? In the JIRA issue navigator there is only the subtask column shown with the key of the subtask. If I use the VIEWS Menu on the issue navigator in JIRA I can see additional subtask columns.Is there a way to show these columns by using the JIRA Issues Macro in Confluence? Thanks in advance for answers.  

     

     

  96. Hi,

    I have created a table for my JIRA tickets on my confluence page with customised columns. 

    if I add the columns "Assignee, Reporter" the syntax for the result is "firstname lastname" , when I add the column participant it is the username (in our case the email address). Even if on the JIRA ticket itself the Participants are shown as "firstname lastname".

    Any idea how I can get the Participants displayed in the same way ?

    And another question - How I get two participants layouted with a line break, that they are not listed in one line ?

    Thanks

    Sabrina

     

    1. The Participants custom field from JIRA Toolkit renders its value in XML as just the userid with getName, but in the view issue template it uses displayName. I suggest filing an improvement request with the JIRA Toolkit project at https://studio.plugins.atlassian.com/browse/JTOOL

      1. You could also tweak the source of the plugin, though that's more work to maintain going forward.

    2. It renders all name fields that way except the standard ones. So, any custom fields setup that are associated with users will display.  We were also told to input an improvement request.

  97. The example in this documentation for columns does not work in my version of the plugin.  The solution is to use semicolons WITHOUT SPACES between the column names.

    The example above looks like this: "key, summary, type, created, fixversion, updated, due, assignee, reporter, priority, status and resolution"

    What actually works is this: "key,summary,type,created,fixversion,updated,due,assignee,reporter,priority,status"

    Also, the documentation says use Semi Colons, but the example has commas.  Either seems to work.

  98. When compiling my release notes in Confluence I need to use the following fields from JIRA: Key, Component/s, (a custom field called) Release note info and Priority. I use the JIRA issues macro to import these items but when I set the Render Mode to static the Component/s and Priority fields are no longer displayed in my list. When I set the render mode back to dynamic these values are displayed again. I need to use the static mode for auditing  purposes however. Does anyone have a workaround for this please? At the moment I export the JIRA list to Excel and then copy and paste in Confluence which is not a very productive solution.

  99. Hi,

    We seem to be having an issue that the JIRA Issues macro does not start automatically if Confluence is restarted. It has to be enabled manually by an administrator each time it is restarted.

    Please advise whether there is any way to have the macro automatically start each time confluence restarts. We are currently using JIRA v5.1.8#787 and Confluence v4.3.2

    Regards,

    Michael

  100. What is the refresh rate of the cache=on parameter? Is there any at all? Or does it only "refresh" on new session / re-login / restarting browser / once a day / ... ?

    I set count=true (and btw anonymous=true), so I don't have any refresh buttons to do it manually.
    Is it possible to set any refresh rate via parameter?

    (Btw we are currently using Confluence 3.3.3 against JIRA 5.0.2.)

  101. Anonymous

    My old JIRA Issues Macro don't work on the pages after our company upgraded to confluence 5.1. Any ideas how to fix it? And if I try to setup a new JIRA Macros, it doesn't show me the list of issues from which I see while obtaining the URL of the XML view of a search result. How can I fix it?

  102. Anonymous

    Hi there,

    I have one question. Is there any possibility to display any values from issue links in Jira Issue Macro? I mean I have a list of projects I want to display in Confluence page but I need to display wiki links from issue links in this list as well. Any suggests? It would be very helpfull for me.

    Thank you very much for your time.

    Paul

  103. Anonymous

    How to access the "Displaying a List of JIRA Issues from any Accessible JIRA Site" from groovy script.

    I need to access the Issue filter xml url content from the groovy script.

  104. Anonymous

    I've tried several ways to limit the columns shown.

    1. In the macro columns field -->  key; summary; 

    When I try this. Only the first column "Key" is populated.

    2. I've also tried adding this to the XML URL itself per the docs.... 

    https://jira.ourcompany.com/sr/jira.issueviews:searchrequest-xml/14777/SearchRequest-14777.xml?tempMax=1000&field=key&field=summary 

    Same issue... only the first field... whatever that happens to be... populates. All the headers show up but there is no data in any but the FIRST column.

    Help?

  105. Anonymous

    For some reason, the JIRA Issues Macro seems to display differently now than when I used it a week ago.   My users love the old layout of the table generated by the JIRA issues macro, which looked something like this:

    The above format was great because you could specify the size of the JIRA Issues Macros Table, move columns around, etc.  The new version of the macro doesn't seem to allow any of this and is just a static table - which is very frustrating.

    Do you know how I can get the JIRA Issues Macro to display my JIRA issues like in the table (screenshot) above?

    Thank you!

    1. Is it possible that for the macro 'style' parameter you are specifying 'static' instead of 'dynamic'. Here on CAC dynamic will render like this -

      Loading
      T Key Summary Assignee Reporter P Status Resolution Created Updated Due
      Sub-task TST-53530 test heaven RK Integrations Minor Resolved Done Apr 08, 2014 Apr 17, 2014 Apr 16, 2014
      Bug TST-53483 test4 Unassigned adi adi Minor Resolved Fixed Apr 05, 2014 Apr 05, 2014 Apr 06, 2014
      Improvement TST-53446 test improvement issue Unassigned Mohammad Miyan Trivial Resolved Fixed Apr 03, 2014 Apr 03, 2014 Apr 05, 2014
      Improvement TST-53445 test improvement issue Unassigned Mohammad Miyan Trivial Resolved Fixed Apr 03, 2014 Apr 03, 2014 Apr 05, 2014
      Support Request TST-53444 Install confluence from archive failed at mysql direct JDBC connection Unassigned yang sun Blocker Resolved Fixed Apr 03, 2014 Apr 03, 2014 Apr 04, 2014
      Bug TST-53342 Тест Unassigned Den Rusin Minor Resolved Fixed Mar 20, 2014 Mar 20, 2014
      Bug TST-53313 Hello World Unassigned RK Integrations Minor Resolved Fixed Mar 13, 2014 Mar 19, 2014
      Bug TST-53282 hjhj Dummy User kieu duyen Minor Resolved Fixed Mar 11, 2014 Mar 13, 2014
      Support Request TST-53281 Test Unassigned RK Integrations Minor Resolved Fixed Mar 11, 2014 Mar 12, 2014
      Sub-task TST-53279 Story 1 Unassigned Corina Tsai Minor Resolved Fixed Mar 10, 2014 Mar 17, 2014
      Showing 20 out of 1999 issues Refresh

      - which I believe is what you are looking for.

    2. Hi, 

      Indeed we changed the default display mode to static. Even though the UI does't provide the option to switch to dynamic mode you can still do it via insert wiki markup dialog. I.e. Insert  -> Wiki Markup  and then you can use all the parameters that are not available through the UI. To have dynamic mode you will need to have renderMode=dynamic parameter:

      Here is the list of parameters that are available for the macro.

      Let me quickly explain why we have chosen this approach and ask for your feedback. 

      • We had 2 different macros for integration with JIRA and for doing very similar things - inserting one issue and inserting multiple issues. 
      • We have unified the experience and tried to simplify the available options. 
      • With the recent changes to Confluence's design the dynamic mode looked out of place and we wanted to de-emphasise it.
      • For most of the use-cases that we encountered the options that we are providing via UI are enough : people usually want to see the list of issues and adjust what columns they see - the list is usually short enough and if it is long people prefer to view it in JIRA. 

      Obviously some of the options are not available from UI any more and it is affecting you. Can you please give us a bit more details how you guys usually use the macro so that we can improve it.

      1. Hi Anatoli,

        We used the JIRA Issues Macro for all our release documentation. I used the following columns when drafting my release notes for example: Key, Components, (a custom added column called) Release Notes Info, Priority and Status.

        At first we thought that Rendermode=static will display the JIRA info in a "read-only" manner, i.e. will not be updated dynamically as the content in JIRA changes.

        After drafting my release notes in Confluence someone might go and change the status of an issue from resolved to close in JIRA which will make it disappear from the “bugs resolved” list in the release notes. I know that is part of the JIRA/Confluence integration and what makes it great, but we would absolutely love a way to capture a list of JIRA issues in a document and have it remain static, say for instance a snapshot of the known issues for a specific release. What happens now is that the list of known issues changes as they are resolved in JIRA and as a result our documents are not adequate for auditing purposes as we need a document that remains unchanged.

        We have tried exporting the documents to PDF and saved this as a link in Confluence, but this defeats the purpose of having “online documentation”. Lately we have been exporting the issues in JIRA to Excel and copy and paste the content into Confluence not using the macro at all, which is a shame as it is an amazing tool and one of the main reasons we bought the system. A solution or option to display a snapshot of unchanged issues would be absolutely awesome!

        1. Hi Marisa, 

          Great! We are currently working to cover the usecase that you describe. Something that will help you to capture a list of issues for a release or a sprint in a state those issues were at the time of creating the page. The workflow we have in mind is this:

          • You choose to create a JIRA changelog (we call such a static report a changelog). It is done via Create  JIRA changelog report .
          • You can specify a project and a version to generate the report for OR alternatively you can specify a JQL query that would return the list of issues you want to embed in a page
          • Confluence will automatically retrieve the list of issues from JIRA and will embed them into the page. They will be embedded as a text(and links) and will be just a part of the page content. You can delete some of them when editing a page or edit text in any other way.
          • We group the list of issues by issue types.

          Stay tuned (smile) .

          1. Hi Anatoli,

            as we use the macro for kind of a similar use case Marisa does - cross-project release notes covering fields: project, priority, (issue) type, key, fixversion, (a custom date field called) released on live, summary - I am curious if your sentence

            "You can specify a project and a version to generate the report for OR alternatively you can specify a JQL query that would return the list of issues you want to embed in a page"

            does really mean, that we can show/track issues cross-project wide? As there is still no real cross-project fixversion, we rely in a high degree upon such a solution.

            Cheers
            Kai

            1. Hi Kai,

              You will be able to specify JQL query. Eg: 

              (Project=PRJ and fixversion="2.3") or (Project=ABC and fixversion="4.3")

              will return issues for two projects. Is it what you are after?

              1. Hi Anatoli,

                thanks for the instant feedback. The JQL specified could be an example, another one could be:

                 

                Project in(PRJ1, PRJ2, PRJ3) and "Released on Live" >= startOfWeek() and "Released on Live" < endOfWeek()

                so actually no direct relationship to any fixversion.

          2. Specifying a list of issues using a JQL query that will be displayed as text that can be edited sounds like exactly what we've been waiting for. Thanks Anatoli, best news ever!

            Do you perhaps have an idea or indication of when this will be released?

            1. Do you perhaps have an idea or indication of when this will be released?

              Cannot give you a date but it is weeks away.

          3. Hi Anatoli,

            In our team meetings we discuss each new issue for the week in order to add some internal metrics.  We wish to include in the meeting minutes a table of these JIRA issues as they stood at the time of the meeting (a snapshot) but still be able to have the ability to follow the JIRA links within the Meeting Minutes.  We have a similar problem with Action Item Lists as well in the fact that they are live and hence will change over time when we wish them to remain static for the purposes of the minutes.

            Is there a time frame for the release of the above or a method you can suggest for us to be able to achieve this?

             

             

            1. Hi Lolita,

              you are probably after JIRA Report Blueprint . It has already been released and available with Confluence 5.4. Or you can download and install Software Blueprints plugin if you are on v 5.3.

      2. It is concerning when Atlassian makes changes and then asks for feedback afterwards.  Removing the dynamic option is of great concern because we use the macro in hundreds of places throughout our instance as it allows users to drill through to the issue they want. Static mode doesn't allow drill through. 

        Even in your own release notes and much of your own documentation, you display the issues in a dynamic mode and it's helpful to drill through to see the details as you often don't want to display all the fields on the page.  We use the expand macro to put the issues macro in so that users quickly get to defined filter lists and each list, usually by space, has a customized list of fields that display because each space tracks different issue types.  For example, in HR, we list the employees with phone, office number, title, manager, etc as Employee is in an issue type; in sales, we track MRR, products, sales engineer as issue type is a lead, and so on.

        I'm not certain what perceived value, outside of minimizing properties to support that were supported, of taking this option away.

        What I hear you saying is that I will have to locate the hundreds of places where we use this macro and add the wiki markup to each to get them to render dynamically - true?  If true, and you have basically taken this away as it is no longer the default (btw...dynamic was the default...so, to revert to only static by default seems contrary to what you thought before), are you providing users ways to easily migrate all of their macro references to keep them the same?

         

        captcha 1, 2, 3. 4.<sigh>

        1. Hi Karie,

          Thanks for voicing your concerns. I am trying to understand what features you are lacking in the static mode. You mentioned that you customise the list of fields that get displayed - this feature is available in the new UI, you can configure what fields to show. Also you can drill down into any of the issues and see them in full in JIRA.

          Things that are only available in dynamic mode are pagination and ability to sort the columns. The rational for not having those features in the static mode is that they are useful only when the list of issues is long. And if the list is long it is much easier to view it in JIRA itself by following the "123 more issues" link at the bottom of the macro.

          1. Anonymous

            Hi Anatoli,

            Just wanted to follow-up on your question on why we prefer dynamic mode.  That mode offers the ability to support pagination, allows users to move columns, etc. - which are just nice features to have from an end user perspective. 

            The specific use case is that we display Greenhopper tickets within tables in Confluence generated by JIRA Issue Macro tables.  This is *huge* for our less-sophisticated users who have trouble wading through the greenhopper sprints, swimlanes, etc - all of which is just way too complex for them.  Presenting these Greenhopper Project-Epic tickets in tables in Confluence generated by the macro makes it super simple and to-the-point for these users.  Bottom line: It's awesome.  They love it.  Having the dynamic tables just makes this more flexible.

            My suggestion is that you re-release the Macro with the radio-button option to make it static or dynamic, and let customers decide what works best for them.  The old Macro parameter form was really easy-to-use and very clear on how to fill it out.  The new form (which just generates a static table) only has a few parameters that you can change - something which put me into a panic b/c I thought I had lost all that dynamic table functionality (btw, that's a thinly veiled super-duper thank you to you for helping me bring back the dynamic tables to our instance of Confluence! (smile) ).

            Final question >>> Do you know if there is any way to custom-set the width of columns of the dynamic table generated by the JIRA Issue Macro?  That would be awesome functionality, as many times the column width is too wide.  (Note: I am not inquiring about setting the width of the entire table; rather, I want to set the cusom width of individual columns of the table.)

            Thank you!

            Dan

            1. Hi Dan, 

              It is interesting to learn how you use the Confluence to JIRA integration to show the progress of epics/sprints to less sophisticated users. We are currently thinking about how to make such integration easier (not necessary with JIRA issues macro) and doing customer interviews. Do you mind talking to us about your needs? Mail me directly (my_first_name@atlassian.com) 

               

               Do you know if there is any way to custom-set the width of columns of the dynamic table generated by the JIRA Issue Macro?

               Unfortunately there is no way to do it.

          2. Hi Anatoli -

            My apologies on static mode - I thought that we were able to drill through - but we can, as you mention.

            I also concur with Dan, though, on pagination and sorting.  We do utilize this macro for display some large lists (e.g. all employees).  When the list displays in full on one page, you can imagine, it would be quite long. And depending upon what you are looking for, sorting by name, organization, start date, and manager is important.  We also can have longer lists from a products standpoint - e.g. we have filters that pull together all production bugs for each product to make it easier for those troubleshooting, a list of the known issues - again, ability to sort by product, version, component is important.

      3. Anatoli,

        Having the option to create a JIRA issues table that is dynamic from the UI is pretty critical for us. We're in the middle of deploying Confluence & JIRA & are using a confluence page to create meeting agendas. One section of the agenda will be used for previous meeting actions & having a static table would mean that the issue status would not be correct when we have the meeting.

        Our JIRA & confluence users are not capable of create the JIRA issue table using the wiki markup script. How difficult would it be to add the renderMode=Dynamic to the macro UI?

        1. Ben, I think you are talking about caching , not dynamic vs static. There is a separate cache parameter.

          1. Hans-Peter, you are correct. I appear to have more of an issue with the caching of the issues. However IIRC, the dynamic table has a refresh button that allows users to update the issues at will. If I could have the refresh button, I would be happy.

      4. It's interesting to read this "workaround" provided by an Atlassian employee,

        suggesting to use WIKI MARKUP language which (besides of this macro) Atlassian has dropped (in opposition to more than 50% of their customer base).

        Anatoli gives a great example here why it was a mistake to remove the Wiki Markup language.

        It's also horrible that Atlassian again removes a feature (at least from the parameter editor) without discussing it with the customers first. It appears Atlassian has a very poor understanding of customer needs.

        And of course, the suggested workaround is horrible, both from a customer's perspective and from an Atlassian marketing perspective (as you suggest the wiki markup language in contrary to the official Atlassian statements)

        1. Hey Hans, Nice to hear from you. My apologies for the workaround, we are trying to find a way to make sure we aren't blocking your work whilst we address the issues. I understand it's not the cleanest solution, but we are trying to move forward and as I mentioned in my comment below, we are working on addressing these issues. 

  106. Anonymous

    Hi Paul,

    Thank you for your response.  I tried to figure out where to change from "static" to "dynamic" in the

    Insert JIRA Issue macro display options, but it doesn't seem to offer that option:

     

    For some reason, there doesn't seem to be an option to select for a "dynamic" style parameter in the display options above.  I think when I had previously inserted the macro, it provided a different configuration box than the one above.  I am not quite sure wny it is displaying this new box with fewer options.

    Do you know how I can fix this?  Maybe there is another macro I should choose in the Macro Browser from the "Insert Other Macros" option in Confluence?

    Thank you!

    Dan

     

    1. When you click edit on the macro, on the right hand side of the properties that you can input (such as columns), scroll down and you'll see the options of Static and Dynamic.

       

      We are using the most current JIRA version and have the same options as before for the issues macro.  We can input the columns as before, put in a title, etc. Can you add a screenshot of what it looks like now when you display? Also, include the name of the macro you are selecting.

    2. Dan,

      the screenshot you show is from a very new version of the JIRA issues macro. I wasn't aware of it being released yet but I'm no expert. I'll raise this to Anatoli Kazatchkov [Atlassian] who is the development manager of this feature - he can probably assist further.

  107. With the latest enhancement to the widget interface we have lost the ability to update the display options when the issue count is "0".  We use this count within our dashboards to see how we are tracking within a project and setup the filters for each using our project standards, so at the beginning of the project the counts will all be "0".  How can we get around this and display the count as 0? - Thank you!

    1. Hi Andrea, 

      Thanks for the feedback. This is definitely the usecase we will address next - several people mentioned it. As a workaround for now you can insert the macro via wiki mark up with the right url and count parameter set to true: I.e. Insert  -> Wiki Markup :

      1. I found this right after i posted the above (smile)  Thank you for the super fast response!!!

        The above will work for now but i'll be super happy when this is available through the nice new clean widget UI. - Thank you!!!

  108. Yesterday, I installed the new JIRA 5.0 macro and we ran into major performance in our production system, pages with alot of JIRA issues would timeout and fail to load, etc. Than i uninstall 5.0 and reinstalled the older 4.x version, now the "insert JIRA Issue" menu item is missing from the "INSERT" menu. Any ideas on how to resolve that and is Atlassian aware of a performance issue with the new 5.0 code?

    1. ..now the "insert JIRA Issue" menu item is missing from the "INSERT" menu. Any ideas on how to resolve that

      Please make sure that Applicaton Link is configured, it's under Confluence Admin (<URL>/admin/listapplicationlinks.action). We used to only show this menu if application link was configured.

      is Atlassian aware of a performance issue with the new 5.0 code?

      We are not aware of any particular problems - the performance should be the same as before. One difference that might be impacting you is the way the static mode (new default mode) is different from dynamic(used to be default). In dynamic mode we draw the table and then asynchronously request the list of the issues from the server again. In static mode the list of issues is retrieved synchronously when the page is generated. Retrieving issues is taking as much time as before but because it is synchronous the page rendering times out. 

      I can see how it will be impacting you. As a workaround you can increase page rendering timeout:

  109. Hello,

    after updating the issue macro from 4.0.29 to 5.0 the macro cant find any meta data and is looking like that:

    Any suggestions?

    (our Confluence-Version 5.0.3)

    1. Hi Sebastian, 

      You'll need to configure application link between Confluence and JIRA; you can do it under Confluence Admin -> Application Links. With the applink configured, you would get extra functionality that otherwise is not available

      • creating jira issues
      • pasting JIRA url in editor and having it automatically changed to a macro (URL for single issues or the list of issues)
      • link from jira-to-confluence (if 2 ways link is configured)
      • listing recently viewed issues in confluence

      If you are not a confluence administrator and if you have to wait until the admin configures it you can use wiki markup to insert the macro - this way it would execute the query as an anonymous user. 

      I.e. Insert  -> Wiki Markup :

       

    2. I have asked my german speaking colleague what the dialog that you posted actually says and my initial assumption of what it says was wrong. Can you give a bit more details on how you get this dialog? What are you editing?

      1. Hi Anatoli,

        when i insert the issue macro on an empty page over Insert -> JIRA Issue, than the dialog appears.

        After updating the macro-plugin, the application couldn't activate it. And than i activated it manually and this dialog appears. We have some custom HTML in our Confluence-sites, to fix the new chrome-scroll-bug:

        Greetings,
        Sebastian

        1. You can probably get rid of the custom html and install this plugin to fix the editor problem: https://marketplace.atlassian.com/plugins/com.atlassian.confluence.plugins.editor-height-fix . 

          Don't think custom html it is the reason for failure though. Can you please contact support and we will help you out to find the cause of the problem.

        2. You can probably get rid of the custom html and install this plugin to fix the editor problem: https://marketplace.atlassian.com/plugins/com.atlassian.confluence.plugins.editor-height-fix . 

          Don't think custom html it is the reason for failure though. Can you please contact support and we will help you out to find the cause of the problem.

  110. Anonymous

    It seems that with all of the comments regarding the issues associated with the new and 'reduced' feature macro and the use cases that support why they were using it as before, it seems in the best interest of Atlassian users if Atlassian would provide the dynamic mode and prior features. 

    It is disappointing that Atlassian keeps changing features by removing functionality BEFORE asking how and why users are utilizing the features that they provide.

    If a page takes so long that it generally times out - sure, you can increase the timeout feature. But, do you really want your users to wait that long for their information to render?  Why would you not think that column sorting is not important to help users locate issues?  Why would you not think that seeing '0' if important to users? Often when nothing displays, the immediate reaction is something is broken - but 0 is a valid count. Why would you not think that users might have lists longer than 20 or 25 -  remember, JIRA is not JUST a bug track; it is often used for other activities like project implementations that can have many tasks/subtasks, often displayed to summarize a project - there are other use cases mentioned above, such as employee lists and sprint scope, that will list a long set of issues.

    So, you provide a workaround - to now allow users to go back and meet their needs.  Inserting wiki markup (when you really have taken it away and users are not in the habit of utilizing it anymore because of your changes) is the only option and it will not be intuitive for the users. How do you expect them to remember all of these wiki markup workarounds you implement because you have taken away functionality?  Now, since you have done it, what help are you giving your users to update ALL of their existing space pages where this has been implemented so that you don't increase the support burden on all of your Atlassian administrators?

    I've never, EVER worked with a company that their goal seems to be to take away features, deferring their customers to other paid plugins to support what they need and lots and lots of workaround with their older implementation as well as deciding that all of their customers must follow the same processes that Atlassian does, taking away any options that administrators and users should be able to have - to have the options that fit their processes...not be forced to do everything Atlassian's way. 

    Forcing people out of their own processes is a great way to force customers out of your customer base.

     

    1. Hi Anonymous, 

      Let me summarise the list of features that you are currently missing in the new consolidated plugin (in the order of priority)

      • ability to insert a table or a count of issues if there is only one issue returned from the search
      • the performance - frequent timeouts
      • ability to sort the columns

      Am I correct in assuming that order? We are working on the first item from the list and will look into the performance next.

      1. Honestly, I would argue this order:

        • the performance - frequent timeouts
        • ability to sort the columns
        • ability to insert a table or a count of issues if there is only one issue returned from the search

        We really liked the option of a dynamic view due to the extra level of interactivity from a UEX perspective.

        1. Anonymous

          the performance issues forced us to uninstall the 5.0 version, it was causing way to many issues in a short time frame.

        2. I would concur with proposed order because performance issues makes it unusable.

          But, pagination was important to us because we don't want a page that displays 100+ issues and consumes so much real estate, even in an expand macro.  It makes it difficult to review. 

          I would also add the ability to  migrate all existing macros to this new one if additional 'code' is required or if existing macros break with this update.

          it seems quite odd - you develop a macro that doesn't have the same functionality as before, which results in significant dissatisfaction and then have to 'fix' it to put what was taken out back in.  Which JIRA issue was this that made it such a critical priority to refactor and what was the issue being solved?  It is difficult to comprehend how this refactoring was of greater value or priority than many existing Confluence bugs with the RTE, PDF exporter, attachment indexing, etc.

          1. if Atlassian uses a well formulated SQL statement  performance would be not an issue when pagination is on.

            All SQL languages I know allow to limit the number of search results and to skip over a certain number of results (as given by the current page number). Using this, there would be no performance problem and no need to drop functionality.

  111. I everyone, thank you for the feedback on the most recent set of changes to the JIRA issues macro. Just to close off the loop on a lot of the items raised, we have issues raised for the things mentioned on this page. Please watch/vote/comment to stay updated on these issues here: 

    • CONF-30117 - It is not possible to insert a single JIRA issue or a empty JIRA issue search as a table with the new JIRA issues macro Resolved
    • CONF-30116 - Ability to configure the maximum number of issues displayed in the JIRA issues macro Resolved
    • CONF-30115 - JIRA issues macro times out pages with lots of issues Resolved
    • CONF-30114 - Ability to sort issues in the JIRA issues macro table Resolved

    We will update these issues as we make progress on them and have started working on some of them. If there is anything that is missing out of here, please feel free to raise it directly on jira.atlassian.com.

  112. Anonymous

    Dear Atlassian,

    There is a significant problem with the JIRA Issue Macro that has persisted for years:

         "Custom fields" will not word wrap in the column of a dynamic table created from the JIRA Issue Macro.

    I repeat this issue has persisted for *years* (just do a search on the term "wrap" on this page and you will see).  This is a hugely important thing to me and the company I work for, as the tables are essentially worthless without this fixed because users don't have the patience to stretch out a column to 12 inches to read the entire text of a column.  It's silly and makes me/my colleagues look incompetent.

    Could you either tell me a solution on how to fix this or please give me a date by when it would be fixed?

    Thank you,

    DR

     

    1. Hi DR, I presume this is the issue you are referring to?  CONF-23800 - Issuelinks and Description column not being auto word wrap during its display in JIRA Issues Macro Resolved  if not, can you please report an issue on jira.atlassian.com because I can't find any other reference to something like this. You may want to watch/vote on that issue to stay updated.

  113. Anonymous

    Hi Sherif and Atlassian,

    Yes, that is the "word wrapping in the columns of a JIRA Issues Macro table" issue I am referring to. 

    Here's the problem - if you look through that issue and the tickets related to that issue, it dates back to December 2008!  That is almost 5 years! 

    I repeat - this issue has remained unresolved by Atlassian for almost 5 years!

    Why cannot someone prioritize this an fix it?  There are a lot of customers who this would mean the world of difference to. 

    Please help us.

    DR

    1. Hi DR,
      Thanks for your feedback.
      We centralized all the duplicates of this request into  CONF-28378 - JIRA Issues Macro textwrapping issue in columns Resolved  and we are planning this in our next sprints.
      We will keep you posted on its progress in the next weeks.
      The Confluence team.

       

  114. Anonymous

    Hi Geoffrey Bergdoll [Atlassian] and Sherif Mansour:

    I got your reply to my inquiry (above) about the textwrapping bug with the JIRA Issue Macro, and to be perfectly honest I am not really happy about it.

    I understand from that note (above) that you've consolidated the various JIRA tickets that have mentioned this over the past almost 5 years.  However, if the only progress over the past 5 years is to consolidate all the tickets which complain about this bug - that's not really progress in my book.  It feels like Atlassian is completely blowing it off. 

    I would like to see a plan to resolve / schedule towards resolving this issue asap, as your user base deserves that after waiting for 5 years.

    Please provide a plan / timetable to resolve this issue.

    DR

  115. Hi,

    How can i put All JIRA results showed in the page?

    Now the macro is showing 20 results and at the end of the table i can see the link to see 10 more results.

    There is a property to choose the number os items to show?

    Also it's possible remove the Cache memory ? (Oldest version we put Cache = No)

    Many thanks.

    1. We are tracking the JIRA results here:  CONF-30116 - Ability to configure the maximum number of issues displayed in the JIRA issues macro Resolved

      The cache issue is being tracked here:  CONF-30077 - JIRA issue macro aggressively caches, new issues take a while to appear in the issues macro Resolved

  116. The comments field rendering to a counter is interesting, but not very useful. How can I get the actual comments for the JIRA ticket into this macro? I see the comment content in the URL feed but I am unsure of how to program the macro to fetch and display them. I understand it may only show the first or last comment in the ticket, but anything is better than just a number.

     

    Thanks all!

    1. I'd do it by installing an add-on that adds a field type that shows the last N comments. And then add the name of that new Last Comments field in the issuetype columns. That particular add-on is from ServiceRocket where I work

  117. Anonymous

    How do you show only the "backlog" issues on a Wiki page?

    I have successfully been able to show a list of issues in different sprint but I need a way of showing only issues in the "backlog".

    Using this string (project = "WIC" and sprint = "sprint 54" and not type = "sub-task") I get the correct sprint shown. But is there a "code hint" for the backlog

    1. Hi, you should be able to use the filter that you use for your board. E.g. filter="Coathanger"

      You can exclude current sprint by adding sprint!= clause.

       

  118. Anonymous

    I have a couple problems, we recently updated confluence and JIRA and now when I use a search string to insert JIRA issues the table that's displayed is no longer soratable by column. the second problem i'm having is that the issuelinks column is also no longer an actual link its just text.

    in the older versions of JIRA and confluence i used to be able to sort by the headers and the issueliinks were actual links. is there a way to get this functionality back?

    1. Anonymous

      just noticed that i neglected to mention that i'm using the insert JIRA macro, probably obvious but wanted to make sureui.

       

    2. Hi, 

      the table that's displayed is no longer soratable by column

      Some explanation why and a workaround to get the functionality: Re: JIRA Issues Macro . In particular:

      The rational for not having sorting in the static mode is that they are useful only when the list of issues is long. And if the list is long it is much easier to view it in JIRA itself by following the "123 more issues" link at the bottom of the macro. 

      However it looks like quite a few people still want the ability to sort so we will look into implementing :  CONF-30114 - Ability to sort issues in the JIRA issues macro table Resolved

      The second issue you mentioned looks like an existing problem:  CONF-27259 - When using the Issuelinks field column in the JIRA macro, there are no hyperlinks like in the Issue Navigator in JIRA Resolved



  119. Hi,

    When trying to select exactly one jira issue with query “key=ABC-1234”  it shows the issue in the Insert Jira Issue dialog box. After pressing insert everything still looks fine. But when pressing Preview or saving the page following error is received: 

    Error rendering macro 'jira' : com.atlassian.confluence.macro.MacroExecutionException: java.lang.NullPointerException

    Do we have a configuration problem in our Confluence? Or what is causing this java error? And how can it be fixed?

    Confluence 5.1.4 is used with version 5.0 of the Jira macros plugin.

    BR, Kjell

    1. Hi Kjell, 

      It is difficult to see what's the problem. Can you please upgrade the plugin to the latest version 5.0.3 and see if the problem still happens. If it is still the case please contact support and we will help you out.

      1. Hi Anatoli,

        Is v5.0.3 also for Confluence 5.1.4? According to marketplace it is for Confluence 5.2.3 - 5.2.4

         BR, Kjell

        1. You are right, 5.0.3 is only compatible to confluence 5.2.3+

  120. Hi,

    When using a query in the jira macro that at the moment returns only one Jira issue it is converted into a key query.

    E.g. query put in search box:  type = "User Story" AND "Feature(s)" = E1234 ORDER BY key ASC returns exactly one jira issue at the moment. After pressing insert the issue is displayed on the page but when going back to Edit of the macro the query now shows key = ABC-1234 so the original query has for some reason been converted.

    And as it is now a key query saving the page ends up in previous error when trying to save the page: Error rendering macro 'jira' : com.atlassian.confluence.macro.MacroExecutionException: java.lang.NullPointerException

    Why is the original query converted into a key query? As it will not work after more issues have been added to jira that should match the originally inserted query.

    Confluence 5.1.4 is used with version 5.0 of the Jira macros plugin.

    BR, Kjell

  121. Anonymous

    The Macro works well. But integrated Images in an issu list are not dipslayed on the confluence page. What's wrong? 

    Best JB

    1. Hi, can you please check that the base URL for JIRA is configured correctly and accessible. If it doesn't help, please contact support and we will help you.

  122. I am using Confluence 5.2.3.

    I am using JIRA issues Macro. The Prameter window is working well. It is also accepting my JQL and displaying the relevant results. But when i am inserting the data into my confluence page and asaving the page, i am getting an error which says " Cannot render JIRA issues Macro. Execution Error"

    Trusted link between JIRa and Confluence has been established.