This is not an issue for users running the latest versions of Confluence and JIRA. However, users using Confluence versions older than 2.2.10 to access JIRA 3.7 must upgrade Confluence or patch the JIRA issues macro to handle the 3.7 format.
Confluence
JIRA
OK
Action Required
2.2.10, 2.3
Any version
None
Older than 2.2.10
3.7
Stop Confluence, open your Confluence install directory and remove the file \WEB-INF\lib\jira3.jar. Download the JIRA 3.7 version and rename it to jira3.jar
The following parameters can be embedded in the macro call.
Parameter
Required
Default
Description
url
yes
none
The URL of the XML view of your selected issues in Jira Issue Navigator.
columns
no
none
a semi-colon delimited list of jira column names. Valid columns are key, summary, type, created, updated, due, assignee, reporter, priority, status and resolution
count
no
false
true will output the number of issues in JIRA, linking the count to the JIRA instance
cache
no
on
'off' will refresh the jiraissues cache, forcing a reload on the page before the display
baseurl
no
the header link to the issue navigator will use this base url (used when Confluence connects to Jira with a different URL to normal users)
tempMax
no
20
limits the number of results you get back. This is the case even when count is set to true.
Example
This macro call requests a filter results from the Atlassian public JIRA instance:
For problems relating to the JIRA Issues Macro, click on your query below for the solution.
Issues Appear Out Of Date Using cache with this macro it can be that you have stale data in you table. You can force a refresh of the table by clicking the Refresh button in the top-right hand corner of the table.
'Error Rendering Macro' or No Issues Are Displayed or Not All Issues Are Displayed You must append a JIRA username and password to your JIRA issues filter URL. That JIRA user must also have permission to view the all issues returned by the filter, otherwise they will be omitted. Please append the os_username and os_password as described below so that jiraissues:url=http://host.com/secure/IssueNavigator.jspa?... becomes jiraissues:url=http://host.com/secure/IssueNavigator.jspa?...&os_username=MYUSERNAME&os_password=MYPASSWORD where MYUSERNAME and MYPASSWORD are a JIRA login.
'Error rendering macro: java.io.IOException: Could not download' You may need to configure Confluence to acknowledge your proxy server before it is able to download the feed.
'Error rendering macro: java.io.IOException: Error on line -1: Premature end of file' Did you select an existing JIRA filter? If you did, your issues filter URL will end with .../12345/SearchRequest-12345.xml where 12345 is any number. You should retry using a new and unsaved filter.
Be aware that if your Jira RSS feed is not available without logging in to the application, you will need to add the following to your URL:
&os_username=username&os_password=password
Posted by mark.johnson at Jun 17, 2004 00:34
is there another way to make the rss feed available without logging in that making the "view issues" permission available to "Anyone" ?
can somebody comment on the way issues are cached from jira to confluence ? My confluence pages are not always exactly up to date with jira, there seems to be something like a 30min lag. I'd just like to know how it works
Posted by at Aug 25, 2004 08:02
Is there a list of all the columns we can get? Specifically I need, time original estimate, time remaining and components.
Also, can we get custom fields in the feed as well?
Posted by sdonovan@objectvideo.com at Oct 20, 2004 14:58
Any update as to the ability to add custom columns to this macro?
Posted by at Nov 17, 2004 18:32
i'd also like to know if there is anyway to make the feed available without logging in - i don't really like the idea of specifying my loging password b/c then anyone who edits the page can see my information.
as a work around, i created a specific user to use for reading the feeds - however i don't understand the following behavior...
the rss-feed reader user (jirarss) is not part of the jira-users group, and i am unable to log into jira w/ this user. however, if i specify this username and it's corresponding password as part of the url, it does properly render the issues (w/o it i get a rendering error: ParseException: Error on line 24: Open quote is expected for attribute "width" associated with an element type "td")
could someone explain why this works?
Posted by jae.gangemi@tsysprepaid.com at Dec 01, 2004 11:42
We have a password prompt for our intranet site, which our JIRA install is behind (we use mod_jk2), that seems to be causng some trouble. In the meanwhile, I've just accessed Tomcat directly, bypassing this, and for our needs it should be sufficient. But other than that, is there a way to get around auth protected pages?
Posted by at Jan 20, 2005 08:53
I agree about not wanting to pass my username and password around in the url. Is there some reason that the cookies used for a JIRA login could be used for this? This approach would solve both where Confluence is integrated with a specific JIRA installation, or if it isn't. It probably shouldn't work if the user wasn't logged into the JIRA already, but if they are?
Posted by rzigweid-atlassian@zigweid.net at Feb 14, 2005 07:01
I agree. Plus due date, sub-tasks.
Posted by bob.swift@lakeviewtech.com at Apr 04, 2005 21:48
Did you find an answer to your question? I need this capability as well.
Posted by jeanmar@yahoo.com at Jun 15, 2005 11:03
I 've noticed that the rendered table shows (7 issues) in the header band instead of the 3 presented in the table detail rows. We get similar behaviour in our confluence / jira integration, though it is not repeatable in all jiraissues macro instances. Is it a known issue?
Posted by angel@acm.org at Oct 07, 2005 05:35
Aggelos,
Not that we are aware of. If you find a way to reproduce the problem, please submit a bug with a screenshot of the error, and we'll fix it.
Thanks,
Dave
Posted by dave@atlassian.com at Oct 09, 2005 23:35
David,
the repro is right here on this same page. The example above displays on the header row (7 issues) instead of the three that are list on the same table. I' ll try to reproduce it on our own server and then I'll submit the bug.
Cheers,
Aggelos
Posted by angel@acm.org at Oct 10, 2005 08:00
Would really like to see the authentication thing figured out here.
Posted by wdoyle@walkerinfo.com at Nov 10, 2005 20:27
Using the free standalone Confluence, only the table format/columns and header get displayed (i.e. without the actual issues from JIRA). I suppose the jiraissues macro is fine since it displays the table but why is it empty ? (Yes, the actual table in JIRA is populated with current issues.) Any idea?
Posted by pat pitou at Jan 17, 2006 15:47
From above:
Valid columns are key, summary, type, created, updated, due, assignee, reporter, priority, status and resolution
Posted by amcclain at Jan 17, 2006 15:50
Did you ensure that the JIRA issues in question are readable by Anyone (the "anonymous" user). Another option is to pass a username/password through the URL. This is the "authentication" issue referenced above.
Posted by amcclain at Jan 17, 2006 15:55
Fixed! It displayed no "error rendering macro" but instead just an empty table, which led me to believe the authentication was not needed. But it now works fine with proper user/pswd. Tks!
Posted by pat pitou at Jan 18, 2006 16:07
Any chance you guys could fix the requirement that we have to give the login/password on jiraissue? This seems SO unintegrated, and since both Jira and Confluence are your products, and since people have been asking for this for a year... Well you get the picture: Doesn't look very good.
Posted by greening at Feb 02, 2006 06:42
We would like this fixed also. We would like to avoid having to append username and password to the macro since authentication should take care of this
Posted by wmene@stanford.edu at Feb 07, 2006 19:10
Dan,
We are aware of the requirement to provide a better authentication scheme for the JiraIssues macro. Unfortunately there were other issues we had to prioritise in the past.
Please watch, vote for and comment on the issues regarding this topic on Jira [1]. We will definitely add this feature to Confluence in the future and a higher vote count will help pushing it on to the roadmap.
Hmm ok, well I guess I didn't think about it actually trying to render the macro when I put it in. But basically I followed the example of how to use the jiraissues macro, and appended the username and password to the url. And what you see where I say "My macro looks like this" is actually the error that I get.
Posted by michael.haydel at Feb 20, 2006 13:07
Can you put the macro you're trying inside a {code} block, so we can see it? Like this:
If you're getting DTD errors in the RSS macro, it must be because the macro is getting HTML back from the Jira url (the RSS feeds don't include a DTD). The two main reasons I can think of are linking to the HTML view (which you're not) and permission problems (which I can't verify).
Yeah, actually I fixed it. It was an ID 10 T error. I did need to append the username and password, but originally I was doing it like so:
"...decorator=none*?os_username=..." when it should be "...decorator=none&*os_username=..."
Problem solved. Thanks for the help though!
Posted by michael.haydel at Feb 23, 2006 14:48
Is it possible to use the confluence jiraissue macro with the jira wiki renderer?
Posted by melvin12harmon@yahoo.com at Mar 06, 2006 16:18
Do you mean you want a list of Jira issues inside the description of an issue in Jira?
Unfortunately, at the moment, the jiraissues macro is heavily reliant on Confluence functionality, so it wouldn't work within Jira without significant modifications.
Perhaps you could consider writing a corresponding plugin for Jira? If you don't have the technical skills, try asking nicely on the jira-dev mailing lists – maybe someone there can help you figure it out.
Posted by mryall at Mar 06, 2006 17:29
Is the source to this plugin available?
I think I have the tech skills, but I'm not sure I have the time so I'd like to scope out how long it might take.
Posted by melvin12harmon@yahoo.com at Mar 07, 2006 11:41
Yep, it's included in the Confluence source code.
confluence/src/etc/plugins/jira3
Posted by mryall at Mar 07, 2006 23:37
You can also find it in the Developer Network Subversion Repository:
If you'd like to modify this macro and contribute your improvements back to the community (and perhaps, eventually, the product) then contact me and I can give you write access to SVN.
Posted by jnolen at Mar 08, 2006 13:21
It's really easy to add fixfor to the JiraIssues Macro. I really needed the column, and spent about 45 minutes enabling it. (The majority of that time was setting up my environment to be able to build the plugin). The process is two step, and should work for the field of your choice:
Then, edit jiraissues.vm. Find the section that sets the table headers (look for <th style="text-align: left;">). I put Fix For between Res and Created as such (my additions marked by ->):
Then, find the section where each item is rendered. This code is a little more difficult because there may be a collection of fixfors if your jira supports that. In between the section that renders the resolution, and the one that renders created, I added the code below (my additions marked by ->):
Posted by melvin12harmon@yahoo.com at Mar 08, 2006 18:33
They're in the 'atlassian-renderer' project, package com.atlassian.renderer.macro.macros. This project is included in the Jira source distribution. (It's in Confluence too, but possibly a different version.)
Posted by mryall at Mar 08, 2006 23:26
When an issue is in a state attached to a custom status the status' icon doesn't display correctly.
The Html looks like:
<img src="$icons.get( $item.getChild('status').getValue() )" alt="Ready for Production"
border="0" />Ready for Production
Posted by donna@atlassian.com at Apr 14, 2006 12:46
Just what I needed. thanks -m
Posted by melvin12harmon@yahoo.com at Apr 15, 2006 06:36
In our environment, each user has an X509 cert installed in their browser authenticating them to individual applications on our network. I believe that our Confluence and JIRA instances are maintained separately. Also, we are not allowed to install a certificate in the Confluence instance that can be recognized by the JIRA instance. We must have the user's identity, in Confluence, supplied to JIRA and it must be doable through the macro.
Posted by jens@atlassian.com at May 29, 2006 03:03
Dear Donna,
I met the same problem as Melvin, the difference is that I've translated those Issue Types, Priority names and so on into Chinese. Any suggestion?
Thanks in advance!
P.S. I've configured the JIRA Issues Icon Mapping in Confluence, and I've tried to Map both the English name and the Chinese name of those Jira entities, it doesn't work. If I removed the translation, those icons can display properly.
Posted by jele at Jun 29, 2006 10:21
Unfortunately, this is a known problem with the Jiraissues macro. You can vote or comment on this issue to help us prioritise it.
Posted by mryall at Jul 09, 2006 23:52
Matt,
Thank you for your advice, I've voted and added a comment on that issue.
Posted by jele at Jul 17, 2006 02:00
Hi,
I succeeded in getting this to work and it looked GREAT! I then enabled LDAP for password verification and now,... if you click on a JIRA task, it stops saying you have to log in!? I added a generic user 'confluence' to LDAP but to no avail, Jira still expects the user 'confluence', or anyone, to log in.
I am doing something wrong or have I missed a step?
Cheers
Posted by tony.randall@combined.com.au at Jul 17, 2006 19:59
I don't understand why, but, we found a solution to this. By using 'localhost' (rather than the full URL) it works fine. This made me think a proxy might be involved... but our IT dept confirmed that we are definitely not using a proxy server...? Well, works now, anyhow.
Posted by zbeckman@bosslogic.com at Aug 25, 2006 16:19
Can jiraissues filter based on assignee?
It would be useful to provide users with a list of jira issues assigned to them within the context of a wiki page.
Posted by nnewhard at Oct 25, 2006 20:11
We should have a "title" parameter for this macro, it would just be some text that we want to display as the header in the table. Thus, we can include in the header of the table itself some text which explains what issues are called in the table.
e.g.
- title=Open Issues in Component blahblah with Priority High and Status Open
Posted by parmar.vikram@gmail.com at Nov 21, 2006 03:34
Hello - I think there is a problem with the parser for the password argument. I tried this to no avail with a complex password, with symbols, then when I switched to a very simple password, it works with the specification above.
FYI
Regards
Rick Cogley
Tokyo
Posted by rick.cogley@esolia.co.jp at Dec 17, 2006 01:11
Hi Rick,
This occurs when the '&' character is part of your password.
Agnes.
Posted by agnes@atlassian.com at Dec 17, 2006 20:46
However, note there is a bug that disallows you from having a complex password. I discovered it because I had various characters and numbers, plus the & symbol, and it would never work. When I changed my password to something very simple and retried, it did work. Atlassian Agnes told me:
Posted by rick.cogley@esolia.co.jp at Dec 20, 2006 07:05
I just upgraded my JIRA install to 3.7 and now all my jiraissues all give the following error:
Error rendering macro: java.io.IOException: Error on line 6: The entity name must immediately follow the '&' in the entity reference. rssoutput-271132023.txt
Anyone else get this?
Posted by jshap999 at Jan 03, 2007 07:47
Ok got past that by updating my url but now the images don't show up. Looking at the properties of the image it appears that the image path is being tacked onto the full url
Do you mean the icons do not appear when using the jiraissues macro? I've tried replicating the problem with and without the full image path and both seem to work fine on my side.
It would be helpful if you can also attach a screen shot of the displayed issues with the missing icons (image).
Regards,
Mei
Posted by meiyan.chan@atlassian.com at Jan 04, 2007 03:53
Hi Justin,
can you open an issue at support.atlassian.com. Please attach a copy of your log file when the IOException occur. Can you also give more details about your macro configuration.
Thanks,
SaM.
Posted by sleberrigaud at Jan 07, 2007 19:40
Do you know how to add custom fields to the JiraIssues Macro?
Posted by vitalijs at Jan 10, 2007 08:33
I changed the jira3.jar file to the older rss format one as per the instructions above to use my older version of Jira.
I get the following error in confluence:
Looks like the bucket/util is no longer used? How do I procede? Upgrade Jira?
Posted by ewhite@statcom.com at Jan 10, 2007 12:34