| 119 |
ghuddy |
1 |
SELECT *
|
|
|
2 |
FROM (
|
|
|
3 |
/* Hidden Views */
|
|
|
4 |
SELECT '0' AS show, vi.view_id, vi.view_name, Count(vd.pkg_id) AS pkg_count, vi.public_read
|
|
|
5 |
FROM views vi, view_def vd
|
|
|
6 |
WHERE vi.owner_id = $USER_ID$
|
|
|
7 |
AND vi.view_id = vd.view_id(+)
|
|
|
8 |
AND vi.view_id NOT IN (SELECT vis.view_id FROM view_settings vis WHERE vis.user_id = $USER_ID$)
|
|
|
9 |
GROUP BY vi.view_id, vi.view_name, vi.public_read
|
|
|
10 |
UNION
|
|
|
11 |
/* Shown Views */
|
|
|
12 |
SELECT '1' AS show, vi.view_id, vi.view_name, Count(vd.pkg_id) AS pkg_count, vi.public_read
|
|
|
13 |
FROM views vi, view_settings vis, view_def vd
|
|
|
14 |
WHERE vi.view_id = vis.view_id AND vi.view_id = vd.view_id(+) AND vi.owner_id = $USER_ID$
|
|
|
15 |
GROUP BY vi.view_id, vi.view_name, vi.public_read
|
|
|
16 |
) pview
|
|
|
17 |
ORDER BY pview.view_name ASC
|