Query to return JIRA Service Desk projects

[Eric Sara]

Recently implemented JIRA Service Desk.

Now I want to do a query to return issues to only JIRA Service Desk projects.

Rather then do a query that is "project in (LIST ALL PROJECTS)"
and then update this list each time a new project is made

I would like to know if there is way to do a query that simply returns only JIRA Service Desk projects.

Thanks,

[Jack Brickey · Accepted solution]

Here is something to try...

for all of your JSD projects use the Category field and add a category such as “JSD”. Then use Category JQL function e.g. category = JSD

[Eric Sara]

Thanks @Jack Brickey , while this will work the issue I have (and you may have a solution for this too) is that when the project is created it is not auto set to this category.

[Jack Brickey]

I wish I had a solution for that but don’t. It might be possible to script this using an addon but I don’t have any experience with doing so. Possibly creating projects using a template.

[Dave Theodore [Coyote Creek Consulting] · Accepted solution]

There's a Suggestion already for this. Hopefully it gets implemented.  There is a workaround JQL example in that issue that may work for you.

[Eric Sara]

Thanks @Dave Theodore [Coyote Creek Consulting] I have added myself to the suggestion and will also use the workaround.

[Deleted user]

Hi, I actually already use project category to map the client referred to a set of projects. In this case I cannot use a JSD category. Can you point me to a different solution? Could it be that there is no function on JQL to find the "project type" (software, business, or service desk)?