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

Login with username, password and session length
 


Author Topic: Daily report - any conditions possible ?  (Read 2658 times)

0 Members and 1 Guest are viewing this topic.

llama1910

  • New Member
  • *
  • Posts: 8
Daily report - any conditions possible ?
« 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

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Daily report - any conditions possible ?
« Reply #1 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.
« Last Edit: March 26, 2009, 09:09:33 AM by tarbat »

llama1910

  • New Member
  • *
  • Posts: 8
Re: Daily report - any conditions possible ?
« Reply #2 on: March 26, 2009, 03:45:24 PM »
Thank you very much, I'll try that