RHNUSERCHANNELTREEVIEW
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 | |
| ID | NUMBER(38) | Y | NO | NO | NO | |
| DEPTH | NUMBER(38) | Y | NO | NO | NO | |
| NAME | VARCHAR2(256) | Y | NO | NO | NO | |
| PADDED_NAME | VARCHAR2(258) | Y | NO | NO | NO | |
| CHANNEL_ARCH_ID | NUMBER(38) | Y | NO | NO | NO | |
| LAST_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | NO | NO | NO | |
| 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 | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select USER_ID,ORG_ID,ID,DEPTH,NAME,PADDED_NAME,CHANNEL_ARCH_ID,LAST_MODIFIED,LABEL,PARENT_OR_SELF_LABEL,PARENT_OR_SELF_ID,END_OF_LIFE from (
select cfp.user_id as user_id,
cfp.org_id as org_id,
c.id as id,
1 as depth,
c.name as name,
' ' || c.name as padded_name,
c.channel_arch_id as channel_arch_id,
c.last_modified as last_modified,
c.label as label,
c.label as parent_or_self_label,
c.id as parent_or_self_id,
c.end_of_life as end_of_life
from rhnChannel c,
rhnChannelFamilyMembers cfm,
rhnUserChannelFamilyPerms cfp
where cfp.channel_family_id = cfm.channel_family_id
and cfm.channel_id = c.id
and c.parent_channel is null
union
select cfp.user_id as user_id,
cfp.org_id as org_id,
c.id as id,
2 as depth,
c.name as name,
'' || c.name as padded_name,
c.channel_arch_id as channel_arch_id,
c.last_modified as last_modified,
c.label as label,
pc.label as parent_or_self_label,
pc.id as parent_or_self_id,
c.end_of_life as end_of_life
from rhnChannel pc,
rhnChannel c,
rhnChannelFamilyMembers cfm,
rhnUserChannelFamilyPerms cfp
where cfp.channel_family_id = cfm.channel_family_id
and cfm.channel_id = c.id
and c.parent_channel = pc.id
) S order by parent_or_self_label, parent_or_self_id