More options in Date Report

The "to-do" list for Virtual Radar Server is as long as my arm, but if you want to pile more work onto it then this is for you.
Post Reply
Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

More options in Date Report

Post by Sentry_e3 » Fri Jul 19, 2013 8:09 am

Hello

Could it be possible to add the ''altitude'' criteria in the ''date report'' option? I live near an airport and i wish i could know which aircraft has landed (or has taken off) on it. For now the only way to check that is to take each aircraft to see the recorded altitude...

Thanks a lot for your answer :)
Last edited by Sentry_e3 on Wed Aug 07, 2013 8:42 am, edited 2 times in total.

agw
Posts: 2248
Joined: Fri Feb 17, 2012 3:20 am

Re: Altitude in Date Report

Post by agw » Sat Jul 20, 2013 12:40 pm

Yes - the reports will be getting a makeover in the next big release when the web site output gets re-written.

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: Altitude in Date Report

Post by Sentry_e3 » Sat Jul 20, 2013 1:00 pm

Excellent :P

bigrossco
Posts: 19
Joined: Sat Jun 08, 2013 11:53 am

Re: Altitude in Date Report

Post by bigrossco » Sat Jul 20, 2013 7:52 pm

sounds good, when is the next release as cant wait for what you have been saying will be coming :)

agw
Posts: 2248
Joined: Fri Feb 17, 2012 3:20 am

Re: Altitude in Date Report

Post by agw » Wed Jul 24, 2013 12:29 am

It's going to be a while yet, but hopefully by the end of the summer. Depends on how much free time I get :)

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: More options in Date Report

Post by Sentry_e3 » Wed Aug 07, 2013 8:50 am

In the date report, could it be possible in the ''callsign'' field to use an option I have found in ''SQL Lite manager'':

"=" or "contains" or "begins with" ?

With the current system you have to type the entire callsign to have a positive result, if you miss a letter or a number it returns a 0 result. With "contains" or "begins with" it's very easy to find a group of flights for example. As i said it's already possible in SQL lite but only flight data is shown, nothing about the aircraft except the database number...

What do you think about it? Would it be difficult to add?

Best regards

agw
Posts: 2248
Joined: Fri Feb 17, 2012 3:20 am

Re: More options in Date Report

Post by agw » Fri Aug 09, 2013 6:07 pm

I'm currently rewriting the website that VRS generates - I've not done the rewrite of the reports yet but in other places where there are filters / criteria on the aircraft list I've been using a more flexible approach to specifying the criteria where you can tell it the condition to use. The intention is to do the same with the reports.

However with the reports there is a potential problem to be aware of in that if you were to do the "callsign contains XYZ" thing then SQLite can end up having to go through every record to see if it has a match, which would mean that on a reasonably large database it's going to be slow and it's going to hammer the disk. With equals or begins-with SQLite can use the indexes so it's pretty quick.

Sentry_e3
Posts: 81
Joined: Wed May 15, 2013 11:57 pm

Re: More options in Date Report

Post by Sentry_e3 » Sat Aug 10, 2013 4:55 pm

Ok, thank you for your explanations!

trabin
Posts: 24
Joined: Sun Mar 31, 2013 2:08 pm

Re: More options in Date Report

Post by trabin » Thu Sep 12, 2013 12:41 pm

Can you add ICAO Operator report and hex country report?

Post Reply