Rachel Wright Community Champion

“Oops!” “Oops! I can’t believe I did that!” “Oops! I can’t believe I did that in PRODUCTION!” Remember that time you prevented everyone’s progress after a permission change? Or the time you broke the most used workflow just before a big deadline? Or you made a seemingly simple change that brought the entire server down?…

In a previous article, I showed some screenshots from my Jira Code, Snippet, and Example Library. I use Confluence to store my frequently used JQL queries, automation rule smart values, and other reusable snippets so I can find them quickly and cut and paste them wherever they are needed. In this multi-part series, I’ll…

Sub or Nested Queries A subquery is a nested query or a query that contains a query. For example, create and save the following filter: Filter name: Support Spaces JQL: project in (HELP, SUPPORT) Then, append additional clauses to the filter’s name or ID. filter = “Support Spaces" and assignee = currentUser() filter =…

Here are some time and status related examples. Specify time using m for minutes, h for hours, d for days, or w for weeks. 2400 minutes is the same as 40 hours, 5 days, or 1 work week. Use any of those formats. (Ex: 2400m = 40h = 5d = 1w) Use dates in the format: yyyy/MM/dd yyyy-MM-dd Add hours and minutes in the format:…

Common use cases Here are some single and multi-clause queries I use often. Example JQL Use Assigned to me assignee = currentUser() AND statusCategory != Done ORDER BY created ASC Items assigned to me, that need action, ordered by oldest creation date (ascending order) Reported by me reporter = currentUser() ORDER BY…

Concept Relates To Application Type Jira Work Management, Jira Software, Jira Service Management Deployment Type Jira Cloud What is shown? The calendar view in a software project in Jira Cloud. Visit: Jira project > Calendar What can we learn? In May 2024, Atlassian announced that Jira Software and Jira Work Management are…

Jira Software Use Cases Here are some helpful queries, formats, and functions to use for software development. Estimation Jira has two built-in estimation methods. Stories often use story point estimates. Tasks often use time estimates. Examples originalEstimate is not empty remainingEstimate > 1d timespent > 8h updated >…

I know this is a Jira series, but here are some helpful Confluence queries for your snippet library. Top Confluence Queries Simple search Confluence has robust search capabilities like Jira, but instead of querying specific fields, you’re querying for keywords in content. Use the search bar at the top of any Confluence…

Sometimes you only know a small amount of information, like a keyword or a key phrase. Use a like search to find items containing those words. Like examples Use the tilde (~) symbol to perform a like keyword search. summary ~ "website" description ~ "website" comment ~ "website" Use the text clause to search for keywords…

Common user-related standard fields include: Assignee – the user expected to take action. Reporter – a requestor or single point of contact. The reporter can change through an item’s lifecycle. Creator – the user who created the item. The creator never changes and this information is useful for auditing purposes. Watcher –…

Let’s get started with some easy queries that build on each other. Start with one clause, test it to make sure it returns the expected results, than keep adding additional clauses until you get to the information you’re looking for. Single clauses Items in spaces Items in one or more spaces. Use a space’s key (Ex: DEV) or…

Introduction Before we get to the JQL snippets, here are some terms and syntax information to know. Definitions Query – a question Example: How many bugs did the Marketing team report this year? A query is another word for a question. Each time you use a search engine, you’re querying the internet for web pages. When you…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? Jira’s “field helper” function helps find missing fields and troubleshoot causes. Visit: Jira > browse/[ITEM-1234] What can we learn? A field can…

Concept Relates To Application Type Jira Work Management, Jira Software, Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Server, Jira Data Center What is shown? A default workflow shown in diagram mode Visit: Admin > Issues > Workflows What can we learn? Here’s a workflow created by a template in Jira…

It’s my 12th Atlassian Community Leader Anniversary! I remember when I first logged in, Not sure where to start or where to begin. But a forum full of helpful folks, Gave me purpose and gave me hope. I’ve learned to tackle Jira challenges with grace, And help fellow admins, no matter the place. From Server migrations and…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? A diagram of a screen scheme used to determine fields displayed for different work types. Visit: Admin > Work items > Screen schemes (Cloud)Visit:…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? An example create screen containing a sub-set of fields displayed on an example edit/view screen. Visit: Admin > Work items > Screens…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management Deployment Type Jira Cloud What is shown? The “Switch sites or apps” function in Jira Cloud. Visit: Jira > Grid icon (Top left) What can we learn? If you have access to multiple Jira Cloud sites, use the switcher…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? Using JQL to search for a deleted item. Visit: Jira > Filters > Search work items (Cloud)Visit: Jira > Issues > Search for issues (Data Center)…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? A flow chart for troubleshooting Jira access and permission problems. Visit: Admin > User management > UsersVisit: Admin > System > Pemission…

A better navigation for Jira Cloud is coming soon! While we wait I thought it would be fun to dig up some old screenshots and take an unofficial and outsiders look at how the Jira interface has changed over the years. When Jira was first released in 2002, it was purely for software development. But these days, all kinds of…

In my last article, I shared an easy way to find what you’re looking for by changing parameters in URLs in your browser’s address bar. This time, let’s explore accessing Jira information using REST API URLs. What is a REST API? Briefly, REST stands for representational state transfer and API means application programming…

Concept Relates To Application Type Jira Service Management Deployment Type Jira Cloud, Jira Data Center What is shown? Email-to-request management settings in a Jira Service Management project. Visit: Project settings > Email What can we learn? In JSM its easy to accept requests submitted via email. Simply create a custom…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software) Deployment Type Jira Cloud What is shown? The Layout page in a Jira project’s settings area to set visibility and field order. Visit: Project settings > Work types (expand sidebar link) > Layout What can we learn? After adding and removing…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? An item marked “Confidential” using a Work item security scheme in Jira Cloud. Visit: Admin > Work items > Work item security scheme (Cloud)Visit:…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? A JQL query using the “CHANGED TO” and “WAS” search operators. Visit: Jira > Filters > Search work items (Cloud)Visit: Jira > Issues > Search for…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management Deployment Type Jira Cloud What is shown? An example Jira work item with custom fields and tabs in Cloud. Visit: Jira > browse/[ITEM-1234] What can we learn? While some field ordering and display settings are…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? A sample workflow to illustrate where to place the most important part: a resolution. Be sure to set a resolution when an item is resolved and…

Concept Relates To Application Type Jira (Jira Work Management and Jira Software), Jira Service Management, Jira Core Deployment Type Jira Cloud, Jira Data Center What is shown? A custom field with a context to enable different selection values for different uses. Visit: Admin > Work types > Fields (Cloud)Visit: Admin >…

One of my 2024 goals is to consolidate the many tools I use each day so I can improve my focus and automate processes. Here's an easy win: I'm using my chat program as a "home base" for all Jira alerts and notifications. I use Slack to get select Jira updates about important issues I'm interested in right now. It's a huge…