More on Search QSOs

[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

[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

[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

[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.

[sm4pob]

Tnx for info Tom. I think I will get a sql tool to discover the db more.
73's /Per