Subversion Repositories DevTools

Rev

Rev 1453 | Rev 2016 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1453 Rev 1454
Line 383... Line 383...
383
        {
383
        {
384
            $excludes .= " AND rt.RTAG_ID != $_ ";
384
            $excludes .= " AND rt.RTAG_ID != $_ ";
385
        }
385
        }
386
    }
386
    }
387
 
387
 
388
    my $m_sqlstr = "SELECT DISTINCT pv.PV_ID, pkg.PKG_NAME, pv.PKG_VERSION, pv.DLOCKED" .
388
    my $m_sqlstr = "SELECT DISTINCT " .
-
 
389
                        "pv.PV_ID, " .                                          #[0]
-
 
390
                        "pkg.PKG_NAME, " .                                      #[1]
-
 
391
                        "pv.PKG_VERSION, " .                                    #[2]
-
 
392
                        "pv.DLOCKED, " .                                        #[3]
389
                   "    , release_manager.PK_RMAPI.return_vcs_tag(pv.PV_ID), pv.PKG_ID" .
393
                        "release_manager.PK_RMAPI.return_vcs_tag(pv.PV_ID), " . #[4]
-
 
394
                        "pv.PKG_ID", .                                          #[5]
390
                   "    , rt.RTAG_ID, rmv.VIEW_NAME, pv.MODIFIED_STAMP, prj.PROJ_ID" .
395
                        "rt.RTAG_ID, " .                                        #[6]
-
 
396
                        "rmv.VIEW_NAME, " .                                     #[7]
-
 
397
                        "pv.MODIFIED_STAMP, " .                                 #[8]
-
 
398
                        "prj.PROJ_ID " .                                        #[9]
391
                   " FROM RELEASE_MANAGER.RELEASE_CONTENT rc, RELEASE_MANAGER.PACKAGE_VERSIONS pv,".
399
                   " FROM RELEASE_MANAGER.RELEASE_CONTENT rc, RELEASE_MANAGER.PACKAGE_VERSIONS pv,".
392
                   "      RELEASE_MANAGER.PACKAGES pkg, release_manager.release_tags rt, release_manager.projects prj" .
400
                   "      RELEASE_MANAGER.PACKAGES pkg, release_manager.release_tags rt, release_manager.projects prj" .
393
                   "    , release_manager.views rmv" .
401
                   "    , release_manager.views rmv" .
394
                   " WHERE rc.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID" .
402
                   " WHERE rc.PV_ID = pv.PV_ID AND pv.PKG_ID = pkg.PKG_ID" .
395
                   "   AND rmv.VIEW_ID = rc.BASE_VIEW_ID" .
403
                   "   AND rmv.VIEW_ID = rc.BASE_VIEW_ID" .