Our goal? Making
complex simple

19 April 2016

How to use the Reporting 4 Mendix Module?

Pim van der Noll
Chief Technology Officer

Your app contains valuable data and you want to show your users great information based on this data, but how are you going to do this efficiently in your Mendix App?

Why would you use the Reporting 4 Mendix Module?

OQL is powerful within Mendix but it is limited to use in the Mendix modeller. OQL is a query language that’s looks like SQL. OQL uses the associations in your domain model and therefore is simple to understand if you have used SQL language in the past. An OQL query delivers data even faster than a microflow. A microflow gives you the results in multiple steps and is not always efficient in retrieving the data. With large amounts of data / big data, the difference is significant. The module is set up in a way that you can join from entity to entity, which means you’re not limited to “1 join”.

Which powerful solutions provides the Reporting 4 Mendix module?

  1. Create charts
  2. Export to Excel
  3. Provide fast answers for customer questions about data in their app
  4. Create input for automated If This Then That actions
  5. Enable Spotlight search

 

1. Create Charts

There are some nice widgets from the Mendix Appstore which you can use to build charts. These charts will show data in a fast way and are only of value if you give them good data.

Step 1. Prepare Mendix objects and your query
Step 2. Fill Mendix result objects


See Modelshare

Step 3. Show page where the widget is on:


See modelshare

2. Export to Excel

If a customer wants to use an Excel template, you can make the required data available through the Reporting 4 Mendix Module. Easy to adjust in runtime, no new deployment necessary.

Step 1. Prepare data and query
Step 2. Fill Mendix result objects
Step 3. Show the page with the data-grid containing the data and make an export to Excel.

3. Provide fast answers for customer questions about data in their app

“Can you give me all the customers where the rule applies that … and …. that only …?

This kind of questions you will surely receive after the app is in production. You want to give your customer a fast answer and you don’t want to perform a new deployment. An OQL query can be put together quickly and you can see the results immediately.

Step 1. Create a new query at runtime
Step 2. Select your attributes from your entities (not first joined and filtered)
Step 3. Generate and export.

4. Create input for If This Then That Module

The If This Then That module from Appronto uses the Reporting 4 Mendix Module as base to timely look if a query delivers certain results. If yes, the module will run a structured action (e-mail, task, push notifications etc.). This is also completely adjustable without a new deployment.

Step 1. Configure your IFTTT rule
Step 2. Create and connect the query from the Reporting 4 Mendix module.


Step 3. Create the action that has to be executed
Step 4. Activate your IFTTT rule

5. Enable Spotlight Search powered

The Spotlight Search module is a generic search module for your Mendix app. It uses the strength of OQL combined with the generic possibility to have the results directly available in your app. A search function is now generic and can be deployed fast. Follow the documentation at: https://appstore.home.mendix.com/link/app/2398/Appronto/Appronto-Spotlight-Search.

Click here for a live demo!

Try out Reporting 4 Mendix Module

Download the module and install it locally. Here you can do anything you want with the module without any cost and limitation. Add it to your app and create amazing dashboards with great performance. Show this to your users and they will be amazed. To use the module in your production environment you need a license.

Feedback!

Your own apps become better after feedback from your customers. Our modules will get better with your feedback! Let us know what you think or adjust the module to your own insights.

Download this module in the Mendix App Store!