Ignacio Pulgar Expert

Hi @Maxim Alter , Please, try issuesInEpics() instead: issueFunction in issuesInEpics("key in (FOO-1, FOO-2, FOO-3)") Hope it helps.

Exactly. It's a little bit counterintuitive, but assignee != username does not include issues where that the assignee field were empty. The same is true for any other fields. Regards

+1

Hi @Robert Tedge , Provided that the number of custom fields has an impact on Jira instance's performance, I'd prefer to use a Sort Automation in Structure this way: * Click on the + button next to Automation > Sort > Attribute... * In the Order by dropdown, select Formula... * Insert this formula and click on Apply…

Hi @Arjan Helmer , Another use case of a global looping transition worth mentioning: Locking an issue to prevent concurrent editions. Have you ever edited an issue's description and seen your changes disappear because another user was also editing it at the same time? While this problem can be solved by third party apps…

Thank you, @Diego Cela ! :)

Hi @Anne Loomis , Maybe you have an active filter which does not return any issues from that folder. Please, check if you have any active transformations, like in this picture: Those transformations are only applied when the Automations button is not selected, and that's why they enter the scene when you unselect it. You…

Hi @Arjan Helmer , I'll be happy to help and have already booked a time in your calendar. Best regards, Ignacio Pulgar

Hi Jad, That JQL is dynamic. The JQL you need is, in example: status changed FROM Submitted TO Accepted DURING("2020/12/25 09:30", "2020/12/25 13:30") More info about the changed operator. Hope it helps.

Hi @Sergio Renzo , First, I'd like to apollogize, as I said I was going to write an article explaining how to build a dynamic dashboard. I promise I will write it soon and post the link here (I will create a Jira issue to have it on my backlog ;) ). Best regards

Hi @Yuta Nagano , It's a good question, as the calculations for obtaining velocity are not intuitive. First, let me clarify that Jira does not assume any conversions from Story Points into time. The Velocity Chart is calculated by taking the average of the total completed estimates over the last several sprints. More…

Cool solution! Upvoted! By the way, it would also be great if it supported a given calculation, like Value / Story Points, or something like that. Promising app. Will test it soon! Regards

Hi @Erin Coffey , Story Points is a field that initially, by default, is configured to be usable just in issues of type Story on multiple versions of Jira (not sure if all). Therefore, adding the Story Points field won't actually be enough for showing the field for other issue types. However, you set more issue types to…

Of course, once you have to build a new report for the next version, you just have to change and save just your version report filter, and just copy and paste the new data into a new Confluence page. You may need to apply some manual adjustments to the pasted content, but it will save you tons of time when creating this…

You are welcome, @lukasz_switaj :) I'm afraid there's no free version of that addon for Confluence Cloud, and I do not know of any other alternatives. I think this kind of goal would require to develop your own Confluence Cloud app for getting something like that, although I'm not 100% sure of that. Which I would recommend…

Of course! You are always welcome! :)

Hi @Sreekala Dande , For not allowing the creation of clones to Anyone, you need to add a property which allows the creation of clones just to users with either a role in the project, or a jira group. Probably, your use case should be better covered with roles, so this is the property you need to add on all statuses of…

@Jack Nolddor [Sweet Bananas]Thanks for coming to my rescue! ;D

Interesting goal! This seems to be a question where @Jack Nolddor [Sweet Bananas] (the best developer of Atlassian apps I know) may help! :)

Hi @Oleksii Skachkov , I'm not sure if this could be of any help: https://stackoverflow.com/questions/14228912/how-to-convert-list-to-json-in-java By the way, may you elaborate on why do you need to generate a JSON? I mean, is that the goal? Or is it just a way to access issue data in a way you are more comfortable with?…

Hi @lukasz_switaj , There's no way of doing so natively. On Server instances, there's a workaround by using the Confluence Source Editor free app, as it allows to search & replace the fixVersion value. On Cloud instances, I've just seen this Source Editor for Confluence app, which seems to be quite similar to its Server…

Hi @Kim Christensen , I suspect a Jira Admin could have disabled sub-tasks in your Jira instance. May you enter the following URL and check if that's the case? https://YOURSITE.atlassian.net/secure/admin/subtasks/ManageSubTasks.jspa Hope it helps.

Hi @PhilSpo , As a side note, while this part of your query contains absolutely correct syntax: (category = "Customer Projects" OR category = "Shared - Customer Project Workflow") I'd recommend this alternative but shorter way to retrieve the same issues: category in ("Customer Projects", "Shared - Customer Project…

Hi @Todd Hanson , Are you on a Jira Cloud instance? If so, I regret to say that's a known issue tracked in JRACLOUD-72667. Regards

Hi @rbk , If I'm understanding you correctly, then I think you might need ScriptRunner's linkedIssuesOf() JQL function. ie: issueFunction in linkedIssuesOf("project = PKEY AND type = Story", "relates to") Please, note that ScriptRunner is a third party app, so you might or might not count with it installed in your Jira…

Thank you, @Mario O.G ! I'll never forget how you showed me the power of Structure formulae, master! :) From that point on, I've studied Expr language and used it a lot! It's amazing what can be done with this tool and a little bit of imagination. Best regards! Ignacio

Hi @Rekha Manjunath , The option to disallow exporting structures is not present in Structure's global configuration page. However, there are a couple of workarounds for achieving what you need, although neither of them are elegant or specially recommended. I've tried these methods with Jira 8.6.1 and Structure 6.0.…

Hi James, Sorry to hear that! An the workaround suggested in that issue is even more complex for end users... Mmm... as you count with ScriptRunner, you may create a a Scripted Field which retrieved the number of issue links. Fortunately, the Adaptavist Library counts with such a scripted field:…

Hi @James Croft , There are no extra JQL functions that will get you closer to your needs, even in ScriptRunner or JQL Booster Pack. However, there's a workaround for helping getting issues with two or more issue links: * Execute the JQL query you've got in the Issue Navigator and save it as a filter. * Modify the columns…

Just read in the Structure Cloud Roadmap page linked by @Egor Tasa [ALM Works] that the Filter Automation has recently been included. If that's the case, then it will be feasible removing the duplicates from the second level instead. @Parrish Pope, if you would like to remove the dups from the second level, then you could…