Top QSO partners & Auto set SENT, RCVD values in LazyLog by TX mode

[DM1TBE]

I hope this hasn't been discussed before....

I'd like to get a list of my top QSO partners with callsigns, the number of QSOs, and their names, sorted in descending order by the number of QSOs.

Why do I want this? I am a regular activator of SOTA, POTA, and sometimes WWFF. As such, I have people who call me regularly, with one of my top chasers having over 40 QSOs this year. As a token of appreciation, I'd like to greet them by name when paper logging in the field. While SOTA offers a "Top Chaser" statistic, POTA and WWFF do not.

Additionally, a minor improvement would be to automatically set "SENT" and "RCVD" in LazyLog if you set TX to CW, LSB, USB, and FM.

Many thanks in advance for consideration

[HB9BRJ]

Unfortunately (and for reasons unknown to me), Utilities > QSO Manager > Direct SQL does not run SELECT queries. So you have to access the database (a copy of it to be safe) with a database tool such as https://www.etl-tools.com/database-brow ... rview.html
and run the following query:

Code: Select all

Select
  callsign,
  name,
  Count(qsoid) As QSOcount
From Log
Group by
  callsign, name
Order by QSOcount Desc

See the resulting output (calls and names made invisible) in the attachment.

73, Markus HB9BRJ

[DM1TBE]

Thank you, Markus. It is an interesting workaround. It does what I was looking for