Hello! I’m trying to create an eQL report that will search multiple levels of relationships in eB. We have a report in place that returns all documents “Reference To” a specific Package document.
We’ve recently found a need to ‘nest’ packages (i.e., A single Package document will Reference to other Package documents, which Reference to File Documents).
I’d like an eQL report that allows me to find all of File Documents by searching on the top level Package number.
This is the Where clause that we use for our current, single level packages. Any way to build on this?
WHERE IsTemplate = 'N' AND Id = Documents.Right.Id AND Documents.Left.Code LIKE @docLeftCode AND Documents.Left.Revision LIKE @docLeftRev