nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Livereport to select documents in a folder and sub-foledr

Valéry_Bourillon_(vbourillon_-_(deleted))

Hi,I need to select the documents (subtype=144) of a folder and its sub-folder. Folders can have communities, I want to select also the documents of these communities.Somebody has a simple query ?Thanks

Find more posts tagged with

Comments

RajDon

Try this...SELECT dataid, NAMEFROM dtree WHERE SUBTYPE=144 connect by prior dataid in abs(parentid) and subtype in (0, 202, 144, )start with dataid =