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

Select by JQL only from Company-managed software

Hello,

in my company we use the two software JIRA project types:

  • Company-managed software (Classic projects): For most of projects that require to follow business investment.
  • Team-managed software (Next-Gen projects): For all other cases.

As Team-managed software are created by anyone in the organization, I need to find a way to get data only from "Company-managed software" projects.

 

ProjectTypes.png

It is very important for me specially when I import data to EazyBI as I want to avoid the noise from the "team-managed projects" (custom fields, workflows, states...)

 

Is there any avaliable field that I can use from JQL to select only issues/data from "Company-managed software" projects?

I have seen that there is a field called ProjectType but in this case I cannot choose between Company-managed or Team-managed projects as it is the project type manually selected in the project properties page.

JQLProjectType.png

Thanks in advance,

 

Ricard

 

3 answers

0 votes
John Funk Community Leader Jun 03, 2021

Hi Richard - maybe you could use the project category? 

Otherwise, I think you will need to open a support ticket with Atlassian.

https://support.atlassian.com/contact/#/

Thank you John.

I can use project category, but this field is useful for distiguish the organization project type (software, it...) and It would be great if I do not need to create new project types to do so.

Like # people like this
John Funk Community Leader Jun 03, 2021

Agreed

0 votes
Ivan Lima Community Leader Jun 03, 2021

Not that I'm aware. I came across a similar question here where you can find additional insights on that. An open suggestion is linked to the question (JRACLOUD-71674) that you can vote on and add yourself as a watcher to receive notification from now on.

Thank you Ivan

As the request is related to the JQL instead of the visibility of the project type I have also add a new suggestion to JIRA (JRACLOUD-76763

Like # people like this

Hi @Ricard Renalias 

In addition to the suggested improvements to make this information searchable out-of-the-box for Jira, there are marketplace addons which allow searching the Project's Entity Properties.  One of those properties is Style, and it indicates "classic" or "next-gen".

If you do not want to purchase an addon, a couple of work-arounds are to:

  1. Manually call the REST API function for projects, and use a regular expression to parse out the ones you want, "classic", put those project ids into a CSV list.  Then use that to filter your data query.
  2. Automate #1 above with an automation rule, having it send you the CSV list of projects on your desired cadence.  I did this a few months ago as an experiment and it worked well.

Best regards,

Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Asked in Jira Service Management

JSM June ask me anything (AMA)

Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...

270 views 13 14
View question

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