Forums

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

How to query data using the project key

Kamor, Hollee C. December 14, 2023

UPDATE: I think I figured it out :)

I am trying to compile data on several projects; however the project names keep changing and breaking the JQL.  Is there a way to query current/historical data, using their project key instead?  When their project name changes, the key has stayed intact - so I am thinking of using that for dashboard reporting.

Example:  Project Name = Network Security, KEY = NETSEC

I have tried various JQLs as a starting point, including:

key= NETSEC (and inserting "" and () with no luck)

key in NETSEC (and inserting "" and () with no luck)

 image.png

I've attempted to use Project Key also, with no luck.

 

Once I can access the data with the key, then I will build on the JQL, utilizing the sprints and other data I am looking for.  I just cannot determine the foundation.  The previous JQL would be:  Project in Network Security (and then I add the other items I want to see)

 

Thank you for any help!

1 answer

1 accepted

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 14, 2023

Hi @Kamor, Hollee C. 

Have you tried this one?

project = theProjectKey

And this reference may help for future searches: https://support.atlassian.com/jira-software-cloud/docs/jql-fields/

Kind regards,
Bill

Suggest an answer

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

Atlassian Community Events