0 Replies Latest reply on Jan 5, 2016 11:07 PM by lfl1001

    How to get "upload a file" document attachment download number?

    lfl1001

      Hi experts,

       

      I'm trying to track user downloads number from jivedw_activity_fact table. I know the columns activity_type = 320 & director_object_type = 13 means the attachment download, (referred Re: How can I see metrics for downloading a doc attachment? )

       

      But for kind of the "upload a file" document, I can't find any object_type = 13 records matching the attachment name at the bottom of each document, For example:

       

      I have a "upload a file" document with following attachment:

      Query jivedw_object table comes no record of object_type = 13:

       

      select * from jivedw_object where name = 'vmware-oracle-rac-deploy-guide.pdf'

       

       

      So I look deep into the jivedw_activity_fact table, then I found following records,

       

      activity_type = 320, director_object_type = 102, indirector_object_type = 110 What's the meaning of 110?

       

      activity_type = 320, director_object_type = 102, indirector_object_type is null

       

      What's the meaning of those records? I use Jive 6

       

       

      PS: document created by "upload a file"