Log4OM

Hello,
I have worked a lot of DXCCs DXCC Slots. Most of them are confirmed via LOTW. A lot of the unconfirmed result from the fact that the partner is not using LOTW. In the Award status/award view, i can easily see the grey "worked", but unconfirmed entities. Now, to get QSL for these entities, there are several ways:

• Wait for some time because user is using LOTW, but has not yet uploaded his log yet.
• Send paper qsl card via buero and hope for reply.
• Send paper qsl card with SAE, cash or whatever directly.
• Request paper QSL card via Clublog OQRS - Online QSL Requests

What is the most efficient way to deal with

• Find out who is using LOTW, so it makes sense to wait?
• Get a list of QSOs with unconfirmed DXCCs?
• Find the best QSL method for the QSO partners from the list?
• keep track of what has been done to get a QSL

A first idea: Filter the log for something like the following to at least get a list of affected QSOs:

select * from log where ( select count(all) from log as log1 where log.dxcc=log1.dxcc and log.band=log1.band and qsoconfirmations like '%"CT":"LOTW","S":"Yes","R":"Yes"%') = 0 ;

What do you think? Can someone with more knowledge about the database internals optimize this statement?

73 de Christian DB9CR

I feel this is worthy of being a feature suggestion so will move it there to gain more exposure

Thanks, that would be great.

I really support this idea. This one of the features I have been asking for.

Greg
WB2BIN

Hi,

A nice feature.
It would be very useful.

I've added to our feature request list on Mantis.

Hello, any updates on this feature?
73 Christian DB9CR

OK, just rechecked it myself. Most of the stuff mentioned in original post works when you just enter

( select count(all) from log as log1 where log.dxcc=log1.dxcc and log.band=log1.band and (( qsoconfirmations like '%"CT":"LOTW","S":"Yes","R":"Yes"%') or (qsoconfirmations like '%"CT":"QSL","S":"Yes","R":"Yes"%')) ) = 0

in the filter expression in the label print dialog, select all QSOs with ^A and confirm selection. The following dialogs will ask nicely for desired paper QSL method (direct, buero, etc..), they are even using data from qrz.com to propose the best method. Well done!

73 Christian DB9CR

You lost me, and likely many others. Where and how is this data string entered? Will this do a screen dump, or only to a printer?

WA2SQQ wrote: ↑21 Jun 2022, 01:52 You lost me, and likely many others. Where and how is this data string entered? Will this do a screen dump, or only to a printer?

As Christian said, go to label print and select the 'Filters' icon at bottom

Copy and paste his Reg expression to the text box having first selected 'Use custom query' click the red cross to close the window and the filter will action


BE PATIENT because it will take some considerable time if you have a large log

You ca save the filter for future use in the filter dialog window for future use.

I have tested the expression and it works very well