Display your Event Rule report ungrouped in one column

We will show you how to create a variation of the classic EV1000 Event Rule 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:
(click on the image to enlarge)

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):
(click on the image to enlarge)

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

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

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

We save this report at the bottom by clicking on SAVE and we activate this new report in our application. Follow the 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

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

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”.

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

We should have a group of new Event Rules for this purpose as in the image below:

Note that these new Event Rules can coexist without any problem with another previously created Geofence or SOS alerts you may already have in your application. The difference is that we are going to select this 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, are made only for the 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:

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