We have our internal application which needs to show JIRA issues based on some filter
Project Name, Total SIT issues, Open SIT Issues, Total UAT Issues, Open UAT issues for a project
this project is identified by a code, which is available in each JIRA project. (Project Description)
and SIT & UAT can be identified from Environments (custom field)
What is your suggestion on this data feed? 1) creating a SQL view 2) any other easy way of doing this