We user SugarCRM Sell hosted in the cloud.
When I perform a custom query like this:
select *
from tracker t
where action = 'detailView' and module_name = 'Reports'
order by date_modified desc
The data exported just seems to be the date_modified field being updated every time the report is open.
(due to the confidential nature of the data, I can't share a screenshot).
I guess a few questions. For the action column, am I looking at the right value 'detailView'?
And if I am looking at the data in the right way, would it be possible to update the Tracker module to have a count column that is incremented every time a detailView action happens?
We would like this information to know which reports are most accessed and how many times they are being access by our users.
Any information would be greatly appreciated!
All the best,
Geoff
