How to find node ID's in the Dtree table?

Pavan Joshi · 2022-06-09T14:55:11+00:00

There was an error rendering this rich post.

Under ECM library quotes and orders we have some empty folders identified with quote numbers. I am trying to find the empty folders in the SQL data which resides under Dtree table. Can anyone help with the query to extract the data to have them removed?

Find more posts tagged with

xECM

Comments

Nizar Ghazal

If they're regular folders, could you not just do:

SELECT * FROM DTree WHERE SubType = 0 AND ChildCount = 0

ChildCount isn't always perfect, but should at least give you a quick-and-dirty list of folders that are empty.

If you want to limit it to some common ancestor, maybe something like this:

SELECT * FROM DTree a JOIN DTreeAncestors b ON b.DataID = a.DataID

WHERE a.SubType = 0 AND a.ChildCount = 0 AND b.AncestorID = <Some Root Container ID>