Community
Products
Jira Service Management
Questions
how to get a specific 'customer request type' value for a service desk project from mysql database

how to get a specific 'customer request type' value for a service desk project from mysql database

I am unable to get any results for the following query

project="pj" and "customer request type" = "pj/environment-requests"

There is clearly a request type called "Environment Request" in project "pj" and it is not renamed.

So I want to directly get the database value for this particular request type to be sure what i am providing in the query is correct.

Can someone help me getting the value from mysql database directly?

1 answer

1 vote

Your JQL is incorrect, you've added an unnecessary pj/ to the front of the name of the request type.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.