Hello
What I want to do:
I want to filter jira items (only task) to a specific jira board based on the confluence page on which they where created.
Long story:
Our quality items are listed on 1 page in confluence per project(same page content). If the team decides they want to work on one or more items they have to create a task item in that confuence page, the item is then created in jira and I want it to appear in jira on a specific quality items board, so they can be easily followed up separately.
What I already have:
I have the confluence page, I have the jira board, I have the tasks created,I can't seem to find a way to do the filtering.
What I tried:
- It is possible to filter with standard jira filtering on who created the item, but I don't want that restriction, it must be free to use for the whole team, and I only want the items coming from that page so I need a second key so I don't get the other items they created. The second key could be a component, but I don't want them to after creation open jira and fill in manually the component, that will ccertainly be forgotten.
- so I looked into scriptrunner, which we have, and I thought it should be possible to create an advanced filter with "issueFunction in linkedIssuesOfRemote…”, after a few hours of searching I had to conclude it didn't work, the function isn't availbale in our scriptrunner, and in the documentation I found also that this function isn't available in scriptrunner on jira cloud :(
- I also looked into using a filtering based on the link I get when there are more than 6 items created on a page, this gives me something like this:
" issue in (issuesWithRemoteLinksByGlobalId('appId=d8838d7a-XXXa-3881-XXX-7223b5c1f26a&pageId=2067693XXX'),issuesWithRemoteLinksByGlobalId('appId=2abdb568-0fde-3d7d-XXX-d3dab3d5c776&pageId=2067693XXX'))) and issuetype!=10000" (replaced with XXX for security) then I see the appID differs for each task, so this is to specific,though this works and shows the correct items, but I don't want it specific on the items, I just need the filter on pageId, so newly created tasks are also shown.
So now, time is ticking, I really need to start to finish this, but I don't know how to fix this anymore.
Did someone encounter the same need and has a solution?
Hi @Petter Gonçalves
Yes, that's what I want to do.
Thanks for creating the feature request
We already looked at the custom issue type, but since there is a serious impact there we decided not to go in that direction and look for someting else.
Choosing the issue type isn't a problem for our teams, that they can do directly on creation of the item in confluence (I meant the use of a component on the jira issue, for components you have to pass via jira)
Most important:
I found a sort of workaround (if I may say so) yesterday that seems to work, though I don't know if it is a stable way of doing things. I'll explain:
I looked again at using the filter based on the confluence linking to jira:
(I already looked at it before and thought it wasn't working because every item was specified separately, but it isn't the case, the filter seems to work based on just the three appId references with the pages, and extra items he just takes along
If on your confluence page you create more than 5 items (for example 8) you can click at the top of the page on "5 jira links" and in the menu that opens you click on "View 3 more in System JIRA"
Jira will open, and the filter that is used to display my items there, I can reuse him as a filter.
- If I add items in confluence, the filter will also filter these new items in jira
- If I take this filter and modify all the page refenreces in it, then I can use him to set a jira filter for another page that has less than 5 items
So, this seems to be working, although I only tested in small numbers of issues.
It seems too easy to rely on, can I surely use it like this or are there problems that can arise which I am overlooking?
Hello @NatasjaP
Thank you for reaching out.
I spoke with a colleague from the Confluence Support team and took a further look at the JQL request generated by the issues link in the Confluence page. Indeed, you can rely on that JQL to return the issues from a single page.
Basically, the appId is the connection link between your Confluence and Jira macro (one for each product), while the Pageid is the reference to the specific page, both mapped by the function issuesWithRemoteLinksByGlobalId.
Please, let us know if you need help with anything else.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @NatasjaP
Thank you for reaching out.
Per your description, I understand that you would like to restrict a specific board to display only the issues created from a specific Confluence page. Is that correct?
Unfortunately, I'm afraid we have bad news and your goal is not achievable today using only Jira inbuilt features. We understand how this functionality would be useful, so we created the feature request below to allow the implementation of this scenario:
Provide The Ability to Search Mentioned Confluence Page using JQL
Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.
Additionally, we have another feature request to allow the identification of issues linked to Confluence spaces by using Jira Automation:
Add support for remote issue links
With the feature above, you would be able to use automation rules to identify the issues created from Confluence pages and automatically set any values to include them in your board filter.
For now, I believe the best approach to achieve something similar to what you need would be by creating a custom issue type (e.g: Created from Confluence) and instruct your team to use that request type when creating issues from the Confluence page, although we understand that you don't want to rely on your team to set the correct issue type when creating a new issue.
Another option would be by creating your own script/app (If you/someone in your team has some experience with Scripting) using the following REST API to identify your issues with linked Confluence pages and properly edit them:
GET /rest/api/3/issue/{issueIdOrKey}/remotelink
Let us know if you have any questions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Petter Gonçalves - With regard to the request, , allowing for the identification of issues linked to confluence spaces, did that get anywhere? I can't access the link as Atlassian notes I don't have access to "Codebarrel", but reporting on tasks created by space is exactly what I'm seeking to do.
Otherwise, is there a way to leverage @NatasjaP 's concept here to provide JQL that filters on the site/space rather than the page?
I reproduced the example and found that you don't need all of the statements included in the "X Jira Links" filter. Even though the appId is different for *some of the issues noted in that filter, the page is the same. If I just use one of the appId's and the page in a JQL filter, I get all tasks created on that page. Essentially reducing the following (ID's were altered to protect the innocent):
issue in (issuesWithRemoteLinksByGlobalId('appId=2236ab22-50b2-365f-9020-3251ddfcd2ed&pageId=2244568259'),issuesWithRemoteLinksByGlobalId('appId=664b1c3-22fc-3e63-8fa8-ac66903edd1c&pageId=2244568259'),issuesWithRemoteLinksByGlobalId('appId=db38e9g1-k22b-3fb0-b222-6e912c40129d&pageId=2244568259'),issuesWithRemoteLinksByGlobalId('appId=2236ab22-50b2-365f-9020-3251ddfcd2ed&pageId=2244568259')) and issuetype!=10000
down to this
issue in (issuesWithRemoteLinksByGlobalId('appId=2236ab22-50b2-365f-9020-3251ddfcd2ed&pageId=2244568259')) and issuetype!=10000)
Gives me the same 7 issues created on that page. I tried omitting the pageId from the statement and it breaks, same thing if I omit the appId. Is there a function I can use to combine the appId with all pages in a site, to finesse this out of JQL?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.