Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT pv.pv_id, pkg.pkg_name, pv.pkg_version, pv.v_ext, cqi.*
2 
  FROM cq_issues cqi,
3 
       packages pkg,
4 
       package_versions pv
5 
 WHERE pv.pkg_id = pkg.pkg_id
6 
   AND cqi.pv_id = pv.pv_id
7 
   AND cqi.iss_db = /*ISS_DB*/
8 
   AND cqi.iss_id IN ( /*ISS_ID_LIST*/ )
9 
ORDER BY cqi.iss_id, UPPER(pkg.pkg_name)
10 
 
11