search

Alfresco-Business-Reporting / alfresco-business-reporting

Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against 'plain tables' containing your Alfresco business objects. The second feature is to generate reports against these reporting database and store the reports back into Alfresco. Reports can be designed using Pentaho Reporting. But feel free to use any BusinessObjects, Cognos, Clickview.
9 stars 4 forks source link

Steps to create additional tables and get more data. #8

Open kichenin opened 7 years ago

kichenin commented 7 years ago

Hi,

Thanks to your great tool we are able to fulfill most of our reporting requirements. We are able to install and use the tool on Alfresco 5.1 enterprise. To test creating of new reports and added the following line to the harvestMoreFrequent file in the reporting folder.

recordmanagement=TYPE:"rma:recordManagement" The above statement returns data when use the lucene query in the node browser. But when the harvestMoreFrequent is executed to harvest data, it only creates a table and no data is populated in that table. We would like to know if we are using the correct method to add new tables and data or there are additional step to be performed.

Another question regarding the audit data. The wiki page says "For now you can put all your Applications in the configuration UI, comma separated.". Can you please let us know how this is done in Alfresco 5.1. Any help is highly appreciated.

Thanks & Regards kichenin

RadaKichenin commented 7 years ago

Hi, I posted the query a while back and we got the answers by digging through the code. Thought it may help some one with the same query. When we add Lucene queries in the harvestDefinitionMoreFrequent file, we have to escape the : with . For Example: recordmanagement=TYPE:"rma\:recordManagement". Then the query works properly and extract data.

For the audit data harvest, you can simply add your audit application name in the auditing queries inputbox. For example: alfresco-access,alfresco-access-logout. That will create two table with the extracted data from those audit applications.