nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL / Labels field / Isolating customer

Jeff Murray_nn3zi1

Hello -

I created this JQL however, I'm stuck. In the labels field there are other words besides CUST_customer name. I only want to see the CUST_customer name.

project = SF AND issuetype in (Bug, Story, Task) AND status = Done AND "Epic Link" = SF-423 AND labels "~" "CUST_*"

How do I correct this?

Thanks, Jeff

Accepted answers

Trudy P Claspill

Hello @Jeff Murray

I'm not sure that I understand what you are trying to accomplish.

Can you provide samples of issues with a variety of Labels values and indicate which ones you would want to see in your results?

i.e.

Issue key	Values in Labels field	In Results?
ABC-123	CUST_1234	Y
ABC-456	CUST_1234, Another_Label, And_another_label	Y (or N?)
ABC-789	Another_Label	N

Matt Doar_tzgiej

I recommend using a select list field not Labels for this. The Labels field searcher returns an issue and all its labels if any of the labels match the given string.

All comments

Trudy P Claspill

Hello @Jeff Murray

I'm not sure that I understand what you are trying to accomplish.

Can you provide samples of issues with a variety of Labels values and indicate which ones you would want to see in your results?

i.e.

Issue key	Values in Labels field	In Results?
ABC-123	CUST_1234	Y
ABC-456	CUST_1234, Another_Label, And_another_label	Y (or N?)
ABC-789	Another_Label	N

Jeff Murray_nn3zi1

Hi Trudy -

In your example, yes to the first one, no to the second and no to the third just like you have outlined.

Thanks,

Jeff

Matt Doar_tzgiej

I recommend using a select list field not Labels for this. The Labels field searcher returns an issue and all its labels if any of the labels match the given string.

Trudy P Claspill

Here is one more case to consider:

Issue Key	Values in Labels field	In Results?
ABC-2345	CUST_1234, CUST_ABCDE

Jeff Murray_nn3zi1

Trudy -

In that case, we want all of those starting with CUST_

Thanks,

Jeff

Hannes Obweger - JXL for Jira

Hi @Jeff Murray

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions.

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

The regex that I'm using is

^CUST_\w+(, CUST_\w+)*$

There's a few things going on here, but TLDR, it checks if CUST_<something> occurs one or more times, with no other text in between or around.

Once you've identified your issues, you can work on them directly in JXL (e.g., bulk edit them via copy/paste), or trigger various operations in Jira.

Hope this helps,

Best,

Hannes

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud