Fix values reports

jps197225 days ago

Hi,

I have negative values for fuel in the reports. I noticed that the computed attributes were incorrectly configured. How can I manually fix the values in the database so that the reports reflect the correct values? Thank you.

Anton Tananaev25 days ago

It should be pretty straightforward if you're familiar with SQL. What is the difficulty exactly?

jps197225 days ago

I think the change I should make is in the positions, when you change a position, the server time is changed to the time of change and the change that I did is not reflected in the reports.

Anton Tananaev25 days ago
  1. Why would the server time change?
  2. Even if it does, why would it affect reports?
jps197224 days ago

That´s my question, I think because related of trigger.
I'm using MySQL Workbench and if I change any field the serverTime is updated to time of change.
For reports, the values are in positions or exists another table?
Thank you.

Anton Tananaev24 days ago

We don't have any triggers. Have you checked the schema for the table?