tag:help-archives.hannonhill.com,2010-02-09:/discussions/general/360-find-assets-published-after-dateCascade CMS: Discussion 2018-10-18T20:36:19Ztag:help-archives.hannonhill.com,2010-02-09:Comment/89605212011-07-29T18:53:08Z2011-07-29T18:53:08ZFind assets published after date?<div><p>Is it possible to get a list of assets that were published after
a certain date? I don't see where this search term would be
set.</p></div>Christag:help-archives.hannonhill.com,2010-02-09:Comment/89605212011-07-29T19:36:09Z2011-07-29T19:36:09ZFind assets published after date?<div><p>Allow me to clarify in case any Hannon Hill staff are actually
monitoring this forum...I would like an efficient way to search for
these assets, rather than spidering my entire site and checking
against "getLastPublishedDate()"</p></div>Christag:help-archives.hannonhill.com,2010-02-09:Comment/89605212011-07-29T20:40:57Z2011-07-29T20:40:57ZFind assets published after date?<div><p>Hi Chris,</p>
<p>There isn't anything native in the product that will allow you
to do this. It sounds like this would be a nice addition to
<a href="http://ideas.hannonhill.com/forums/52559-cascade-ideas/suggestions/691108-add-report-feature?ref=title">
this feature request</a>, so be sure to vote/comment on that item
if you wish.</p>
<p>In the meantime, I can provide you with some steps that should
do the trick:</p>
<ul>
<li>Enter the date in question into an <a href=
"http://www.onlineconversion.com/unix_time.htm">online unix
conversion tool</a> and convert it to a timestamp. For example:
<code>7/29/2011</code></li>
<li>Take the timestamp that is returned and add three zeros to the
end of it. Continuing the example from above:
<code>1311811200</code> + 3 zeros = <code>1311811200000</code></li>
<li>Now take this number and plug it into a SQL query like this:
<pre>
<code> select fc.name, fc.id, fc.cachePath, s.name
from cxml_foldercontent fc, cxml_site s
where fc.isCurrentVersion = 1
and fc.isRecycled = 0
and fc.lastDatePublished > '{date}'
and draftOriginalId is null
and fc.siteId = s.id;</code>
</pre>
So the query for this example will be:
<pre>
<code> select fc.name, fc.id, fc.cachePath, s.name
from cxml_foldercontent fc, cxml_site s
where fc.isCurrentVersion = 1
and fc.isRecycled = 0
and fc.lastDatePublished > '1311811200000'
and draftOriginalId is null
and fc.siteId = s.id;</code>
</pre>
<p>Let me know if this helps.</p>
</li>
</ul>
<p>Thanks</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/89605212011-08-02T14:42:46Z2011-08-02T14:42:46ZFind assets published after date?<div><p>This is handy, thanks!</p></div>Chris