AirNav Systems Forum

AirNav Radar => AirNav Radar Discussion => Topic started by: llama1910 on March 26, 2009, 05:51:30 AM

Title: Daily report - any conditions possible ?
Post by: llama1910 on March 26, 2009, 05:51:30 AM
Hi,

I would like to use the daily report generator to produce a log of all incoming and outgoing traffic to our airport. Is it possible somehow to include any conditions in the report ?
I.e. only write aircraft into the report whose start or end GS is less than 150kts ?

Cheers
Carsten
Title: Re: Daily report - any conditions possible ?
Post by: tarbat on March 26, 2009, 07:57:21 AM
Only by using something like SQLite Maestro (or another SQL program) to write SQL to produce such a report.  Something like this:
SELECT *
FROM
Flights
WHERE
  (Flights.StartGS < 150) OR
  (Flights.EndGS < 150)

You might be able to adapt the SQL script I've posted on another thread.
Title: Re: Daily report - any conditions possible ?
Post by: llama1910 on March 26, 2009, 03:45:24 PM
Thank you very much, I'll try that