开云体育

Dave, et al.,
I think this has been discussed before but some time ago.

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. I can do (and have done) this in ACCESS, but it is a bit of
a pain. If the confirmed flag in the country database file were
available (on a read-only basis, of course) it would be easy.

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.

Thanks for any help.

Pete K5GM
Pete Jordahl, K5GM
k5gm@...

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

Thanks, Dave, for the prompt (as usual) reply. It worked; now to add an
"order by" clause and hope I don't exceed the available length in the
ADV Filter line!

73
Pete

On Sun, Feb 21, 2016, at 10:22 PM, ' Dave AA6YQ' aa6yq@...
[dxlab] wrote:

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



------------------------------------
Posted by: " Dave AA6YQ" <aa6yq@...>
------------------------------------


------------------------------------

Yahoo Groups Links

--
Pete Jordahl, K5GM
k5gm@...