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

Aswini Vayyala

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?

Nic Brough -Adaptavist-

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