Page 1 of 1
More on Search QSOs
Posted: Mon 9. Jun 2025, 18:41
by sm4pob
Hello Thomas,
I've been looking at the "Search QSOs" trying to get a worked dxcc list with qso data when first worked. Something like
select distinct dxcc, callsign, qsodate from x
where band = 6m
order by qsodate asc
but can't find a way to do it. Question is, is it possible?
A similar list for worked grids would also be nice.
73 /Per
Re: More on Search QSOs
Posted: Mon 9. Jun 2025, 19:39
by DL2RUM
Using a SQLite tool this should work:
Code: Select all
select dxcc, callsign, datetime, band, mode from logbook group by dxcc order by dxcc, min(datetime)
In RL you need a dummy for the where clause:
- Query
- Result
Re: More on Search QSOs
Posted: Tue 10. Jun 2025, 03:17
by sm4pob
Many thanks Tom.
Works great.
Using this for dxcc: qrg < 51 and qrg > 49 group by dxcc order by dxcc, min(datetime)
and this for grids: qrg < 51 and qrg > 49 group by substr(locator,1,4) order by locator, min(datetime)
/Per
Re: More on Search QSOs
Posted: Tue 10. Jun 2025, 08:50
by DL2RUM
Frequency must be given in kHz! You can use the band information as well. You can combine options to get results by modes:
Code: Select all
select * from logbook where band = '20m' group by dxcc,mode order by dxcc, mode, min(datetime)
- I'm not very active on 6m, here the result for 20m as example.
It's also interesting to see, when a country was worked for the
last time:
Code: Select all
select * from logbook where band <> ''group by dxcc order by dxcc, max(datetime)
- 25 entities I worked for more than 25 years ago the last time.
Re: More on Search QSOs
Posted: Tue 10. Jun 2025, 09:10
by sm4pob
Tnx for info Tom. I think I will get a sql tool to discover the db more.
73's /Per