finding documents that were on transmittals

V15.5.1

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

Parents Reply
  • Hi,

    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,

    Holders.DistributionOrder.Code,

    Holders.DistributionOrder.Status,

    Holders.IssuedTo.Code,Holders.IssuedTo.Surname

    WHERE Id > 0 AND IsTemplate='N' AND Holders.DistributionOrder.Code IS  NOT NULL

    Do let me know if you need any assistance.

    Regards,
    Manav B.



    Answer Verified By: Carma De Villiers 

Children
No Data