Hi ,
My Query goes like below. I am trying to get these fields from DB by comparing Application URL and Issue Type. In my DB Issue Types are like Incident, Service Requests....etc.
Basically I want to compare Issue Type that we select on Create Issue Page. Could you please let me know what value is going in "issuetype" system field. Or is there any other way to do it.
select ApplicationURL, SubCategoryName, Priority, IssueType
from vwGetSubCategory where ApplicationURL =
{customfield_10000}
and IssueType LIKE '%'+
{issuetype}+'%'
Also Tried Issue Type = {issuetype}
, but its also not working.
Regards,
Aditya Verma
Community moderators have prevented the ability to post new answers.
Issue types are not named, they work from a key, so you need to join the issuetype table in if you want to identify them by name.
Hi Nic,
Thanks for replying.
From where we can get key for all issue types?
Thanks,
Aditya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just pointed you at the issuetype table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.