Print Page - Reports

Title: Reports
Post by: jimjam on December 30, 2011, 02:49:50 PM

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

Title: Re: Reports
Post by: tarbat on December 30, 2011, 05:40:08 PM

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

Title: Re: Reports
Post by: jimjam on December 30, 2011, 07:31:00 PM

How do you run your own SQL?

Title: Re: Reports
Post by: nortonbeak on December 30, 2011, 07:51:00 PM

Quote from: jimjam on December 30, 2011, 07:31:00 PM
How do you run your own SQL?

I have attached a link.

http://www.airnavsystems.com/forum/index.php?topic=3560.0 (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.

Title: Re: Reports
Post by: jimjam on December 30, 2011, 08:45:08 PM

Thank you very much

AirNav Systems Forum

AirNav Radar => AirNav Radar Discussion => Topic started by: jimjam on December 30, 2011, 02:49:50 PM