MyLog problem?

[springbok]

not sure if this is a problem but over the last day or so i have noticed the entries in mylog are being deleted...
last night i had "aircraft 273" for the 21/5 but this morning when i look at "yesterday" it only has 213 aircraft and if i look at the previous day 20/5 there are only 91 aircraft , but on thursday evening it was around 270...
not sure if this is normal and i just had not noticed it... if i use the reporter and export the file everything is there but on the mylog a large amount of aircraft from yesterday etc which i know i had recieved, have vanished??

[tarbat]

It's a well known bug, long overdue to be fixed :(  The MyLog looks at the "Last Date/Time" field in the aircraft record.  So, if that plane has then been logged on a subsequent day (today), then it disspears from the Yesterday log report.

What the reporting should do is search throuh the Flight records for any aircraft with a flight on that day.

Here's the SQL Airnav need to use for a "Yesterday" report:

SELECT DISTINCT
 Aircraft.Registration AS "Reg",
 Flights.Callsign AS "Flight ID",
 Flights.Route AS "Route",
 Aircraft.AircraftTypeSmall AS "ICAO Type",
 Aircraft.Airline AS "Airline",
 Aircraft.AircraftTypeLong AS "Aircraft",
 Flights.StartAltitude AS "Start Altitude",
 Flights.EndAltitude AS "End Altitude",
 substr(Flights.EndTime,1,16) AS "Flight Ended",
 Aircraft.ModeS AS "Mode S"
FROM
Aircraft
LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)
WHERE
 (date('now','-1 day') = substr(Flights.EndTime,1,4)||"-"||substr(Flights.EndTime,6,2)||"-"||substr(Flights.EndTime,9,2))
ORDER BY
 Aircraft.Registration,
 Flights.EndTime,
 Aircraft.ModeS

[tarbat]

Also see http://www.airnavsystems.com/forum/index.php?topic=2190.msg18924#msg18924

[springbok]

okay thanks, i just had not noticed this before.