Folder Items

Drill into Folder items from any Folder

SQL
select i.exp_name item_name,
i.exp_description item_description,
EUL5_get_item((i.exp_id)) Item_depends_on ,
i.it_ext_column,
i.exp_developer_key item_key,
i.exp_id item_id,
f.obj_name folder
from EUL5_expressions i
, EUL5_objs f
, EUL5_ba_obj_links l
, EUL5_bas b
where f.obj_id= i.it_obj_id
and f.obj_id= l.bol_obj_id
and b.ba_id= l.bol_ba_id
and ( f.obj_id = 101325 or lower(f.obj_name) like lower('Activity Base Rate'))
and lower(i.exp_name) like lower('%')
order by b.ba_name,f.obj_name,i.exp_name