how do I write an eql to
1 - find all the documents thath have been issued on distribuition
2- find all the people who have received a distribution and are current holders of documents
I will try to find out the answer for you.
Please check the below eql that will give you all the Distribution order of the document and also to whom they are assigned.
START WITH Document
SELECT Id, Code, Middle, Revision, Name,
WHERE Id > 0 AND IsTemplate='N' AND Holders.DistributionOrder.Code IS NOT NULL
Do let me know if you need any assistance.
Answer Verified By: Carma De Villiers