Needed, thank you!

any news, please? truly would need it...

Search by Project Category was implemented a long time ago - https://confluence.atlassian.com/jirasoftwareserver0822/advanced-searching-fields-reference-1142432457.html#Advancedsearchingfieldsreference-CategoryCategory

You can do it like this:

category = "My category"

It was available in Jira Server 8.22.

To search by Project Type, you may use ScriptRunner Custom JQL function projectsOfType:

project in projectsOfType("service_desk") // or "business", "software"

See the docs for details: https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/projects

This would be super helpful

For those looking to filter by project category and project type, after searching for a while I manage to achieve this using JQL Booster Pack plugin.

https://marketplace.atlassian.com/apps/1218367/jql-booster-pack

This app comes with  categoryMatches() / projectsOfType() functions and they works like a charm.

Please add this feature

 +1 vote

@Marko Have you tried the app called JQL Booster Pack throught Atlassian Marketplace??

It includes the following JQL functions:

• projectsOfType()

• categoryMatches()

• ... and many more.

Kind Regards

@ Marko Isola

We were using "Metadata for Jira" on our Server instance. This was a great tool to add properties on project level and using them in JQL.
This app is for Data Center available too.

It's a real shame not having anything similar in the cloud anymore.
Filters with hard-coded project names is not a way to go.

I saw that projectType is available but I think it is only for Cloud. Would like to have it in Data Center.

+1 from me.

https://jira.atlassian.com/browse/JRACLOUD-45847

Alexey, you can already do that

Filtering project by "Project Category" would be extremely helpful

This request is for adding complexity to the the Category search in JQL.  If you are searching the Summary field, you can use "~", so you can search for any issues that have the word Report in the Summary.  We would like to be able to search for like Categories, i.e., Category ~ "Dept" to find Categories with the string Dept in them.  This would be very useful in reporting on Categories, rather than hardcoding the Categories in JQL and having to update all filters every time a new Category was added.

d3eb9a2caf0a your documentation is about the cloud version. The issue is about the server one.

To search for project category use the JQL keyword "Category"

Project Type looks to be supported now as well; https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-fields/#Advancedsearchingfieldsreference-projectTypeProjecttype

Project Category is available, but I don't believe project type has ever been addressed.

Yes, issue should be closed as "fixed", see last comment!

You can filter by project category. The JQL keyword is category. Details at
https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html#Advancedsearchingfieldsreference-CategoryCategory

How has this not been built yet with so many votes and interest for 6+ years???? Not having this is an operational nightmare in terms of reporting and transparency provided by dashboards and plugins powered by filter queries. Any time a new project is created I have to remember to update an insane number of filters in an insane number of places or all my data will be wrong. 

This is legitimately an essential, core feature that you are missing. 

EDIT: None of the work around suggested will work for my organization. The only way I can achieve what I need rn is literally to use Project in () and list every. single. key. that sits within a specific Project Category. Which currently is 18 and counting. What is the point of having categories if you can't filter by them? Its seriously silly. 

Thanks for the hint Eivind Fjeld.

But it would be appreciated to have this type of filter available.

EDIT: the workaround with "project in projectsWhereUserHasRole("Service Desk Team")" isn't working for projects where my personal user is not part of this group. Anyway: one way for projects where all members are part of the service desk team.

Hey Dimas, exactly  That's why the status is set to "Gathering interest"

Hi @all, so the feature for filter based on Project Type is not yet available until now?

How about simply this JQL:
request-channel-type is not EMPTY ORDER BY createddate desc

This may be a workaround for dashboards for agents until search for project type is supported

project in projectsWhereUserHasRole("Service Desk Team")

The role Service Desk Team is normally only used in Service Desk Projects.

Hi @all, 

you may try "Power JQL: extended search functions", this should solve this and other search issues:  https://marketplace.atlassian.com/1216891
]This Plugin give you Additional and useful JQL functions to search issues using the power of regex expressions! 

Best Regards
Domenico 

Alastair
Great thinking.

I extended that query with "request-channel-type = Jira" so it also includes tickets of a service desk project which are created within Jira with the "Create" button. 

