Qury assistance

[WA2SQQ]

Looking for some assistance to create a query. I'd like to know which countries I've worked, but have not received a verification. I'd like to ignore any EQSL verification since they are not recognized towards DXCC. Mode or band not important. In advance, many thanks!

[K7PT]

Open the Statistics and Awards portion from the Utilities drop-down. It will open with the Country Status tab open.

Scroll down through the various countries. The ones colored Yellow are ones where you have worked it but not confirmed it on any band or mode. Expanding a country will show the status by band and mode if you have worked it.

[NN7D]

Hi Robert,

If you need a query for export or just to get a QSO list of those contacts who you have not confirmed via card or LotW, try this. Open QSO Archive, create a search with these parameters - QslRcvd != Y and LotwQslRcvd != V (!= means Not Equal)
Then with those parameters set, click on the Search button at top. You can also save that query for later re-use.

Here is a screenshot of the query:

Not_confirmed_Query.jpg (48.99 KiB) Viewed 4167 times

Page 78 of the Log4OM users manual covers queries in more detail.

I hope that answers your question.

Doug - W7DRM

[G4POP]

I'd like to know which countries I've worked, but have not received a verification. I'd like to ignore any EQSL verification since they are not recognized towards DXCC. Mode or band not important. In advance, many thanks!

In QSO Archive search parameters try this

(Band='160m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '160m')) Or (Band='80m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '80m')) Or (Band='40m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '40m')) Or (Band='30m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '30m')) Or (Band='20m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '20m')) Or (Band='17m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '17m')) Or (Band='15m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '15m')) Or (Band='12m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '12m')) Or (Band='10m' And Country Not in (Select Distinct Country From Log Where (LotwQsRcvd = 'V' Or QSLRcvd = 'Y') And Band = '10m'))

Copy and paste as a single line

This selects all QSO's that have not received a QSL card or been verified by LOTW and ignores Eqsl

[NN7D]

Right you are Terry. I failed to read countries in his request...

But the statements should read Select DISTINCT, rather than Select District.

Doug - W7DRM

[G4POP]

Right you are Terry. I failed to read countries in his request...

But the statements should read Select DISTINCT, rather than Select District.

Doug - W7DRM

Bugger! That is what results from rushing and then copy and paste without checking - Spell Wotted Doug now edited

[WA2SQQ]

Thanks so much to all - you guys are great - and so is LOG4OM!