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
If we have different events in our platform and execute the EV1000, we will get the results with this layout:
With the following modifications, we will get our results in one column and ungrouped by vehicle (sorted by the time/date of the event):
The necessary steps to make this modification are the following:
- Modify the EV1000 report
- Create your event rules in your application
- 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 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 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 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:
Save your report and Preview it to see if you have to modify any other parameter.