Subversion Repositories DevTools

SELECT *
  FROM
       (
        SELECT  /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
                si.dbid AS iss_id, 
                si.new_num AS iss_num, 
            si.headline AS summary, 
                sdef.name AS status, 
                si.priority AS priority,
                si.issue_type AS issue_type
        FROM  DEVI_PROD.admin.software_issue si INNER JOIN DEVI_PROD.admin.statedef sdef ON si.state = sdef.id
        WHERE  si.dbid IN (/*DEVIiss*/)
        UNION ALL
        SELECT /*enumCLEARQUEST_TDSE_ID*/ AS iss_db,
          si.dbid AS iss_id, 
          si.job_number AS iss_num, 
          si.problem_summary AS summary, 
          sdef.name AS status, 
          si.priority AS priority,
          NULL AS issue_type
    FROM  TDSE_2002.admin.request si INNER JOIN TDSE_2002.admin.statedef sdef ON si.state = sdef.id
        WHERE  si.dbid IN (/*TDSEiss*/)
        UNION ALL
        SELECT  /*enumCLEARQUEST_VT5DM_ID*/ AS iss_db,
                si.dbid AS iss_id, 
                si.new_num AS iss_num, 
            si.headline AS summary, 
                sdef.name AS status, 
                si.priority AS priority,
                si.issue_type AS issue_type
        FROM  VT5DM.admin.software_issue si INNER JOIN VT5DM.admin.statedef sdef ON si.state = sdef.id
        WHERE  si.dbid IN (/*VT5DMiss*/)
        UNION ALL
        SELECT /*enumCLEARQUEST_VTSUP_ID*/ AS iss_db,
          si.dbid AS iss_id, 
          si.job_number AS iss_num, 
          si.problem_summary AS summary, 
          sdef.name AS status, 
          si.priority AS priority,
          NULL AS issue_type
    FROM  VTSUP.admin.request si INNER JOIN VTSUP.admin.statedef sdef ON si.state = sdef.id
        WHERE  si.dbid IN (/*VTSUPiss*/)

        ) AS issues
ORDER BY iss_num ASC