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