amanda.r
-
5/8/2009 8:56:16 AM
RE:Popular Posts
Support responded with the following:
In this case You will need to use repeater with custom query. At first you will need to select appropriate documents you want to display and then order them by the page views. In web analytics module there is already report for the page views. The SQL query used to get the number of page views and the document path is like this:
SELECT TOP 100 DocumentNamePath, SUM(HitsCount) FROM Analytics_Statistics, Analytics_DayHits, View_CMS_Tree_Joined WHERE (StatisticsSiteID = 2) AND (StatisticsCode='pageviews') AND (StatisticsID = HitsStatisticsID) AND(StatisticsObjectID = NodeID) AND (StatisticsObjectCulture = DocumentCulture) AND (HitsStartTime >= '1.1.2009 0:00:00') AND (HitsEndTime <= '6.5.2009 0:00:00') GROUP BY DocumentNamePath ORDER BY SUM(HitsCount) DESC
StatisticsSiteID, HitsStartTime, HitsEndTime may all need changed.
I'm still having trouble making this work. But at least I have the logic to work with.
|