Forum Discussion

aravikum's avatar
aravikum
Contributor
8 years ago

Is it possible to check how many users have been using URL as Review materials using Database?

Hi All,   Please let us know, Is there any way for filtering out the number of users who are using URL upload for the Review Materials. In case of Database, atleast let us know the Table name in wh...
yimy's avatar
yimy
Community Manager
8 years ago

Hi,

 

I believe it could be possible, but it would involve, at least two tables. On the other hand, there is not a column in a table that says if the uploaded file is an URL link/path, or something else. They do, however, have the "http(s)" string, which can be used to filter out these URL links.

 

The tables to consider are, 'version' and 'userversionaction'. You might also need the 'user' table to list the actual names of the users along with their IDs.

 

Take a look at this link for an overview of Collaborator's database schema:

https://support.smartbear.com/viewarticle/91536/

 

I hope the information was helpful.

 

Thanks,

Yimy

  • aravikum's avatar
    aravikum
    Contributor
    7 years ago

    Thanks for the reply.

     

    But, we are not able to find the userversion action table and also let us know which field values shows https string in version table.

     

    Thanks and Regards,

    Avinash

    • yimy's avatar
      yimy
      Community Manager
      7 years ago

      Hi,

       

      Sorry for not replying sooner.

       

      I am attaching a screenshot of the tables that I was referring as well as the fields/columns.

       

      I hope it helps.

       

      Thanks,

      Yimy

      • aravikum's avatar
        aravikum
        Contributor
        7 years ago

        Hi Yimy,

         

        Thanks for the reply. But we are not able to find the 'https' under version_filepath in the listed table. Please find the attached screenshot for reference.

         

        Thanks and Regards,

        Avinash