Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate records with same jira attribute in JQL

BRIDGET FLANAGAN
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 5, 2024

Is there a way I can remove records where multiple records are returned for the same jira attribute ID in a JQL query (like DISTINCT in SQL)?

1 answer

2 votes
Rilwan Ahmed
Community Champion
September 5, 2024

Hi @BRIDGET FLANAGAN ,

Welcome to the community !!

JQL's does not list duplicates in same query. It lists only distinct list. 

BRIDGET FLANAGAN
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 5, 2024

Hi @Rilwan Ahmed 
Thanks for the reply
I ment from a list of records returned from my query,  I would like to remove records based on a certain Jira attribute having the same value for more than one record.
e.g. from my query I have a list of records with the same attribute value (Known Issue ID) and I would like to return a list where the Known Issue is always unique.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events