Display your event rule report ungrouped in one column

We will show you how to create a variation of the classic EV1000 event rule report listing each event in one column without grouping the report by vehicle/driver. This is useful to see at once what events have occurred during a selected period for a specified tag.


Before and After

Before

If we have different events in our platform and execute the EV1000, we will get the results with this layout:

blog_ev1000_ungrouped_010_s.png

After

With the following modifications, we will get our results in one column and ungrouped by vehicle (sorted by the time/date of the event):

blog_ev1000_ungrouped_011_s.png

Setup

The necessary steps to make this modification are the following:

  1. Modify the EV1000 report
  2. Create your event rules in your application
  3. Create and activate your report in your application

Modify the EV1000 report

Create a new copy of your EV1000 report

To create a new copy of the standard EV1000 report, go to the Site Admin -> Reporting -> New and select EV1000 Event Rule.

In our example we named our new __EV1000 Event Rule (custom), you can use the name you want.

Modify the report grouping and the layout

We are going to select the pink box at the left of the [Rule Name] box and we are going to edit the grouping option

blog_ev1000_ungrouped_001.png

We will remove the grouping [EventRuleID] and leave it blank.

blog_ev1000_ungrouped_002.png

We will also delete the [RuleName] text in the layout.

blog_ev1000_ungrouped_003.png

We save this report at the bottom by clicking on SAVE and we activate this new report in our application. Follow steps 1 and 2 in the following guide.

Create your event rules in your application

Now is time to create our event rules inside the application. The new event rules should be configured as follows:
- Create 1 event rule for each different event you want to list in your report (for example if you want the SOS in both states true/false you have to create 2 different Event Rules).
- Under 5. Notifications select the same Name for your Report Argument column. All Event Rules should have the same column name. In our example, we called it Event.

In this guide, we created four different notifications for two expression types (Digital Expression for the SOS true/false and Geofence Expression for Geofence in/out). The following screenshots show the configuration needed in each event rule:

Geofence IN alert
blog_ev1000_ungrouped_004.png

Geofence OUT alert
Same as before but with the OUTSIDE expression and the change in the “free text”
blog_ev1000_ungrouped_005.png

Ignition ON alert
Note that in the case of the SOS we didn’t add the “free text” because the variable SOS already comes with the text “SOS true/false”.
blog_ev1000_ungrouped_006.png

Ignition OFF alert
Same as before but with the OFF expression in the variable.
blog_ev1000_ungrouped_007.png

We should have a group of new Event Rules for this purpose as in the image below:
blog_ev1000_ungrouped_008.png
Note that these new event rules can coexist without any problem with other previously created Geofence or SOS alerts you may already have in your application. The difference is that we are going to select the new ones exclusively in our new report in the next step. Note also that these new rules do not have any visual notification on screen, and are made only for reporting purposes.

Create and activate your report in your application

Follow the steps in the following guide to activate a new report in your application.
Take into account that you should select the event rules created in the previous step as shown in the screenshot:
blog_ev1000_ungrouped_009.png

Save your report and Preview it to see if you have to modify any other parameter.