Subversion Repositories DevTools

Rev

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

Rev 6588 Rev 6612
Line 2... Line 2...
2 
  FROM (
 2 
  FROM (
3 
        /* Hidden Views */
 3 
        /* Hidden Views */
4 
        SELECT '0' AS show,
4 
        SELECT '0' AS show,
5 
               vi.view_id,
5 
               vi.view_id,
6 
               vi.view_name,
6 
               vi.view_name,
7 
               usr.user_name AS owner_name,
7 
               usr.full_name AS owner_name,
8 
               usr.user_email AS owner_email,
 8 
               usr.user_email AS owner_email,
9 
               vi.base_view,
9 
               vi.base_view,
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.base_view != 'Y'
16 
           AND vi.view_id = vd.view_id(+)
16 
           AND vi.view_id = vd.view_id(+)
17 
           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$ )
18 
         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.full_name, usr.user_email, vi.base_view, vi.owner_id
19 
        UNION
 19 
        UNION
20 
        /* Shown Views */
 20 
        /* Shown Views */
21 
        SELECT '1' AS show,
21 
        SELECT '1' AS show,
22 
               vi.view_id,
22 
               vi.view_id,
23 
               vi.view_name,
23 
               vi.view_name,
24 
               usr.user_name AS owner_name,
24 
               usr.full_name AS owner_name,
25 
               usr.user_email AS owner_email,
 25 
               usr.user_email AS owner_email,
26 
               vi.base_view,
26 
               vi.base_view,
27 
               Count(vd.pkg_id) AS pkg_count,
27 
               Count(vd.pkg_id) AS pkg_count,
28 
               vi.owner_id
 28 
               vi.owner_id
29 
          FROM views vi, view_settings vis, view_def vd, users usr
 29 
          FROM views vi, view_settings vis, view_def vd, users usr
Line 31... Line 31...
31 
               AND usr.user_id = vi.owner_id
31 
               AND usr.user_id = vi.owner_id
32 
               AND vi.view_id = vd.view_id(+)
32 
               AND vi.view_id = vd.view_id(+)
33 
               AND vis.user_id = $USER_ID$
 33 
               AND vis.user_id = $USER_ID$
34 
               AND vi.public_read = 'Y'
 34 
               AND vi.public_read = 'Y'
35 
               AND vi.base_view != 'Y'
 35 
               AND vi.base_view != 'Y'
36 
         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.full_name, usr.user_email, vi.base_view, vi.owner_id
37 
        UNION
 37 
        UNION
38 
        /* Base Views */
 38 
        /* Base Views */
39 
        SELECT '0' AS show,
39 
        SELECT '0' AS show,
40 
               vi.view_id,
40 
               vi.view_id,
41 
               vi.view_name,
41 
               vi.view_name,