RHNUSERAVAILABLECHANNELS
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| USER_ID | NUMBER(38) | Y | NO | NO | NO | |
| ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_ID | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_DEPTH | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_NAME | VARCHAR2(64) | Y | NO | NO | NO | |
| CHANNEL_ARCH_ID | NUMBER(38) | Y | NO | NO | NO | |
| PADDED_NAME | VARCHAR2(66) | Y | NO | NO | NO | |
| CURRENT_MEMBERS | NUMBER(38) | Y | NO | NO | NO | |
| AVAILABLE_MEMBERS | NUMBER(38) | Y | NO | NO | NO | |
| LAST_MODIFIED | DATE | Y | NO | NO | NO | |
| CHANNEL_LABEL | VARCHAR2(128) | Y | NO | NO | NO | |
| PARENT_OR_SELF_LABEL | VARCHAR2(128) | Y | NO | NO | NO | |
| PARENT_OR_SELF_ID | NUMBER(38) | Y | NO | NO | NO | |
| END_OF_LIFE | DATE | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select
ct.user_id,
ct.org_id,
ct.id,
CT.depth,
CT.name,
CT.channel_arch_id,
CT.padded_name,
(
SELECT COUNT(1)
FROM rhnUserServerPerms USP
WHERE USP.user_id = ct.user_id
AND EXISTS (SELECT 1 FROM rhnServerChannel WHERE channel_id = ct.id AND server_id = USP.server_id)
),
rhn_channel.available_chan_subscriptions(ct.id, ct.org_id),
CT.last_modified,
CT.label,
CT.parent_or_self_label,
CT.parent_or_self_id,
CT.end_of_life
from
rhnUserChannelTreeView ct
where rhn_channel.org_channel_setting(ct.id, ct.org_id ,'not_globally_subscribable') = 0 OR exists (
SELECT 1 from rhnChannelPermission per where per.channel_id = ct.id
)
OR (rhn_user.check_role(ct.user_id, 'org_admin') = 1
OR rhn_user.check_role(ct.user_id, 'channel_admin') = 1)