oracle8.1.6
begin
:1 := file_storage.get_root_folder(:package_id);
end;
begin
:1 := content_folder.get_label(:folder_id);
end;
select count(*)
from cr_items
where item_id in (select item_id
from cr_items
connect by prior item_id = parent_id
start with item_id = :item_id)
and acs_permission.permission_p(item_id,:user_id,:privilege) = 'f'
select item_id as child_item_id
from cr_items
connect by prior item_id = parent_id
start with item_id = :item_id
select count(*)
from cr_revisions
where item_id = :child_item_id
and acs_permission.permission_p(revision_id,:user_id,:privilege) = 'f'
begin
:1 := content_item.get_title(:item_id);
end;
select case when content_item.get_content_type(i.item_id) = 'content_folder'
then '?folder_id='
else 'file?file_id='
end || i.item_id,
content_item.get_title(i.item_id)
from cr_items i
where item_id not in (
select i2.item_id
from cr_items i2
connect by prior i2.parent_id = i2.item_id
start with i2.item_id =
file_storage.get_root_folder([ad_conn package_id]))
connect by prior i.parent_id = i.item_id
start with item_id = :start_id
order by level desc