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.