Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Create an exclusion criteria for a certain project status

I have created a custom filter for all 2021 projects for my team from which I want to exclude projects with a status of "cancelled" which were created in 2020. 

 

Thanks. 

2 answers

Hi @Prexa Patel 

I assume you are referring to the workflow status "cancelled". If so, then you could just add to your existing filter:

AND status != cancelled AND createdDate >= startOfYear(-1)

HTH,
KGM

Thank you Kristjan - the filter should be on the actual Project status field as cancelled. i am unsure why at my organization the workflow status is marked as "done" vs. actually cancelled. something i may need to research and work through to update. 

I used above formula on project status field and does not seem to work as it excludes all cancelled projects. 

@Prexa Patel  Oh. When you say "cancelled projects", do you mean the Project Category is cancelled?

@Kristjan Geir Mathiesen - Servado as you can see in the above screen shot the 6th field is Project status. 

Thanks @Prexa Patel  Wow, I'm stumped. Sorry about that.

Hi @Prexa Patel 

Jira focuses on the issues not on the projects containing them, and...JQL is not a SQL.  Putting those ideas together I do not see how you could use JQL to find just projects without the associated issues (and the field values of interest).

You could investigate the REST API to check the projects directly, although I did not see that project status attribute being returned in the methods.

Or, you could investigate the marketplace add-ons to search for things to support this type of query: https://marketplace.atlassian.com/

Best regards,

Bill

@Bill Sheboy - thank you for the above. I was able to create a filter to aggregate all projects for 2021 for my team without focusing on the issues - here is the query - project = PDPMO AND "Project Status" != Cancelled AND due >= startOfYear() ORDER BY due ASC 

 

@Kristjan Geir Mathiesen - Servado @Bill Sheboy as you can see from the query above - i am able to exclude all cancelled projects. The list however contains projects created in 2020 and cancelled in 2021. 

 

The goal is to create a filter that includes all projects with a due date in 2021 and exclude cancelled projects created in 2020. If a project was created and cancelled in 2021 i want to be able to include it in the filter. 

 

hope this helps. 

 

Thanks,

Prexa Patel

Ah, now I believe I understand better...

Those project fields are not in my instance, and so I hypothesize that they are custom fields in your instance, either created by your site admin, by a marketplace addon product, or perhaps they are in a version of Jira cloud above standard?  Can you confirm any of this?

If so, you just need to identify the available fields and then you should be able to create your query.  For example, is there a field for "Project Created" that you may query to answer your need?

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you