So here's the situation,
Imagine I have a dispatch software application that lives on a MSSQL db.
I can look at dispatched calls, matching a device ID to a "user" then that has a "CallID" then I can go ask another table for the rest of the records matching that "CallID"
I'd like to have this information displayed under the "state" when I click on that device. i've made the devices match the username in the other database so that lookup operation will be simple, I assume. Any advice to guide me in the right direction would be stellar.
Thanks so much
You can't do it through database. State information is coming directly from devices and stored in memory on the server.
Well, I don't want to touch Traccar's database. I want to use the web/backend to grab data from another MSSQL database and just display it in the web form "state" field.
You would need to write some java code for that.
So here's the situation,
Imagine I have a dispatch software application that lives on a MSSQL db.
I can look at dispatched calls, matching a device ID to a "user" then that has a "CallID" then I can go ask another table for the rest of the records matching that "CallID"
I'd like to have this information displayed under the "state" when I click on that device. i've made the devices match the username in the other database so that lookup operation will be simple, I assume. Any advice to guide me in the right direction would be stellar.
Thanks so much