Log4OM

Posted: **03 Nov 2023, 08:25**

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

Posted: **03 Nov 2023, 09:49**

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

Posted: **04 Nov 2023, 06:48**

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

Log4OM

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

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

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

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