AA6YQ comments below
-----Original Message-----
From: dxlab@... [mailto:dxlab@...]
Sent: Sunday, February 21, 2016 10:12 PM
To: DXLAB DXLAB
Subject: [dxlab] QSOs for unverified countries
I think this has been discussed before but some time ago.
Yes, several times.
Is there some combination of filters and reports that will list QSO's with countries for which one has no QSL (card or LOTW)? The
report from real-time progress will list the countries, but not the QSOs with those countries.
Yes. Iain N6ML was the first to post this SQL expression, which queries your log's DXCC progress table:
EXISTS (SELECT Progress.CountryStatus FROM Progress WHERE (Progress.CountryCode = DXCCID and (Progress.CountryStatus not in
('F','V'))))
In Progress table notation, 'F' means "Fulfilled" (a synonym for "Confirmed"), and 'V' means "Verified" (DXCC award credit
granted).
My particular problem is that I have about 120 countries worked on 12M but only ~75 confirmed. I need to filter just those QSO's
which will advance the objective of reaching 100 confirmed, giving me 8-band DXCC.
To filter the Log Page Display to show all 12m QSOs with DXCC entities not confirmed on 12m, use
(band='12m') and EXISTS (SELECT Progress.CountryStatus FROM Progress WHERE (Progress.CountryCode = DXCCID and (Progress.M12 not in
('F','V'))))
Progress.M12 references the DXCC progress table's 12m award status.
If your purpose is to populate the QSL Queue with the QSOs you need confirmed on 12m, the "Add Needed" function will do that
without your having to do any manual filtering -- assuming your DXCC objectives are configured to include 12m.
73,
Dave, AA6YQ
