Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 6586
Line 10... Line 10...
10 
               Count(vd.pkg_id) AS pkg_count,
10 
               Count(vd.pkg_id) AS pkg_count,
11 
               vi.owner_id
 11 
               vi.owner_id
12 
          FROM views vi, view_def vd, users usr
 12 
          FROM views vi, view_def vd, users usr
13 
         WHERE (vi.owner_id = 0 OR vi.public_read='Y')
13 
         WHERE (vi.owner_id = 0 OR vi.public_read='Y')
14 
           AND usr.user_id = vi.owner_id
 14 
           AND usr.user_id = vi.owner_id
- 
 
 15 
           AND vi.base_view != 'Y'
15 
           AND vi.view_id = vd.view_id(+)
16 
           AND vi.view_id = vd.view_id(+)
16 
           AND vi.view_id NOT IN (SELECT vis.view_id FROM view_settings vis WHERE vis.user_id = $USER_ID$ )
 17 
           AND vi.view_id NOT IN (SELECT vis.view_id FROM view_settings vis WHERE vis.user_id = $USER_ID$ )
17 
         GROUP BY vi.view_id, vi.view_name, usr.user_name, usr.user_email, vi.base_view, vi.owner_id
 18 
         GROUP BY vi.view_id, vi.view_name, usr.user_name, usr.user_email, vi.base_view, vi.owner_id
18 
        UNION
 19 
        UNION
19 
        /* Shown Views */
 20 
        /* Shown Views */
Line 29... Line 30...
29 
         WHERE vi.view_id = vis.view_id
 30 
         WHERE vi.view_id = vis.view_id
30 
               AND usr.user_id = vi.owner_id
31 
               AND usr.user_id = vi.owner_id
31 
               AND vi.view_id = vd.view_id(+)
32 
               AND vi.view_id = vd.view_id(+)
32 
               AND vis.user_id = $USER_ID$
 33 
               AND vis.user_id = $USER_ID$
33 
               AND vi.public_read = 'Y'
 34 
               AND vi.public_read = 'Y'
- 
 
 35 
               AND vi.base_view != 'Y'
34 
         GROUP BY vi.view_id, vi.view_name, usr.user_name, usr.user_email, vi.base_view, vi.owner_id
 36 
         GROUP BY vi.view_id, vi.view_name, usr.user_name, usr.user_email, vi.base_view, vi.owner_id
- 
 
 37 
        UNION
- 
 
 38 
        /* Base Views */
- 
 
 39 
        SELECT '0' AS show,
- 
 
 40 
               vi.view_id,
- 
 
 41 
               vi.view_name,
- 
 
 42 
               '' AS owner_name,
- 
 
 43 
               '' AS owner_email,
- 
 
 44 
               vi.base_view,
- 
 
 45 
               Count(pv.pkg_id) AS pkg_count,
- 
 
 46 
               0 as owner_id
- 
 
 47 
          FROM views vi, release_content rc, package_versions pv
- 
 
 48 
         WHERE  vi.base_view = 'Y'
- 
 
 49 
               AND rc.base_view_id = vi.view_id
- 
 
 50 
               AND rc.pv_id = pv.pv_id
- 
 
 51 
         GROUP BY vi.view_id, vi.view_name, vi.base_view
35 
       ) pview
 52 
       ) pview
36 
 ORDER BY UPPER(pview.view_name) ASC
 - 
 
37 

            53
            
 ORDER BY UPPER(pview.view_name) ASC

          

          

            -
            
 

            54