AirNav Radar
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Reports  (Read 3249 times)

0 Members and 1 Guest are viewing this topic.

jimjam

  • New Member
  • *
  • Posts: 33
Reports
« 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

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Reports
« Reply #1 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

jimjam

  • New Member
  • *
  • Posts: 33
Re: Reports
« Reply #2 on: December 30, 2011, 07:31:00 PM »
How do you run your own SQL?

nortonbeak

  • Sr. Member
  • ****
  • Posts: 318
  • RadarBox MVT7100 PCR1000 M0NBK
Re: Reports
« Reply #3 on: December 30, 2011, 07:51:00 PM »
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

  • New Member
  • *
  • Posts: 33
Re: Reports
« Reply #4 on: December 30, 2011, 08:45:08 PM »
Thank you very much