Retrive view count from database

cancel
Showing results for 
Search instead for 
Did you mean: 
Muffex
Active Member

Retrive view count from database

Hello everyone,

is the view count of any given node stored in the database?

I could not find it by now.

regards
Muffex

5 Replies
cristinamr
Advanced

Re: Retrive view count from database

Hi!

What is exactly your requirement? My recommendation: forget about to get anything from database, it's not recommended and, in addition, is dificult (not made for begginers).

Maybe if you explain a little bit more your req we can give you other affortables alternatives Smiley Happy

Cheers!

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc
Muffex
Active Member

Re: Retrive view count from database

Hey.

Thanks for your answer.

I'm dependent on getting all information from the database. Is there any way to retrieve the view count of (content) nodes from the database? Is this information even stored in the database?

regards
Muffex

cristinamr
Advanced

Re: Retrive view count from database

Hi!

Yes you can extract the info you need. Check this post.

Other resources that can be helpful:

Alfresco: some useful database queries 

Other examples

Step by step approach to running sql queries on Alfresco DB

 

Cheers,

Cristina.

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc
Muffex
Active Member

Re: Retrive view count from database

Hello @cristinamr,

thanks again for your answer! 

While I'm sorry, I couldn't find any information in any of the links you provided about querying the number of views.
However, under this article it was asked for, but the person did not get an answer.

According to this post, it's probably not possible, unfortunately.

Does anybody have any ideas? Maybe using the audit log?

regards
Muffex

 

cristinamr
Advanced

Re: Retrive view count from database

As far as I know, you cannot. Yo can extract information about nodes, people, properties, etc...

Cheers,

Cristina.

--
VenziaIT: helping companies since 2005! Our ECM products: AQuA & Seidoc