Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
5860 dpurdie 1 
SELECT pv.pv_id, pkg.pkg_name, pv.pkg_version, pv.v_ext, ji.*
2 
  FROM jira_issues ji,
3 
       packages pkg,
4 
       package_versions pv
5 
 WHERE pv.pkg_id = pkg.pkg_id
6 
   AND ji.pv_id = pv.pv_id
7 
   AND ji.ISS_KEY IN ( /*ISS_ID_LIST*/ )
8 
ORDER BY ji.ISS_KEY, UPPER(pkg.pkg_name)
9 
 
10