Most Read Pages

Brian Brown asked on August 1, 2022 17:50

Is there a a newer version of this? https://devnet.kentico.com/questions/how-to-create-most-read-block-of-a-website-in-kentico-api

I don't know if it's my data or the query but my [StatisticsObjectID] on table [Analytics_Statistics] is always null.

kentico12

Recent Answers

Brenden Kehren answered on August 1, 2022 18:28

Have you dug into the database tables to see if the field exists? This is a pretty custom query and there have been very significant database changes from v8.2 to v12.

0 votesVote for this answer Mark as a Correct answer

Chad Donnick answered on August 1, 2022 18:31

[StatisticsObjectID] exists on table [Analytics_Statistics] but every record is null.

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on August 1, 2022 18:35

Like I said, it's a very custom query and there have been significant database changes from v8.2 to v12. There have even been significant code and business logic changes so while the field exists, the use of it is no longer valid in version 12 for whatever reason. I'd suggest debugging the query more to see what it is doing and why.

0 votesVote for this answer Mark as a Correct answer