OFBiz Tutorial: Implement a Screen to Fetch and View Logs from NoSql MongoDB

Arun PatidarPublished: Updated:

fetch and view logs from NoSql MongoDB using OFBiz Webtools

 It’s like magic! Today’s OFBiz tutorial from HotWax Systems details how to customize and use OFBiz Webtools to fetch and view logs from NoSql MongoDB. Work smarter, not harder with our MongoDB Tutorial Series.

In the first installment of our Mongo DB series, we showed you how to store OFBiz logs in MongoDB, the popular NoSql database. Today’s installment provides detailed instructions about how to create a screen in OFBiz to fetch and display the logs stored in MongoDB.

The Webtools application, enabled by default when OFBiz is started, is a central place to access a series of tools for the monitoring and administration of the OFBiz instance: we will enhance the Webtools application by adding the new screen to it.

HotWax Systems_MongoDB_OFBiz


In this tutorial we assume that MongoDB and Apache OFBiz are properly setup and configured in your system in order to have OFBiz logs stored in MongoDB: before proceeding, make sure you have successfully followed the steps described in the first installment in the MongoDB Series.

Step-by-step guide

Steps 1 to 6 describe how to customize an existing application by adding a new service, screen and menu definitions; they are not specific to MongoDB and are useful to refresh your OFBiz programming skills.

If you are already confident with the subject and you can’t wait to play with MongoDB API, then you can jump to step 7, where we describe how to connect to MongoDB and fetch the logs.

1. Add a menu item in OFBiz for the new screen. Add this menu item to the menu named “LoggingTabBar” in file framework/webtools/widget/Menus.xml. as shown below:

A menu item titled “View MongoDB Logs” has now been created.  When selected, this link triggers the controller request. It will then create a menu button in the Webtools logging menu, which will look like this:


2. Add a request and view map to the Webtools controller (framework/webtools/webapp/webtools/WEB-INF/controller.xml). Here is the associated code snippet:

With this configuration, the URL generated by the menu item created in step 1 is associated to the “LogViewMongoDb” screen.

3. Add a screen definition to the LogScreens.xml in framework/webtools/widget/LogScreens.xml as shown in following code snippet:

OFBiz Screens define how data is prepared and rendered. In the above screen definition, the data is prepared by a Groovy script (LogViewMongo.groovy) and is rendered by a FreeMarker template (MongoDbLogs.ftl). The Groovy script is implemented in step 4 and the FreeMarker template is implemented in step 5. A button for refreshing the screen is also defined in the screen.

4. Create a Groovy file to prepare the data for our screen in the  framework/webapp/webtools/WEB-INF/actions/log folder. Name the file LogViewMongo.groovy. The content of the file is the following:

The script simply calls an OFBiz Service to which we delegate the task of fetching the data from MongoDB. The service definition and implementation are described in step 6 and 7.

5. Create a new FreeMarker file in the framework/webtools/webapp/webtools/log folder to render the data. Name the file MongoDbLogs.ftl. The content of the file is the following:

This template iterates over the list of logs prepared by the Groovy script in step 4 and renders an HTML page with information from each log entry.

6. Create a service definition for the service responsible for fetching log data from MongoDB. To accomplish this, define the service in the framework/webtools/servicedef/services.xml file by adding the following definition:

The service will return the most recent log entries in a List object named “logList”.

7. Finally, implement the service defined in step 6. To accomplish this, add one Java file at framework/webtools/src/org/ofbiz/webtools folder with name “MongoDbServices.java”. Here is  the complete code for this class:

The above implementation is just a simple example that can be enhanced. A method named “getConnectionMongoDb” establishes a connection with the Mongo database. The DBCollection object provides various methods to fetch and insert the data: you can get more information about DBCollection API here. The “getAllLogsFromMongoDb” method fetches the last logs (up to 400) and returns them in the List named “logList”.


We can now build and start OFBiz by using the command “./ant build start”.

Login to the Webtools application and go to the “Logging” tab. Click on the new menu of “View MongoDB logs”. You should now be able to see the logs stored in MongoDB. The screen should look like this:

MongoDB_OFBiz_Final screen

 This concludes the 2nd installment in the MongoDB series. In the next installment, we will enhance our screen by adding filters to search through logs for different log levels.

To learn more about how HotWax Systems can help you use the power and flexibility of OFBiz to benefit your business, contact us for a free consultation.

Arun Patidar About Arun Patidar
Arun Patidar is a Manager of Enterprise Software Development with HotWax Systems. Arun is an e-commerce ERP enthusiast and full time developer with expertise on OFBiz. He enjoys participating in the OFBiz community and sharing his thoughts on new interventions in the OFBiz community.

Leave a Reply

Your email address will not be published. Required fields are marked *