Support

Expand all | Collapse all

Item connected users in report

  • 1.  Item connected users in report

    Posted 06-19-2017 08:25
    Hello,

    I wanted to create a report where I can see items with their connected users (editors, creators, commeters, mentions). I tried to find them in BIRT, but all I could find was a count of unique connected users. I want to get connected user names and show them in the report for each item. Something similiar to the Connected Users view.
    Is there a way to get these users in a report? A specific SQL query?

    Best regards,

    ------------------------------
    Rudolfs Sviklis
    AA Projekts
    ------------------------------


  • 2.  RE: Item connected users in report

    Posted 06-19-2017 20:07
    Hi Rudolfs,
    I will check with my report expert colleague in the morning and try and get you an update soon.Thank you for your patience. 


    ------------------------------
    Dana Medhaug
    Business Support Engineer
    Jama
    ------------------------------



  • 3.  RE: Item connected users in report

    Posted 06-21-2017 17:28
    Rudolfs,
    I reached out to our report expert and this is what she had to say...
    There's isn't a good way to do this with BIRT - at least without manually getting the info in a query. Same with Velocity. I am not even sure what constitutes a connected user - probably an editor and a commentor, but not sure if there's anything else. So they would have to get version creator for the editor, then user in jamacomments. Not sure what else.


    ------------------------------
    Dana Medhaug
    Business Support Engineer
    Jama
    ------------------------------