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

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 =