Good morning
Is anyone able to advise on the eQL statement needed that returns those projects where a particular document (container) title has not been related? So for example, projects where documents containing the title 'HSF-K1' have not been related?
I do hope this query makes sense!
Many thanks
Chris
Okay, I'm making a little progress. I've compiled the following, which returns a list of all projects (apart from those starting with '0' or 'W') and their containers where "Final Certificate" does not appear in the container title. Now, is there any way of just listing the projects where the "Final Certificate" container does not exist, rather than a list of all the containers linked to a project?
START WITH Project SELECT Id, Code, Name, Projects.Left.Code, Projects.Left.Name, Documents.Document.Name, Documents.Document.Code WHERE Documents.Document.Name NOT LIKE '%Final%Certificate%' AND Code NOT LIKE '0%' AND Code NOT LIKE 'W%' AND Class.Name = 'Project' AND Status = 'A'
If you just want to list projects you can remove the both the Documents.Document columns and you will get a compacted list of just the projects that do not have any documents with the name you specified.
Answer Verified By: Chris Marsh
Thank you, Michael. Worked a treat.