This documentation relates to the latest version of Confluence.
If you are using an earlier version, please go to the documentation home page and select the relevant version.

JIRA Issues Macro

All Versions

Confluence 3.0 Documentation

JIRA is the issue tracking and project management system supplied by Atlassian. The Jira Issues macro allows you to display a list of issues from a JIRA site within a page in Confluence.

In other words, if you have your own JIRA site, your Confluence page can show a list of issues from your JIRA project. You can also show a list of issues from any JIRA site to which you and your readers have access.

Screenshot: Example of JIRA Issues shown on a Confluence page



On this page:

Usage with the Macro Browser

To insert the JIRA issues macro into a page using the Macro Browser,

  1. Open your desired Confluence page, then click the 'Edit' button. The 'Edit Page' mode opens.
  2. Next, click the Macro Browser icon on the editor toolbar. The Macro Browser will open in the middle of the screen.
  3. In the Macro Browser, type the name of your desired macro into the search box at the top right of the window. Macros with a matching name will appear in the centre pane. Click on the desired macro to see its options screen. Here, you can set the macro parameters then click 'insert' to put the macro into the page.

Once you've found the JIRA issues macro, click 'insert' to add it to your page.

Usage with the Wiki Markup Editor

The basic syntax is:

{jiraissues:url=<URL of your JIRA XML view>}

Displaying a List of JIRA Issues on a Confluence Page

Step 1 — Obtain the URL of the Issue Filter

  1. Log in to your JIRA system.
  2. Go to the 'Find Issues' screen and create a new filter. Do not modify an existing filter.
  3. Set up your search parameters and use 'View' to check the issues returned.
  4. Once the filter is finished, go to the 'Filter View' tab located above and to the left of the 'View' button.
  5. From the 'Filter View' tab, locate the 'Current View' links section (see example below) and find the 'XML' link.
  6. Copy the 'XML' link to your clipboard.

Step 2 — Embed the Issue Filter URL onto your Confluence Page

  1. Log in to your Confluence system.
  2. Edit the page where you wish to display the list of JIRA issues.
  3. Type the following text into a new line at the appropriate location:
    {jiraissues:url=CONTENT}
    
  4. Replace 'CONTENT' with the JIRA filter URL from your clipboard.
  5. Customise the macro output by adding optional parameters. See below.
  6. Save the Confluence page.

Parameters

Parameters are settings for Confluence macros that allow the user to control their content or presentation. The table below lists relevant parameters for this macro.

Parameter names are displayed differently in the macro browser interface and in wiki markup. Below, parameter names used in the macro browser are indicated in Bold text, while their equivalents in wiki markup are indicated in (bracketed) text. If the latter is not shown, then in wiki markup, the parameter's name should be omitted and only its value should be added immediately after the colon symbol (:).

The JIRA Issues macro allows the following parameters:

