Retrieve the project key in issue navigator

[wong sin ooi]

Hi,

I am using this query to come out a list of request types which tied to the project key when searching for issue:

#if($issue.project.key)
select request_type_id, name
from tableA
where pkey = '$issue.project.key'
order by name
#else
select request_type_id, name
from tableA
order by name
#end

However, it seems like the $issue.project.key always return NULL because I always get the result from the else statement.

Could you please provide an alternative way?

[Nic Brough -Adaptavist-]

Where is this velocity being rendered?