postgresql7.1
select file_storage__get_root_folder(:package_id);
select content_folder__get_label(:folder_id);
select count(*)
from cr_items
where item_id in (select item_id
from cr_items
where tree_sortkey like (select tree_sortkey || '%'
from cr_items
where item_id = :item_id)
order by tree_sortkey)
and acs_permission__permission_p(item_id,:user_id,:privilege) = 'f'
select item_id as child_item_id
from cr_items
where tree_sortkey like (select tree_sortkey || '%'
from cr_items
where item_id = :item_id)
order by tree_sortkey
select count(*)
from cr_revisions
where item_id = :child_item_id
and acs_permission__permission_p(revision_id,:user_id,:privilege) = 'f'
select content_item__get_title(:item_id);
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
where i2.tree_sortkey like (select i3.tree_sortkey || '%'
from cr_items i3
where i3.item_id =
file_storage__get_root_folder([ad_conn package_id]))
order by i2.tree_sortkey)
and i.tree_sortkey like (select i4.tree_sortkey || '%'
from cr_items i4
where i4.item_id = :start_id)
order by i.tree_sortkey desc