Viewing SQL query result set values in a vm file?

[Nageswarara Rao]

Hi

I wrote a java class in my jira plugin and executed a sql query , now i want to view those results in a velocity file.

how to do this

thanks in advance

[Nic Brough -Adaptavist-]

Your code should have retrieved a result set from the SQL query. Add that to the "map" that gets fed into the .vm when the users land on the page.

We can't really be more specific than that - where the map is populated, and by what, depends on what your plugin is providing and how you've coded it. For example, a custom field may use method X to get the map, but an issue panel might have method Y or Z.