Вы не вошли. Пожалуйста, войдите или зарегистрируйтесь.
Is there a way to create a report for a driver to get 'Sensor tracing' table data from all the bound units for that driver?
These are the only report tables that I can see for a driver
Bindings,
Custom fields,
Driver activity,
Eco driving,
Infringements,
Orders,
SMS messages.
It would be great if there is a way to retrieve unit report tables data from all units bound to a driver in a time interval.
Hi, i think you missunderstand something, drivers are bound to a Unit and not units to drivers.
Drivers can be bound to more than one Unit, but makes that sense?
Wolf.
Yes, I understand that.
What I would like to do is to get the sensor tracing table data by driver.
So the returned report data will contain the sensor tracing table information for multiple units bound to a driver during a specific time period.
I should be able to query the data by driver, not by unit.
Sorry, i still dont understand what you want.. what do you mean by sensor tracing table information??
And multiple units can not "bound" to a driver.
You can create a driver report (driver focused) and show there some sensor status,
you can also create a Unit Report, show the driver and the status, but you can not create a driver report which shows all drivers and the vehicles it is bound to and the sensor status of this vehicles.
(or use the SDK/API for it)
Wolf.
I am sorry that I am not being clear enough.
Consider this scenario.
Driver1 - bind to unit1 at 10.00 am
Driver1 - unbind from unit1 at 12 pm
Driver1 - bind to unit2 at 12.15 pm
Driver 1 - unbind from unit2 at 7.00pm
Now I would like to retrieve the sensor tracing tables for all the units bound to Driver1 (uni1 and unit2) for the time period 10.00am to 7.00pm. So the data will contain the information for unit1 and uint2 since they were the units bound to driver1 during 10.00am to 7.00pm.
Hope this makes the requirement clearer.
Also you said in your previous reply I can create a driver focused report and display sensor data. Would it be possible for you to give more direction on how to achieve that?
Thanks for all the help here.
Hi M-Ram,
i dont think that you can archive in one table what you want to know because driver bindings = a driver report and sensors report = a unit report. So they are fundamentaly different.
You can get the report by creating it via the SDK/Api. (Or Gurtam impement it but than you need to explain how many units you will sell additionaly if they implement this function and they will calculate if they earn money with it or loose money ;-)
Regarding driver: You can create a driver report and sensors status i was wrong, sorry, i just checked the reports... no sensorstatus at time of binding.
So if you want to have everything in one report ---> API/SDK
Best regards
Wolf.
Hi Wolf, Thanks again for taking the time to help us with this.
Do you have PHP Developer ressources? Why not creating your own report and just use the data of Wialon reports and build your own by using the API?
Here are a lot of Gurtam Partners that has ressources and can build that for you.
Wolf.
Hello m-ram,
I'd like to notify you that we are planning to add a new table "Rides" to the reports for drivers/groups of drivers.
Could you explain your idea with more details? What business-case do you want to solve? We hope that this new table will help you with your problem.
Best regards,
