Fix values reports

jps1972 9 months 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 Tananaev 9 months ago

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

jps1972 9 months 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 Tananaev 9 months ago
  1. Why would the server time change?
  2. Even if it does, why would it affect reports?
jps1972 9 months 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 Tananaev 9 months ago

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