CODEWITHSUNDEEP
sitecoresitecore8
Ash8087
Ash8087

Reputation: 701

See Publication Date for Items in Sitecore

I'm trying to figure out how to know when an Item was published in Sitecore. I've looked at the History table in SQL Server and I see when the Item was changed, and also when it moved through every step in the workflow. But I don't see anything that looks like a "Publication" event.

Thanks...!

Upvotes: 1

Views: 1831

Answers (2)

Hishaam Namooya
Hishaam Namooya

Reputation: 1081

If tracking the item published date using the History Table, note that the History Table is cleaned-up every 4hrs by default. So, you may end up having no values for the item.

Normally, once an item has been modified, it is inserted into the publish queue table. You may instead track the last published that occurred. You may refer to my blog post: https://hishaamn.wordpress.com/2015/10/25/last-published-timestamp-on-sitecore-login-page/

Thanks

Upvotes: 1

Vlad Iobagiu
Vlad Iobagiu

Reputation: 4118

Unfortunately you can't get a published date. You need to implement a custom way to track when items are published. Please check this blog post:

http://sitecoreskills.blogspot.ro/2014/04/first-and-last-publish-dates-in-sitecore.html

Upvotes: 2

Related Questions