Laurie Sciutti Expert

Hi @atla pani and welcome to the Community! Sprints are stored in the DB as an ID (numerical) rather than as text so when you report on it, even though the sprint "name" may be the same, they are still considered different sprints. This is by design so that teams in one project can name their sprint the same as a team in…

Only been on one and that was over 30 years ago (I'm due for another). At that age, my favorite part was access to food anytime. haha While I'm sure that would be a favorite now as well (booze too 🍹) I think now I would really just enjoy the peace and tranquility of being away from everything and everybody. There's just…

Excellent! I'm so happy this helped you, @Zachary Sharpe !

Hi @Susan Bohanon and welcome to the Community! Not sure what menu you are referring to but restricting access should restrict everywhere.

Hi @Ibrahim Hassan ~ you can find the Server ID here (yes ~ it is the same as the Jira Server ID): https://<jirabaseurl>/secure/admin/views/XrayLicenseConfiguration.jspa

Hi @Bob Hartmann and welcome to the Community. Echoing @Michel Neeser ~ not exactly sure what you are asking for since you don't provide the hosting type (Data Center or Cloud) but the quickest and easiest way to learn would be to set up a new free instance on Cloud (Michel provided the link). Another option would be to…

Hi @[deleted] !

Hi @Vasanthakumar V ~ if I understand correctly, you would want to use the OR clause (use the pipe | instead of the ampersand &) for the ALLOW inclusion, unless the requirement is to include those members that are in BOTH groups. Allow portion: (|(name=*-XYZ-*)(name=*-AZU-*)) Block portion:…

🎶

🦃

Hi @Patrick Schneider ~ we use the Centralized license visibility add-on for this (it's free!): https://marketplace.atlassian.com/apps/1220745/centralized-license-visibility?tab=overview&hosting=server HTH

Hi @Michael Kornatzki ~ the i18n property key allows strings: https://developer.atlassian.com/cloud/jira/platform/modules/i18n-property/ Are you getting a particular error?

👋🏻 Hi @Raj G and welcome!

Hi @[deleted] and welcome! If you use ScriptRunner, you can use the issueFunction in portfolioParentsOf(Subquery) function. https://docs.adaptavist.com/sr4js/8.2.1/features/jql-functions/included-jql-functions/portfolio#portfolioParentsOf 

Hi @Ali Jacobsen ~ try this: issuetype = Epic AND status = "In Progress" AND not issueFunction in linkedIssuesOf("Sprint in openSprints()", "has Epic") AND not issueFunction in linkedIssuesOf("Sprint in futureSprints()", "has Epic")

Hey @Kevin Dickson ~ I agree with @Joseph Chung Yin but if that isn't working for you what you might try first to simplify that JQL is to use statusCategory != Done (assuming all the status values listed are in the "To Do" or "In Progress" statusCategory) instead of the status in ("In Progress",...). That would clean it up…

Thanksgiving is my favorite holiday. Mom's one-of-a-kind sausage stuffing and pumpkin pie still cannot be topped to this day. She passed in 2007 but Thanksgiving always makes me feel close to her since it was Mom and Dad who had the family over every year. I cherish every Thanksgiving memory. 🦃

The wood-paneled station wagon. Yes....we had the "privilege" of owning one of those. SO UGLY. lol

@Dan Breyen ~ Mr. Jingles!! HAHA. Great movie...

Hi @Mathew Lederman ~ try this: project = RQM and statusCategory != Done and issueFunction in hasSubtasks() and not issueFunction in parentsOf("project = RQM and statusCategory != Done")

👏🏻

Hi @Darius Tanz ~ do you have a question?

Ah. You can't combine those in the Issue Statistics gadget, nor can you use the statusCategory statistic. I checked the 2-dimensional gadget and that doesn't allow statusCategory either. I'm not aware of any OOB that do that but I do know that there are plugins that do. I use Custom Charts for Jira HTH

Fun! I think I actually HEARD that last meme. Very creative post, @Halyna Kudlak _SaaSJet_ ! 

Hello @C-Robert.Gill ~ If I understand correctly, you want to use statusCategory: statusCategory = Done

If memory serves, I have one with a cooking show I did as a project for my Japanese class in college -- at least I hope I still have it tucked away somewhere. That would be a riot to watch again. We made chicken teriyaki and even had a commercial for Sapporo beer - hahaha. If I do still have it, I don't have a player…

Hi @Tammy Shellenberger ~ you should be able to insert the "Jira Issue/Filter" macro on a Confluence page with the following JQL (plus, include the project or projects to narrow the results): fixVersion in (releasedVersions(), archivedVersions() ) HTH

Sorry to hear that, @Mister Femi . If you wouldn't mind accepting my answer I would appreciate it!

@Mister Femi ~ more accurately than my previous response: if you are looking for issues resolved within a date range specified in another date field (i.e. Target end date), I believe this would require a plugin (like ScriptRunner), which allows for date comparisons. If you use ScriptRunner, you could include something…

@Mister Femi ~ it should look something like this (depending on what your Target End Date field resolves to / is named in your JQL): Team = Atlas AND issuetype = Epic AND statuscategory = Done AND "Target end" >= startOfDay(-30d) AND "Target end" <= startOfDay("+30d")