Retrive view count from database

[Muffex]

Hello everyone,

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

I could not find it by now.

regards
Muffex

[cristinamr]

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

Cheers!

[Muffex]

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]

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.

[Muffex]

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]

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

Cheers,

Cristina.