Parameter Required Default Description
Anonymous Retrieval
(anonymous)
no false If this parameter is set to 'true', JIRA will return only the issues which allow unrestricted viewing i.e. 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. See more details below.
(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.
JIRA Field Columns to Display
(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 (;). Example columns are: key, summary, type, created, fixversion, updated, due, assignee, reporter, priority, status and resolution. You can include any columns recognised by your JIRA site, including custom columns.
Display Total Numbers Only
(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
(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'.)
Height (Pixel Value Only)
(height)
no 480 The height in pixels of the table displaying the JIRA issues.
Note that this height specification is ignored in the following situations:
  • If you set the 'renderMode' parameter (see below) to 'static'.
  • When the JIRA issues are displayed in a PDF or Word document, in an email message or in an RSS feed.
(renderMode) no In formats not mentioned below, the default is 'dynamic'.
The default is 'static' when the JIRA issues are displayed in a PDF or Word document, in an email message or in an RSS feed.
By default, the JIRA Issues macro offers a dynamic display with the following features:
  • 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.
    Set the 'renderMode' parameter to 'static' if you want to disable the dynamic display features.
Title
(title)
no JIRA Issues You can customise the title text at the top of the JIRA issues table with this parameter. For instance, setting the title to 'Bugs-to-fix' will replace the default 'JIRA Issues' text. This can help provide more context to the list of issues displayed.
URL
(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
(width)
no 100% The width of the table displaying the JIRA issues. Can be indicated either as a percentage (%) or in pixels (px).

Issues Displayed a Page at a Time

If you are using JIRA 3.13 or later, the JIRA Issues macro will retrieve and show a 'page' of issues at a time. The buttons underneath the table allow you to move to the next or previous page, or to the start or end of the list. The number of issues retrieved per page is determined by the url parameter — see the description of the macro parameters above.

If your version of JIRA is 3.12 or earlier, the JIRA Issues macro will retrieve all the issues at once and display them as a single 'page'.

Example

Below is an example of some macro markup code, requesting a list of issues from the Atlassian public JIRA site:

The example code contains three parameters (see above parameter table for their meanings):

  • anonymous=true
  • url=<a long URL derived from the XML view of a JIRA filter>
  • columns=type;key;summary

Below are the results of the above macro markup, displayed on this Confluence page:

Displaying Issues which have Restricted Viewing

Maybe your JIRA instance is not visible to anonymous visitors — everyone has to log in before they can see JIRA issues. Or maybe some of the JIRA issues are restricted to viewing by certain users only. This section explains how to handle JIRA issues that have restricted viewing.

Using Confluence-to-JIRA Trusted Communication (Recommended)

For Confluence 2.7.0 and later and JIRA 3.12 and later, your administrator can set up trusted communication between Confluence and JIRA. The entire process is described in the Confluence Administrator's Guide. Provided that your administrator has set up trusted communication, you don't need to add any extra parameters. Confluence and JIRA will work out the security between them, ensuring that the user will see only the issues they are authorised to see. Read the section below if you want more detail.

Remove the username and password from your macro markup code

Prior to Confluence 2.7, you needed to include a username and password in the macro markup code if you wanted to display JIRA issues which had restricted viewing. Once your administrator has set up trusted communication between Confluence and JIRA, you no longer need to include a username and password in the markup code for your JIRA macros.

The following options are available for determining the issues which will be retrieved from JIRA and displayed on the Confluence page:

What you want to do Macro parameter URL parameter Comments
Display the JIRA issues which the logged-in user is authorised to see. And if the user is not logged in, display only issues which allow unrestricted viewing.     Do not specify any authentication parameters. In this case, the behaviour depends on the way your administrator has set up trusted communication between JIRA and Confluence. Here is a summary of the behaviour. If trusted communication is enabled, the authorisation will work seamlessly. When a logged-in user views your page, they will see only the JIRA issues they are allowed to see. And if they are not logged in, they will see only the issues which allow unrestricted viewing. If trusted communication is disabled, the Confluence page will show only the JIRA issues which allow unrestricted viewing.
Ensure that Confluence will display only the JIRA issues which allow unrestricted viewing. anonymous   Regardless of who the user is (logged in or not), the Confluence page will show only anonymously-visible issues. Confluence will not attempt to set up a trusted communication link with JIRA in this case.
Use a pre-determined username and password to access the JIRA issues.   &os_username=MYNAME&os_password=MYPASSWORD Not recommended. Prior to Confluence 2.7, this was the only way of displaying issues with restricted viewing. For Confluence 2.7 and later, this method will still work. Confluence will not attempt to set up a trusted communication link with JIRA in this case.

Specifying Username and Password in the JIRA URL (Not Recommended)

If you have not set up trusted communication between JIRA and Confluence and if your JIRA issues have restricted viewing (i.e. JIRA requires a login before allowing access to the issues), then you need to type a JIRA username and password into the macro markup code and save it onto the Confluence page.

Append the following parameters to the end of the search URL:

&os_username=MYNAME&os_password=MYPASSWORD

where MYNAME is a JIRA username and MYPASSWORD is the corresponding password for that username. This username and password should not include an ampersand (&) symbol.

Troubleshooting

HTTPS

The JIRA Issues macro can access a JIRA instance running under SSL as long as the Confluence server is set to accept the JIRA SSL certificate.

JIRA 3.7 Link Format Change

Unable to render {include} Couldn't find a page to include called: JIRA 3.7 Link Format Change

And see also:

RELATED TOPICS

JIRA Portlet Macro
Working with Macros

In the Administrator's Guide:

Take me back to the Confluence User Guide.

Labels

jiraissues jiraissues Delete
macro macro Delete
integration integration Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
  1. Mar 05, 2008

    Anonymous says:

    I need to add other columns that are not listed how can I do that such as "estim...

    I need to add other columns that are not listed how can I do that such as "estimated time"

    1. Mar 06, 2008

      Choy Li Tham says:

      Hi, Unfortunately, Confluence does not provide this feature currently. However,...

      Hi,

      Unfortunately, Confluence does not provide this feature currently. However, there is an improvement request being tracked at the following link:

      Please do cast your vote to increase its popularity and add yourself as a watcher to the improvement request for future updates. Also, feel free to add comments to the improvement request to reflect the importance of this feature.

      Regards,
      Choy Li

  2. May 23, 2008

    Jay Guidos says:

    I set up JIRA 3.12.2/Confluence 2.7 as per the instructions.  When I view t...

    I set up JIRA 3.12.2/Confluence 2.7 as per the instructions.  When I view the JIRA XML feed from a web browser I see my list of issues in the feed, but when I include the macro on a wiki page I get an empty list. The list all looks correct, the feed link at the top of the table shows me all the issues (on another page) when I click on it...  but I don't see the list of issues in the table.  I am a logged on user on the wiki when I try this.  What am I doing wrong?

    jiraissues: Unable to determine if sort should be enabled

    thats my XML feed URL inside the macro

    1. Jun 02, 2008

      Tony Cheah Tong Nyee says:

      Hi Jay, Feel free to raise a support ticket in our Support Channel at: https...

      Hi Jay,

      Feel free to raise a support ticket in our Support Channel at:

      From there, we will try troubleshoot the problem further.

      Cheers,
      Tony

    2. Jun 13, 2008

      jd lima says:

      I expect the problem's due to a saved filter in JIRA that's private, and the lac...

      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.

    3. Dec 03, 2008

      Kevin Turner says:

      This error occurred for me also.  I'm using Confluence 2.10 and JIRA 3.13.&...

      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. Dec 03, 2008

        Andy Brook says:

        That old chestnut. you need to import the Certificate Authority (CA) that signe...

        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 ) and do this from the security folder:

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

        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

  3. May 27, 2008

    Anonymous says:

    The 2.4.1 version of the plugin (Confluence 2.7.2?) looks like it nearly support...

    The 2.4.1 version of the plugin (Confluence 2.7.2?) looks like it nearly supports a template parameter,where template=xp should use the jiraissues-xp.vm template instead of jiraissues.vm. Anyone else got this working?   

    ~Matt

    1. Jun 02, 2008

      Tony Cheah Tong Nyee says:

      Hi Matt, Have you try this on older version of Confluence such as 2.5.x/2.6.x? ...

      Hi Matt,

      Have you try this on older version of Confluence such as 2.5.x/2.6.x? If the problem still persists, I would suggest you to raise a support issue at:

      From there, we will help to investigate this issue further.

      Cheers,
      Tony

      1. Jun 12, 2008

        Matt Doar says:

        Tony, I suspect that the parameter "template" is not supported since it is not d...

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

        1. Jun 16, 2008

          Tony Cheah Tong Nyee says:

          Hi Matt, It appears that the parameter is only applicable to an anonymously acc...

          Hi Matt,

          It appears that the parameter is only applicable to an anonymously accessible JIRA instance. For example, I have tried the following markup and it works on my side:

          {jiraissues:url=http://jira.atlassian.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?&pid=10470&fixfor=13414&resolution=-1&sorter/field=issuekey&sorter/order=DESC&tempMax=200|anonymous=true|template=xp}
          

          Note that it only work if you also include the "anonymous=true" option.
          If the above is not the case, I would suggest you to raise a support request and we will help to investigate this issue further.

          Cheers,
          Tony

  4. May 29, 2008

    Daniel Berkich says:

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

    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. Jun 03, 2008

      Tony Cheah Tong Nyee says:

      Hi Daniel, Feel free to check out its source code in the following repository: ...

      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

  5. Nov 25, 2008

    Ramkumar says:

    Trackbacks in JIRA does not detect the Confluence pages that use this {jiraissue...

    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. Jun 10, 2008

      Ming Giet Chong says:

      Hi Ramkumar, I would suggest you to raise a support ticket at https://support.a...

      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. Jun 11, 2008

        Ramkumar says:

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

        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.

  6. Jun 13, 2008

    jd lima says:

    I posted a possible fix for the broken "Atlassian JIRA" link in the jiraissues m...

    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.

  7. Jun 13, 2008

    Matt Doar says:

    Looking at the source code for this plugin, I don't see any reference to the tem...

    Looking at the source code for this plugin, I don't see any reference to the tempMax parameter. Perhaps it's processed in some parent class? It's not in the velocity template either. Or maybe the documentation on this page is out of date? Has anyone else managed to use this parameter as intended?

    1. Jun 14, 2008

      jd lima says:

      Matt, the tempMax param is provided by JIRA.

      Matt, the tempMax param is provided by JIRA.

      1. Jun 16, 2008

        Matt Doar says:

        Right, so it's part of the URL and parsed there, instead of part of the macro co...

        Right, so it's part of the URL and parsed there, instead of part of the macro code like 'columns'. So that means that the documentation above is incorrect to place it in the parameters table.

        1. Aug 06, 2008

          Cheryl Jerozal says:

          yeah, you're right. fixed above

          yeah, you're right. fixed above

  8. Jul 23, 2008

    Drakk says:

    Hi, I have the plug-in finally working, minus the bottom bar that shows: 'Displ...

    Hi,

    I have the plug-in finally working, minus the bottom bar that shows: 'Displaying 1 to 10 of 10 items'.

    Is there a parameter that I need to input?  We are using Jira Macros 2.7 & Conf 2.8.1

    Thanks!

    1. Jul 24, 2008

      Azwandi Mohd Aris says:

      Hi Drakk, Please note that this feature will be available in Confluence 2.9, wh...

      Hi Drakk,

      Please note that this feature will be available in Confluence 2.9, which is scheduled to be released in the near future. We are currently evaluating this version, as you can see in the footer section of this page. Hope this helps.

      Cheers,
      Azwandi

  9. Jul 25, 2008

    Drakk says:

    Ah perfect! Much obliged for the heads-up! -Drakk.

    Ah perfect!

    Much obliged for the heads-up!

    -Drakk.

  10. Aug 05, 2008

    Anonymous says:

    Is there a way to sort the list according to a given criteria. I have a long lis...

    Is there a way to sort the list according to a given criteria. I have a long list of tasks in a page, and I want to sort them by Assignees. Is it possible to give a parameter like "sortby" or something else in the jiraissues macro ?

    1. Aug 06, 2008

      Cheryl Jerozal says:

      here's how to sort by a particular field: when in jira looking at the issue nav...

      here's how to sort by a particular field:
      when in jira looking at the issue navigator list you want, sort by assignees there before copying the xml url. (if you only have the xml url at this point, you can find the jira issue navigator link if you visit the xml and look at the contents of the first "link" element.) when you then use the new xml url with the jiraissues macro, the results should be sorted by assignee.

  11. Aug 11, 2008

    Anonymous says:

    Are you planning on adding any other valid column headings.  We use the jir...

    Are you planning on adding any other valid column headings.  We use the jira list as a project management tool and it would be nice to see the "time remaining" and not have to open each issue to see how much time is remaining.

    1. Aug 12, 2008

      Azwandi Mohd Aris says:

      Hi there, You might be interested in the following improvement requests: CONF...

      Hi there,

      You might be interested in the following improvement requests:

      • CONF-2407 for adding custom fields in the JIRA issues list
      • CONF-3135 for adding support for all JIRA built-in fields

      Hope this helps.

      Cheers,
      Azwandi

  12. Sep 10, 2008

    Andy Brook says:

    I just got a test sever up with Conf 2.9.1 and Jira 3.13, I don't appear to be g...

    I just got a test sever up with Conf 2.9.1 and Jira 3.13, I don't appear to be getting any results back, the nice macro UI data rows are empty (jiraissue plugin ver is 2.8.5). Also the Labels on the macros UI seem to be 'keyed' , eg 'jiraissues.column.type' instead of English 'Type'.

    I get almost identical results against 3.12.3 and 3.13, both Jira instances setup to trust the Confluence 2.9.1 server. At the bottom of the macro UI, I see text relating to the quantity of results, I see Displaying 1 to 20 of 20 items or Displaying 1 to 40 of 40 items. I think this means data is being retrieved but not rendered.

    • Linux/Firefox 3.0.1

    Anyone else seeing this or is my new deployment of Confluence foobar?

    1. Sep 10, 2008

      Andy Brook says:

      Never mind, I forgot to reset the default plugin compatibility to not include BE...

      Never mind, I forgot to reset the default plugin compatibility to not include BETA. I was using the current 2.8 beta which has problems, 2.7 is fine.

      1. Sep 11, 2008

        Cheryl Jerozal says:

        hi andy~ most 2.8 versions are in beta, but we haven't gotten any reports of th...

        hi andy~

        most 2.8 versions are in beta, but we haven't gotten any reports of them being broken in the way you describe. we'd like to check into this. would you be able to provide us with the xml data that is not showing up in the jiraissues macro, and the macro syntax you are using? if so, please create an issue here with the xml attached: http://developer.atlassian.com/jira/browse/CONFJIRA
        (if you don't want the xml publicly available, you can mark the issue as available to "reporters and developers" only with the "security level" setting.)

        ~cheryl

  13. Sep 20, 2008

    Michael Corn says:

    Quick question. The jiraissues macro does seem to work well now that we have tru...

    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. Sep 22, 2008

      Azwandi Mohd Aris says:

      Hi Michael, Could you please check that the image's URL of the same issue type ...

      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

  14. Sep 24, 2008

    John Reynolds says:

    G'day, I was just wondering which version of Jira Trusted Applications became a...

    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. Sep 24, 2008

      Cheryl Jerozal says:

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

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

      1. Sep 24, 2008

        John Reynolds says:

        Thanks, Cheryl

        Thanks, Cheryl

  15. Nov 25, 2008

    Anonymous says:

    Hi, we are currently encountering issues when displaying {jiraissues}   &nb...

    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. Oct 08, 2008

      Cheryl Jerozal says:

      this error may be caused by incorrect macro parameter usage (for example, puttin...

      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! )

  16. Oct 08, 2008

    2t says:

    Sorry for the duplicate... Hi, we are currently encountering issues when display...

    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. Oct 08, 2008

      Cheryl Jerozal says:

      please create a support request
  17. Oct 10, 2008

    John Reynolds says:

    We're running the jiraissue macro in Confluence 2.9 against Jira 3.11. If we lin...

    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. Oct 10, 2008

      Cheryl Jerozal says:

      Hi again John~ This error occurs when the macro has trouble parsing the XML ret...

      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

  18. Nov 25, 2008

    Anonymous says:

    Hi do some one knows if the jira issue macro supports size option? {jiraissues:...

    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. Nov 24, 2008

      Cheryl Jerozal says:

      the latest version of this plugin, which is currently used here on confluence.at...

      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.

  19. Dec 08, 2008

    David Aldridge says:

    Is there any way to parametrically specify the query parameters (ie. specify the...

    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

    {jiraissues:url=|username=Bob|numdays=30}

    or

    {jiraissues:url=|username=Frank|numdays=7}
    

    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. Dec 11, 2008

      Giles Gaskell [Atlassian Technical Writer] says:

      Hello David, If you wish to modify your JIRA Issues macro filter with the speci...

      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

  20. Dec 17, 2008

    Francis Martens says:

    Is there a way to modify the link between the issues listed in a jiraissues list...

    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. Dec 17, 2008

      Cheryl Jerozal says:

      the plugin simply uses the contents of the link element in the xml returned from...

      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.

  21. Dec 18, 2008

    Francis Martens says:

    I will adapt the plugin as the link should contain the key, and I can't expect t...

    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

    Tx

    1. Dec 18, 2008

      Cheryl Jerozal says:

      there should be a way to generate the field contents in jira, but i think if you...

      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.)

  22. Jan 05

    Markus Schmidt says:

    Version 2.8.7 of the issues macro really rocks, because now you can choose any ...

    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:

    Wenn ein Kalender ausgew&#xE4;hlt ist und 'Neuer Termin' ausgew&#xE4;hlt wird, ist immer 'W&#xFC;rth-Gruppe' vorausgew&#xE4;hlt.
    Stattdessen sollte der vorher gew&#xE4;hlte Kalender bereits vorausgew&#xE4;hlt sein.
    

    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. Jan 13

      Cheryl Jerozal says:

      hi markus~ is the text you give an example of contents of a description column ...

      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. Jan 14

        Bernhard Schwager says:

        We have the same error with the umlauts, but only on custom fields. (I have seen...

        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. Jan 14

          Cheryl Jerozal says:

          hmm, i just added umlaut-containing text to the issue mentioned above in a custo...

          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. Jan 14

            Bernhard Schwager says:

            It works only, if the jira field is set to the Wiki Style Renderer. The error oc...

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

  23. Jan 08

    bhagat bandlamudi says:

    Macro works fine, but I am wondering if there is a way to configure the display ...

    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. Jan 12

      Cheryl Jerozal says:

      no, you cannot have the height auto-adjust based on the number of issues returne...

      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.

  24. Feb 09

    Jason Boyle says:

    I still seem to have difficulty getting any custom fields displayed - I have Con...

    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..)

    {jiraissues:url=http://myserverhere:9090/sr/jira.issueviews:searchrequest-xml/10171/SearchRequest-10171.xml?tempMax=1000&os_username=user&os_password=password|columns=key;summary;status;due;customfield_10051}
    

    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. Feb 09

      Cheryl Jerozal says:

      hi jason~ displaying custom fields with the jiraissues macro was added in a ver...

      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

  25. Feb 13

    Dan Levine says:

    Is there any workaround to put a width setting in.  It's important for the ...

    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. Feb 13

      Cheryl Jerozal says:

      dan, it's not a workaround but it is something: there's an issue for it. and you...

      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

  26. Feb 24

    adamensor says:

    Hi, pulling issues list from Jira into Confluence and I can't seem to bring over...

    Hi, pulling issues list from Jira into Confluence and I can't seem to bring over the Fix Version/s field.

    Other fields all come over fine, syntax is below, have tried a number of case/spelling changes.

    Any ideas?

    Thanks

    jiraissues: Unable to determine if sort should be enabled
    1. Feb 24

      Bernhard Schwager says:

      It's called "fixversion". You will find the field names in the xml export from ...

      It's called "fixversion".

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

      Regards,

  27. Feb 24

    adamensor says:

    Thanks - I tried that but field still seems to be blank in Confluence but contai...

    Thanks - I tried that but field still seems to be blank in Confluence but contain data in Jira

    Syntax is '

    jiraissues: Unable to determine if sort should be enabled

    '

    Other columns including Ideal Days which is custom are fine

    1. Feb 24

      Cheryl Jerozal says:

      hi adam~ we can't see your syntax used because confluence is trying to render t...

      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

  28. Feb 24

    adamensor says:

    Thanks for the tip jiraissues:anonymous=false|columns=key;summary;Ideal Da...

    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. Feb 24

      Cheryl Jerozal says:

      hi adam~ you are right – thanks for pointing this out. unfortunately this...

      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

  29. Mar 03

    Anonymous says:

    The size of a jiraissues macro pane defaults to about double the width of a stan...

    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. Mar 03

      Cheryl Jerozal says:

      i don't think there is a built-in way to change the scale. you could try modifyi...

      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

  30. Mar 13

    Tido Lorenz says:

    Dear Cheryl! I really like this makro - but I have one problem: We always use a...

    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. Mar 13

      Cheryl Jerozal says:

      Hi Tido~ What you describe sounds like it could be a bug. If you can provide mo...

      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

  31. Mar 18

    Patrick Meyer says:

    Using Jira 3.13 and testing Conluence 2.10.2 Noticed that the behavior of the c...

    Using Jira 3.13 and testing Conluence 2.10.2

    Noticed that the behavior of the colums has changed and the width of the JIRA display on the page has changed also.
    So my questions are:
    1. how to get the summary column to behave nicely as in 2.9
    2. can the width of the jira display be changed?
    2a. can there be a "display like it did in 2.9" feature?

    thanks

    1. Mar 19

      Cheryl Jerozal says:

      Hi Patrick~ 1. could you give more details about what you mean by "nicely"? 2. ...

      Hi Patrick~

      1. could you give more details about what you mean by "nicely"?
      2. this feature has been implemented and should be making it into the 2.8.8 release of the plugin
      2a. you can use the renderMode=true parameter to your macro

      ~Cheryl

      1. Mar 19

        Patrick Meyer says:

        Hi Cheryl What I meant by "nicely" is in confluence 2.9 the summary field does ...

        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?

        1. Mar 19

          Cheryl Jerozal says:

          Hi Patrick~ The summary field is not supposed to take over the whole space, it ...

          Hi Patrick~

          The summary field is not supposed to take over the whole space, it is just supposed to take up some of it. "Some" is calculated based on the width the macro detects, but it does not always do a good job detecting the width, particularly in certain situations. For example, when the toc macro is being used the space the toc macro takes isn't subtracted from the width available to the jira issues macro. Perhaps you are experiencing the bug I have described. If not, it would be great to get a bug report from you in the CONFJIRA project.

          ~Cheryl

  32. Mar 27

    Patrick Meyer says:

    Jira 3.13 and Confluence 2.9 Have a filter in Jira that displays an Issue and i...

    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. Mar 31

      Azwandi Mohd Aris says:

      I could not replicate this on a local instance. Perhaps, you can try creating a ...

      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.

  33. Mar 27

    Sally says:

    Hi, I'm using Jira 3.12.3 and Confluence 2.9.2.  They are listed as truste...

    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. Mar 30

      Arie Murdianto says:

      Hi, Please have a look in the following page which may be useful for you: htt...

      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,

  34. Mar 30

    Sally says:

    That worked, thank you!! However, I have a new problem - I want to show...

    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. Mar 30

      Azwandi Mohd Aris says:

      Hi Sally, Is the column name correct (i.e "description")? You might want to tes...

      Hi Sally,

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

      {jiraissues:anonymous=true|url=http://jira.atlassian.com/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?&query=jiraissues&summary=true&description=true&body=true&pid=10470&tempMax=10|columns=type;key;summary;description}
      
      
      1. Mar 31

        Sally says:

        Hmm, I copied what you wrote and it's still only showing the Key, Issue type and...

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

        1. Apr 01

          Azwandi Mohd Aris says:

          Hi Sally, Sorry that I didn't realise that you are using Confluence 2.9.2, henc...

          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. Apr 01

            Sally says:

            Thanks, Azwandi!

            Thanks, Azwandi!

  35. Apr 02

    Anonymous says:

    Trying to display Jira issues into Confluence (2.10) and I cannot display the 'A...

    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. Apr 02

      Bernhard Schwager says:

      Some fields with a different syntax. Cheers, Jira Field Name jiraissues C...

      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. Apr 02

        Cheryl Jerozal says:

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

        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. May 11

        Frank Stiller says:

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

        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. May 13

        Anonymous says:

        Hi, Than ks for the list Bernhard. timespent is not working for me. Even thou...

        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

  36. Apr 13

    Bill Davis says:

    I have confluence 2.10 and JIRA 3.13.2 and we are trying to create an issues Mac...

    I have confluence 2.10 and JIRA 3.13.2 and we are trying to create an issues Macro (version 2.8.7on a confluence page to display the JIRA's for a particular project.
    We follow the step by step instructions on the [http://confluence.atlassian.com/display/DOC/JIRA+Issues+Macro] page to create the query and do not add any of the additional parameters to the macro.
    When we view or preview the confluence page we see the Issues header, but where the actual rows would appear we see the following error message:
    Error: Incorrect result size: expected 2, actual 4 class org.springframework.dao.IncorrectResultSizeDataAccessException
    and we have not been able to find out why this is appearing, does anybody have any advice on why this error is appearing?

    1. Apr 16

      Cheryl Jerozal says:

      Hi Bill~ I haven't seen that one before so it is probably best if you work with...

      Hi Bill~

      I haven't seen that one before so it is probably best if you work with support to troubleshoot.

      ~Cheryl

  37. Apr 16

    amina lagnaoui says:

    Hi, Is it possible to change the size of the jiraissueMacro render? I hav...

    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. Apr 16

      Cheryl Jerozal says:

      Hi Amina~ It is not currently possible, but that feature has been implemented a...

      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

  38. Apr 22

    Anonymous says:

    When following the procedure to include a JIRA issues list, I cannot get the XML...

    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. Apr 22

      Cheryl Jerozal says:

      Hi Bernie~ Two possibilities come to mind: some of the issues are not visible...

      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

  39. Apr 28

    Anonymous says:

    When specifying the following, I only see Key, Summary, Status, Assignee display...

    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. Apr 28

      Cheryl Jerozal says:

      Displaying custom fields with the jiraissues macro was added in a version of the...

      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.

  40. May 01

    Anonymous says:

    We are currently using Confluence 2.10.2 and JIRA 3.13-#330. When we display the...

    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. May 05

      Arie Murdianto says:

      it seems that the header's title is having a fix string. You may want to raise a...

      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. May 07

      Frank Stiller says:

      you can probably change that by changing the jiraissues.properties file. Either ...

      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. May 08

      Frank Stiller says:

      analysed it a bit more. The jiraissues.properties file is the default one. It is...

      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.

  41. May 10

    Mike says:

    I have a custom 'User Picker' field which I want to display. When using the issu...

    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. May 22

      Arie Murdianto says:

      Hi Mike, jiraissues macro does downloading and extracting the data from an xml ...

      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,

  42. May 13

    Hasan Edain says:

    Is there any way to keep the user from having to scroll in two directions to see...

    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. Jun 04

      Azwandi Mohd Aris says:

      Hello Hasan, As far as I am concerned, user can now specify the height and widt...

      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. Jun 04

        Hasan Edain says:

        So the height and width allow me to ensure that the table fits into the page. Th...

        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.

  43. May 19

    Anonymous says:

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

    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: Unable to determine if sort should be enabled

    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?

  44. Jun 04

    Nick Jones says:

    everytime someone comments here I get the page emailed to me. I'm not watching i...

    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?

  45. Jun 19

    Theodor Radu says:

    JIRA:Enterprise Edition, Version: 3.13.2-#335 Confluence: 2.9.2 I am not able ...

    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. Jun 22

      Azwandi Mohd Aris says:

      Hello, Theodor. Those features were introduced in Confluence 2.10. I would sugge...

      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!

    2. about 15 hours ago

      gilbertsavier says:

      <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal Unkn...

      <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal

      Unknown macro: {mso-style-parent}

      span.yshortcuts

      Unknown macro: {mso-style-name}

      @page Section1

      Unknown macro: {size}

      div.Section1

      Unknown macro: {page}

      -->

      Hello,

            We have a w3wp.exe that uses 99% CPU for a lot of time. How can I find what asp script causes this? I make a user dump through debug diag, but it doesn't help me, because there wasn't any reference to the asp script that launches the threads.
                                                   Thanks in advance for your help.
      Regards,

      Gilbertsavier

  46. about 19 hours ago

    Jesper Højgaard Pedersen says:

    Hi, I keep getting the error "jiraissues: Unable to determine if sort should be...

    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. about 19 hours ago

      Andy Brook says:

      I just got this same error, but on 2.10.3, it transpired an apache server was do...

      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 ). Validate your filter url in a browser, perhaps you have a DNS or similar lookup problem.

      1. about 18 hours ago

        Jesper Højgaard Pedersen says:

        Hi Andy, Indeed, the error message isn't very helpful. Thanks for your quick re...

        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 :)

Add Comment


Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.