Thanks Alastair! That worked.

Hi guys and gals,

I've been looking for this functionality too! Please sort this Jira - I've got a JQL workaround that looks to be working though. This seems to filter the tickets nicely for me. Can anyone see any problems with this?

request-channel-type = portal OR request-channel-type = email AND status = open ORDER BY created ASC

+1

1

+1

+1

+1

+ 1

+1

I think that any attribute of an issue or project should be available as a system field for searching and/or use in issue workflows, etc.
I also feel that this should be part of the planning process when adding a new feature going forward.

We missed this on the Request Type in Service Desk too.

Hi everybody,
If you are using Jira Server you can install the FREE app called JQL Booster Pack throught Atlassian Marketplace and use the requested functionality.

After install this app, you should be able to create a query using projectsOfType() function, that will allow you to find issues on project of type you desired.

This is the complete information of this JQL function:

Description:

Perform searches based on projects of the given type.

 

Syntax	projectsOfType(type, ...)
Available since	v1.0.0-RELEASE
Supported fields	Project
Supported operators	IN , NOT IN
Unsupported operators	= , != , ~ , !~ , > , >= , < , <= IS , IS NOT , WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

Examples:

• Find issues in projects of type Service Desk:

project IN projectsOfType("Service Desk")

• Find issues in projects of type Software aka Jira Agile:

project IN projectsOfType("Software")

• Find issues in projects of type Business aka Jira Core:

project IN projectsOfType("Business")

Kinds regards.

Gene:

Project Type (Software, Service Desk, Business) cannot be party of a JQL. 

Project Category can though. For example, we have a project category called Applications, so the following JQL would work: category = Applications ORDER BY createdDate 

https://community.atlassian.com/t5/Jira-Core-questions/can-I-filter-by-project-category/qaq-p/295536

.

I don't get the workaround Matthew, what syntax in JQL returns product category? Isn't the issue that product category isn't available in JQL?

I guess as a pretty simple work around, you could categories the projects as "service-desk" or something similar and use category within the JQL query.

Still sucks it's taking as long as it is.

I truly don't understand how Atlassian is handling/ignoring such request, at least say yes or no and close the issue... 

I'm also looking to be able to query by project type, so that I can configure boards to automatically include all service desk projects.

I am also looking to perfrom JQL projectType = "Service Desk" (or whatever that happens to look like)

Gavin Henderson

PMO Manager

Hi shamid, is there any chance the Service Desk team could pull this into an upcoming version? Would be very useful to be able to JQL projectType = "Service Desk" (or whatever that happens to look like).

We've even tried to access the projectType as a project property, although it isn't a property like other project/issue properties.

Thank you, have a great day,
Nick

Nicholas Muldoon
Product Manager, Easy Agile

Uhhh.. I'm not an Atlassian Employee.

As mentioned above, and in the documentation, Project Category has been added:

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html#Advancedsearching-fieldsreference-CategoryCategory

They're still outstanding on Project Type.

Hi @matthew.daize1317661705,

any progress on this please?

The inability to filter by "Project Category" (NOT "Category") is a pretty serious missing functionality. The JQL search term "category =" does not work with project categories.

How can I create search filters for "Project categories", as that would be the only way to display that data in Confluence also.

Any tips, or updates?

Cheers,

Rudy

How can this be, that such a simple feature is being ignored since 1 year .... 

Hi! 

Wondering what the status is on this request? Thanks. 

Paige

I'dd love to use this for grouped notifications. seems like a real gap here when it comes to scaling up jql for uses like boards and notifications!!

An example use case:
"projectType = "Service Desk" AND priority = 'Priority 1'"
If you have a filter/subscription/alert for Priority 1 issues, you can view them ALL in a single place.

The current wokr around would be categorize the projects as one type and filter that way...

Searching by project category has been in JIRA for at least two years. I'm trying to imagine why I would want to group all issues by project type. Perhaps "all Service Desk issues"? But it doesn't seem like a critical use case to me

It's great that they added "category" to JQL (whenever that was). Still cannot search by project type however.

A suitable workaround would be to use the category to filter (but then you lose it for other category-related filters).