SQL ?
Re: SQL ?
For a prefix from the log use criteria G* in Callsign field (finds all G callsigns) this is not accurate for Countrries though so you need any of below....
For a country search from log, one method is:
Open DXCC database - in left side DXCC list, right-click required Country and select option "Lookup all *Country* in Log"
Search Page will list all QSO with that country.
There are other similar methods....
...in Log Page -again right-click Callsign and find all same countries as selected country.
...you can do same thing in DXCluster window.
See this link:
http://help.winlog32.co.uk/hlp_dxcc_dxcclogreport.aspx
You can also use the CODE field in the Search window (like your example) and enter Country code, you can find the relative 'code' for each country in either menu/Graph/Log DXCC Display or in menu/Graph/Log DXCC Band Display or in the DXCC database left country list.
73 Colin
G0CUZ
For a country search from log, one method is:
Open DXCC database - in left side DXCC list, right-click required Country and select option "Lookup all *Country* in Log"
Search Page will list all QSO with that country.
There are other similar methods....
...in Log Page -again right-click Callsign and find all same countries as selected country.
...you can do same thing in DXCluster window.
See this link:
http://help.winlog32.co.uk/hlp_dxcc_dxcclogreport.aspx
You can also use the CODE field in the Search window (like your example) and enter Country code, you can find the relative 'code' for each country in either menu/Graph/Log DXCC Display or in menu/Graph/Log DXCC Band Display or in the DXCC database left country list.
73 Colin
G0CUZ
Re: SQL ?
Hi Nico
Selecting all countries in a Continent from the log would be very difficult, as Winlog32 does not store this information in the Log,, but processes this information 'on-the-fly' during logging.
It is not impossible but really too much work as you would have a really BIG query and manually include each and every entity code from that continent, I think it is not practical!
You would need to include in the SQL ' ... WHERE CODE = 233 OR CODE =248 OR CODE = ... and so on" (this would find all England and Italy QSO - it's a start hi) You can use as many SQL operators as you wish ('AND' 'OR' 'NOT' etc)
IN SQL -to find all England on 6m "Select * FROM LOG where CODE = 233 AND BAND Between 50 AND 52 Order by Callsign" -you can expand this simple example how you wish, the above SQL is similar to that used in existing DXCC Display windows for filtering the log data but perhaps you like experimenting with SQL Language?
73 Colin
G0CUZ
Selecting all countries in a Continent from the log would be very difficult, as Winlog32 does not store this information in the Log,, but processes this information 'on-the-fly' during logging.
It is not impossible but really too much work as you would have a really BIG query and manually include each and every entity code from that continent, I think it is not practical!
You would need to include in the SQL ' ... WHERE CODE = 233 OR CODE =248 OR CODE = ... and so on" (this would find all England and Italy QSO - it's a start hi) You can use as many SQL operators as you wish ('AND' 'OR' 'NOT' etc)
IN SQL -to find all England on 6m "Select * FROM LOG where CODE = 233 AND BAND Between 50 AND 52 Order by Callsign" -you can expand this simple example how you wish, the above SQL is similar to that used in existing DXCC Display windows for filtering the log data but perhaps you like experimenting with SQL Language?
73 Colin
G0CUZ
Re: SQL ?
[quote="IT9PQJ"][size=150]Hi Colin,
it does not show the QSO in the picture (which self-explanatory). [/size]
[size=150]How could it be solved?[/size][/quote]
Hi Nico
In the actual SQL QUERY (white) window above, manually change the last part like this
... Band between 14 and 14
Should work good, but there are much easier ways to get this information from Winlog32 existing functions like mentioned before.
73 Colin
G0CUZ
it does not show the QSO in the picture (which self-explanatory). [/size]
[size=150]How could it be solved?[/size][/quote]
Hi Nico
In the actual SQL QUERY (white) window above, manually change the last part like this
... Band between 14 and 14
Should work good, but there are much easier ways to get this information from Winlog32 existing functions like mentioned before.
73 Colin
G0CUZ
Re: SQL ?
hi Nico
Yes, I am sorry, there was a typo in my reply "between 14 and 14 ", hi hi.
Should have been 14 to 15 - but you have it all OK 14 to 14.350 will work fine, but for appropriate decimal character e.g. "," or "." for any fraction according to Windows number format.
In SQL window, you can also 'sort' the return results like this "...between 14 and 15 ORDER BY Band, Mode"
73 Colin
G0CUZ
Yes, I am sorry, there was a typo in my reply "between 14 and 14 ", hi hi.
Should have been 14 to 15 - but you have it all OK 14 to 14.350 will work fine, but for appropriate decimal character e.g. "," or "." for any fraction according to Windows number format.
In SQL window, you can also 'sort' the return results like this "...between 14 and 15 ORDER BY Band, Mode"
73 Colin
G0CUZ