Re: Report
|
Julio Peralta
I wanted to report back regarding my reconciling my 6M DXCC totals, which I have done with you and Joe's help.
toggle quoted messageShow quoted text
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
|
|
|