topic Re: Retrive view count from database in Alfresco Forum

Retrive view count from database

Muffex — Sat, 17 Jul 2021 15:02:30 GMT

Hello everyone,

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

I could not find it by now.

regards
Muffex

Re: Retrive view count from database

cristinamr — Mon, 19 Jul 2021 08:50:01 GMT

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!

Re: Retrive view count from database

Muffex — Mon, 19 Jul 2021 22:21:12 GMT

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

Re: Retrive view count from database

cristinamr — Tue, 20 Jul 2021 07:03:42 GMT

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.

Re: Retrive view count from database

Muffex — Tue, 20 Jul 2021 21:59:02 GMT

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

Re: Retrive view count from database

cristinamr — Wed, 21 Jul 2021 07:07:06 GMT

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

Cheers,

Cristina.