Hello All,
Analysing my reports since version 2.0 I understand that every Aircraftreg will be reported once a day. This while many of de same Aircraftregs make more different flights during the day in my area of reception. So it looks that the programm overwrite the forgoing flight of a specific Aircraftreg.
When it is the intention of the Reporterfunction to report Aircraftregs only then it looks all normal. But I was hoping that it should report all different flights as well.
So I am asking me or all this is normal or is this a problem that should be solved?
I am verry interested in how other members look to this.
Hi,
It's correct that the reporter function only makes a list of aircraft contacted that day or the day before. It doesn't show you how many times the aircraft was seen.
If you want to make a report for other days or only for a certain airline, then you should use the filters in the grids of MyLog and then you need to make a report via the "tools" menu.
Also via that way you would only see a single line for an aircraft and not how many times the aircraft was seen that day.
It would be interesting to have the possibility to make a report for a certain aircraft or a certain airline to see how many times they came over our heads.
You could run something like this in SQL:
SELECT DISTINCT
Aircraft.LastTime,
Aircraft.ModeS,
Flights.Callsign,
Flights.Route,
Aircraft.Registration,
Aircraft.AircraftTypeSmall,
Aircraft.Airline,
Flights.EndTime
FROM
Aircraft
LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)
WHERE
(Aircraft.LastTime >= "2008/09/06")
ORDER BY
Aircraft.ModeS
Hi,
Thank you all for your reaction. Highly appreciated!
But, how more I analyse the reports how more "strange things" I see.
Yesterday evening the totalnumbers of seen aircraft of saturday, september 6th, was about 2700. Now this morning, when I generate the same report, it was decreased to round about 2000. Also 700 aircrafts gone. The same happens the day before.
Verry striking also is the disappear of almost all (also NOT all) KLM Airbusses A332 from the reports. Yesterday evening when I looked to the report 10 KLM Airbusses where seen. This morning, when I generate the same report only two left. The day before yesterday the same happens as well.
For your further information: I have NO filters on!!
Until sofar I do not see where I made wrong settings in the programm. Any help will be verry welcome.
A modification to my report, so that it always shows YESTERDAY's flights:
SELECT DISTINCT
Aircraft.ModeS,
Flights.Callsign,
Flights.Route,
Aircraft.Registration,
Aircraft.AircraftTypeSmall,
Aircraft.Airline,
Flights.EndTime,
date('now','-1 day') AS FIELD_1,
substr(Aircraft.LastTime,1,4)||"-"||substr(Aircraft.LastTime,6,2)||"-"||substr(Aircraft.LastTime,9,2) AS FIELD_2
FROM
Aircraft
LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)
WHERE
(FIELD_1 = FIELD_2)
ORDER BY
Aircraft.Registration,
Aircraft.ModeS