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; } } }

Select by JQL only from Company-managed software

Ricard Renalias

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.

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.

Thanks in advance,

Ricard

Accepted answers

All comments

John Funk

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/#/

Ivan Lima

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.

Ricard Renalias

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)

Ricard Renalias

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.

John Funk

Agreed

Bill Sheboy

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:

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.
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

Lauma Cīrule

Hi @Ricard Renalias,

From an eazyBI perspective, I can agree with using Project Category - this functionality is available already to select and import issues from a particular category of projects. JQL would also work, but as I see, there is no such JQL filter for now.

I added the grouping by project type to ideas in the eazyBI backlog.

I would also like to add that for next-gen projects, eazyBI also creates a secondary hierarchy By Name that groups values in dimensions first by name and then by project-specific values, thus allowing to analyze all issues with the same value across all next-gen and standard projects. See more https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/jira-core-measures-and-dimensions.

Lauma / support@eazybi.com

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql

eazybi