I wanted to report back regarding my reconciling my 6M DXCC totals, which I have done with you and Joe's help.

However the SQL filter you sent me didn't work as expected as it returned QSOs from all bands including 6M. (see below)

(Band = '6m') and (DXCCPrefix <> 'K') and (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V'))

The SQL filter Joe sent me worked as expected and I was able to reconcile my 6M totals.  (see below)

DXCCID <> "291" and Band='6M' and (QSL_RCVD = 'V' or APP_DXKeeper_LotW_QSL_RCVD = 'V')

I don't know if it's worth your time to try to figure out why your SQL filter doesn't work as expected since my issue has been resolved but I wanted to let you know what happened when I ran it.

I again want to thank you and Joe for your help.

Julio, W4HY

-----Original Message-----
From: DXLab@groups.io [mailto:DXLab@groups.io] On Behalf Of Dave AA6YQ
Sent: Monday, June 21, 2021 4:04 PM
To: DXLab@groups.io
Subject: Re: [DXLab] Report

I've been trying to write the needed SQL filter today but I haven't had much luck. Could someone lend a hand.

I need an SQL filter to produce a log with 6M QSOs that are not from the US, in other words DX only, and if possible if they are confirmed via card or LOTW or both.

+ "6m QSOs" => (Band = '6m')

+ "not from the US" => (DXCCPrefix <> 'K')

+ "confirmed via card or LOTW or both" => (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V'))

+ The use of

QSL_RCVD in ('Y','V'))

+ is shorthand for

(QSL_RCVD = 'Y') or (QSL_RCVD='V')

+ This is necessary for both QSL_RCVD  and APP_DXKEEPER_LOTW_QSL_RCVD because a QSO can be "confirmed" ('Y') or "confirmed with DXCC award credit granted" ('V').

+ You can test each of the above fragments individually. Then put them all together:

(Band = '6m') and (DXCCPrefix <> 'K') and (QSL_RCVD in ('Y','V')) or (APP_DXKEEPER_LOTW_QSL_RCVD in ('Y','V'))

+ If you provide columns in the Log Page Display for QSL_RCVD and APP_DXKEEPER_LOTW_QSL_RCVD, you'll be able to see exactly how each QSO is confirmed.

       73,

                    Dave, AA6YQ