Clarity

  • 1.  Report for documents available in Collaboration

    Posted May 04, 2017 02:31 AM

    Hi All,

     

    Good Day!

     

    I have requirement to create a report(Portlet or jaspersoft report) for the documents available in the collaboration.

     I need retrieve the document version and respective project id by grouping by Document category and i have changed the category from DOC CATEGORY lookup  and i do not have idea to how to get the table and column name of the document which is available in collaboration.

     

    And i need to include respective project ID and document version in the portlet or jaspersoft report.

     

    I have attached my lookup values.

     

    Can some one help me on this.



  • 2.  Re: Report for documents available in Collaboration

    Posted May 04, 2017 08:25 AM

    This might help

     

    HELP - Need help with "joins" in my Query 

     

    https://communities.ca.com/message/99258438  

     

    NJ