how to get document visit count in transformation

hadi tag asked on July 20, 2015 07:46

hi,

how to get document(news page) visit count in transformation??

document visit count

Correct Answer

Roman Hutnyk answered on July 20, 2015 15:59

I'd implement custom query, which fetches this data from web analytics table, like:

select viewscount
from  ...
where documentId = @curentDoc

Having this value you can simply write <# Eval("viewscount") #> in ASPX transformation, or {%VIEWSCOUNT%} in TXT/XML one.

The other option is to implement single value report and place it in the web part on the page.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on July 20, 2015 19:35 (last edited on July 20, 2015 19:35)

Any way you do it, I'd suggest making sure your data is cached because the analytics tables typically hold millions of records and it could be a huge performance hit.

0 votesVote for this answer Mark as a Correct answer