tag:help-archives.hannonhill.com,2010-02-09:/discussions/general/20136-sql-to-find-draftsCascade CMS: Discussion 2015-02-17T17:37:37Ztag:help-archives.hannonhill.com,2010-02-09:Comment/360708722015-02-17T17:27:55Z2015-02-17T17:27:55ZSQL to find drafts<div><p>Hi Tom,</p>
<p>Want to try something like this?:<br></p>
<pre>
<code>select fc.name, fc.cachePath as "path", s.name as "site", fc.draftUserId as "user with Draft"
from cxml_foldercontent fc, cxml_site s
where (fc.draftOriginalId is not null and fc.draftUserId is not null) and fc.siteId = s.id and fc.isWorkingCopy = 0 order by fc.cachePath</code>
</pre>
Let me know if that returns the results you're looking for.
<p>Thanks!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/360708722015-02-17T17:36:23Z2015-02-17T17:36:23ZSQL to find drafts<div><p>Tim,</p>
<p>Thanks, this is exactly what I need.</p>
<p>Tom</p></div>tom.wilkinsontag:help-archives.hannonhill.com,2010-02-09:Comment/360708722015-02-17T17:37:35Z2015-02-17T17:37:35ZSQL to find drafts<div><p>Cool! Glad I could help out. Take care, Tom!</p></div>Tim