Hi, we are hoping to understand the use of our public site better by looking at ResourceSpace reports.
When I run the Resource views report it gives me very high numbers though, for example in the last seven days it indicates 479 views for one journal issue, and 183 views of one artwork.
Does anyone know what triggers this value to be incremented? Does
it mean someone looked the item up and they selected it from the results
list?
I'd be grateful if anyone can point us in the right direction.
Doug Fox
Here's the code:
select r.ref 'Resource ID',
(
SELECT rd.value
FROM resource_data AS rd
WHERE rd.resource = r.ref
AND rd.resource_type_field = 8
LIMIT 1
) 'Title',sum(count) Views from resource r,daily_stat d where r.ref=d.object_ref and d.activity_type='Resource view'
[insert code to limit by date range]
group by r.ref order by Views desc;