Reports

[jimjam]

Hi Guys,

Is it possible to create reports which shows just the planes that arrived and departed from a certain airport instead of having reports that show everything picked up on the Radar in that time period,

Thanks,
Jamie

[tarbat]

If you can run your own SQL, then this should work (substitute EGPE for your chosen airport code):

Code: [Select]

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)) AND
  Flights.Route LIKE "%EGPE%"
ORDER BY
  Aircraft.Registration,
  Flights.EndTime,
  Aircraft.ModeS

[jimjam]

How do you run your own SQL?

[nortonbeak]

How do you run your own SQL?

I have attached a link.

http://www.airnavsystems.com/forum/index.php?topic=3560.0

It refers to a location for downloading SQ Lite and some operating instructions are there also.

[jimjam]

Thank you very much