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

Forums / Developing with Sitefinity / Increasing the count of latest modifiction on dashboard page to 2000 or any other no

Increasing the count of latest modifiction on dashboard page to 2000 or any other no

2 posts, 0 answered
  1. eraashishgupta
    eraashishgupta avatar
    50 posts
    Registered:
    26 Nov 2008
    10 Jan 2009
    Link to this post
    Owing to some mistake which our client did i want to see all the pages which he had modified on a particular date.
    Client been non technical made changes to the staging server database thinking that now there will be no changes.
    So now we need to merge the changes made by us and our client.
    Dashbord page shows only last 25 changes .Is there a way by which i can get all changes made on a particular date or if not how can i increase this no of latest modified pages on dashboard to  2000 or any other no.
    Please help its urgent.

  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    10 Jan 2009
    Link to this post
    Hi eraashish gupta,

    Run the query below to get the pages that have been changed:

      SELECT CC.MenuName,CB.ID,CB.DateModified,CD.Name, CC.ID, CD.LoweredName 
     
      FROM sf_CmsPageContent as CC 
      join sf_PageContentBase as CB 
      on CC.ID = CB.ID 
      join sf_PageBase as CD 
       
       
      on CB.ID = CD.ID 
      order by CB.DateModified ASC 

    Hope this helps.

    Kind regards,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
2 posts, 0 answered