RadarBox 2008 Log File

[lennox2604]

Just downloaded 2008

And it is GOOD

My onl very very small moan is that the Flight number is not includedin daily log .


Does anybody know a SQL set of commands to extract the information from the SQL database as I now very little of programming

Thanks AIRNAV

Any chance of a HFDL programme after Ship tracker

Jim C

[tarbat]

My onl very very small moan is that the Flight number is not includedin daily log .

SELECT
  Flights.ModeS,
  Flights.Registration,
  Flights.Callsign,
  Flights.Route,
  Flights.StartTime,
  Flights.EndTime,
  Flights.Session,
  Flights.MsgCount
FROM
Flights
ORDER BY
  Flights.Registration

SQL generated using SQLite Maestro

And this retrieves almost everything from MyLog.db3:

SELECT DISTINCT
  Aircraft.ModeS,
  Aircraft.Registration,
  Aircraft.AircraftTypeSmall,
  Aircraft.AircraftTypeLong,
  Aircraft.Airline,
  Aircraft.ModeSCountry,
  Aircraft.Comment,
  Aircraft.FirstTime,
  Aircraft.LastTime,
  Flights.Callsign,
  Flights.Route,
  Flights.StartTime,
  Flights.EndTime,
  Flights.MsgCount,
  Sessions.ID,
  Sessions.Location,
  Sessions.StartTime,
  Sessions.EndTime,
  Sessions.MsgCount
FROM
Sessions
LEFT OUTER JOIN Flights ON (Sessions.ID=Flights.Session)
LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)
ORDER BY
  Aircraft.Registration,
  Flights.Callsign,
  Sessions.ID

[lennox2604]

Tarbat

Many thanks for that script

I know we have just started but how do you specify a date to isolate any day

Jim C

[tarbat]

I know we have just started but how do you specify a date to isolate any day

WHERE
  (Flights.StartTime >= "2008/03/06 00:00:00") AND
  (Flights.EndTime < "2008/03/07 00:00:00")

will give you all flights on 6th March 2008.

BTW, I know almost nothing about SQL, but using SQLite Maestro lets you create SQL using the visual query builder.

[lennox2604]

Tarbat

Many thanks for that

Jim C