Dynamic SQL not producing desired result.

Aditya Verma
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 27, 2015

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

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 27, 2015

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.

Aditya Verma
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 27, 2015

Hi Nic,

Thanks for replying.

From where we can get key for all issue types?

Thanks,

Aditya

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 27, 2015

I just pointed you at the issuetype table.

TAGS
AUG Leaders

Atlassian Community Events