Hello Colin,
you can use the following sql-query to get all objects in a given folder in client 1:
with allepfade (Client, Idnr, Name, Typ, Pfad, Link) as (
--Anchor
select mit.OH_Client, mit.OH_Idnr, mit.OH_Name, mit.OH_Otype, mit.OH_Name, 0
from OH mit
where mit.OH_Otype = 'CLNT'
and mit.OH_Name = '
0001'
UNION ALL
--rekursiver Teil
select mit2.OH_Client, OFS_OH_IDNR_O, mit2.OH_Name, mit2.OH_Otype, Pfad || '\' || substr(Name, instr(Name, '\')+1, 200), OFS_Link
from allepfade
inner join OFS on OFS_OH_IDNR_F = IDNR
inner join OH mit2 on OFS_OH_IDNR_O = mit2.OH_IDNR
)
select oh_name,oh_otype, pfad from oh
left outer join allepfade on OH_NAME = Name
where
oh_client =
1and oh_deleteflag = 0
and pfad like '%
<your_folder>%'
order by 2
;
Regards
Bernhard
------------------------------
Landeshauptstadt München
------------------------------
Original Message:
Sent: 03-04-2021 10:14 AM
From: Willis
Subject: SQL - List of objects in a given folder
Hi Everyone...
My SQL is not the best, so need some help...
Does anyone have any example Oracle SQL that lists the objects in a given folder?
Any help would be appreciated.
Regards,
Colin.