+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Reporting on page history, reviewed and last updated

Reporting on page history, reviewed and last updated

3 posts, 0 answered
  1. Richard
    Richard avatar
    49 posts
    Registered:
    13 Jul 2010
    17 Jun 2015
    Link to this post

    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.

     

     

  2. Sabrie Nedzhip
    Sabrie Nedzhip avatar
    534 posts
    Registered:
    27 Sep 2016
    22 Jun 2015
    Link to this post
    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
     
  3. Richard
    Richard avatar
    49 posts
    Registered:
    13 Jul 2010
    30 Jun 2015 in reply to Sabrie Nedzhip
    Link to this post

    Hello Sabrie

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

     

    Rich

3 posts, 0 answered