Reporting on page history, reviewed and last updated - Sitefinity - General Discussions

All Replies

Posted by Community Admin on 17-Jun-2015 00:00

We've had a request from our marketing depart asking the following:

"Can you guys write a report to show when the last time pages were reviewed/updated on Sitefinity"

I'm assuming there is nothing out the box so would anyone know of the sql to give me something like that?

Any help gratefully appreciated.

Posted by Community Admin on 22-Jun-2015 00:00

Hi Richard,

If you would like to get the date when the content of a page has been last modified you need to get the page data and then get the LastModified property using the API.

Here is an example:

PageManager pageManager = PageManager.GetManager();

PageNode pageNode = pageManager.GetPageNodes().Where(n => n.Title == "YourPageTitle").FirstOrDefault();

// when the page node

// (the Titles and Properties of a page) has been last modified

var lastDateModified = pageNode.LastModified;

PageData pageData = pageManager.GetPageData(pageNode.Id);

// when the page data (the content) has been last modified

var pageDataLastModified = pageData.LastModified;

You may also refer to the following article for more details about querying pages using tthe API.

Regards,
Sabrie Nedzhip
Telerik

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items

Posted by Community Admin on 30-Jun-2015 00:00

Hello Sabrie

Thank you very much for this information, it is gratefully received.

Rich

This thread is closed