#228816

开云体育

It appears that I have worked a few DX stations in CW that I don’t have confirmed or verified.? I am attempting to write a SQL expression that searches for mode of CW and NOT a US QSO and it the QSO was between ?January 1, 2015 and January 1, 2025 (and that part works it is that last part of the expression that I can’t get right).? Anway, this is what I have so far:

?

(mode='CW') AND (DXCCPrefix <> 'K') AND ?((QSO_Begin > #01-01-2015 00:00#) AND (QSO_End < #01-01-2025 00:00#)) AND ((APP_DXKeeper_LotW_QSL_RCVD<>'V') OR (QSL_Rcvd <> 'V'))

?

I don’t get any errors.? I want it to now list only DX stations that have not been verified. ?I realized that is “confirmation” but the ‘V’ appears in the LoTWR or QSLR columns.? Which explains why I have that part at the end. ?I looked at the Help (Log Items) at file:///C:/Ham%20Programs/DXLab/DXKeeper/Help/Items.htm and it shows an item App_DXKeeper_QSL_Verified but I couldn’t figure out what to do with it since it appears one of its values is ‘V’, but when I tried it as a SQL expression I got an error.? What am I missing?

?

73, Bob KB4CL

#228819

1) Your dates are incorrectly formatted ... should be YYYY-MM-DD
2) I'm not sure <> works for not equal ...

Try the following:

(mode='CW') AND (NOT DXCCPrefix = 'K') AND
(QSO_Begin BETWEEN #2015-01-01# and #2024-12-31#) AND
((NOT APP_DXKEEPER_LOTW_QSL_RCVD = 'V') OR (NOT QSL_RCVD = 'V'))

73,

   ... Joe, W4TV

Show quoted text

On 2025-04-20 1:32 PM, Bob Main via groups.io wrote:
It appears that I have worked a few DX stations in CW that I don't have
confirmed or verified.  I am attempting to write a SQL expression that
searches for mode of CW and NOT a US QSO and it the QSO was between  January
1, 2015 and January 1, 2025 (and that part works it is that last part of the
expression that I can't get right).  Anway, this is what I have so far:
(mode='CW') AND (DXCCPrefix <> 'K') AND  ((QSO_Begin > #01-01-2015 00:00#)
AND (QSO_End < #01-01-2025 00:00#)) AND ((APP_DXKeeper_LotW_QSL_RCVD<>'V')
OR (QSL_Rcvd <> 'V'))
I don't get any errors.  I want it to now list only DX stations that have
not been verified.  I realized that is "confirmation" but the 'V' appears in
the LoTWR or QSLR columns.  Which explains why I have that part at the end.
I looked at the Help (Log Items) at
file:///C:/Ham%20Programs/DXLab/DXKeeper/Help/Items.htm and it shows an item
App_DXKeeper_QSL_Verified but I couldn't figure out what to do with it since
it appears one of its values is 'V', but when I tried it as a SQL expression
I got an error.  What am I missing?
73, Bob KB4CL

#228820

Thanks Joe.  I set my dates as MM-DD-YYYY way back in 2007 and have always had it that way.  It was an optional way to do the dates then and that is what I was used to.  I don't know why that is not an option now, I just looked, but it was the way it was set up when I first started using it and those years.  Also, the <> does work as NOT EQUAL.  The first part of my expression work perfectly it was the last part that didn't work.

73, Bob KB4CL

Show quoted text

-----Original Message-----
From: [email protected] <[email protected]> On Behalf Of Joe Subich, W4TV
Sent: Sunday, April 20, 2025 2:08 PM
To: [email protected]
Subject: Re: [DXLab] SQL Filter

1) Your dates are incorrectly formatted ... should be YYYY-MM-DD
2) I'm not sure <> works for not equal ...

Try the following:

(mode='CW') AND (NOT DXCCPrefix = 'K') AND (QSO_Begin BETWEEN #2015-01-01# and #2024-12-31#) AND ((NOT APP_DXKEEPER_LOTW_QSL_RCVD = 'V') OR (NOT QSL_RCVD = 'V'))

73,

    ... Joe, W4TV

On 2025-04-20 1:32 PM, Bob Main via groups.io wrote:
It appears that I have worked a few DX stations in CW that I don't 
have confirmed or verified.  I am attempting to write a SQL expression 
that searches for mode of CW and NOT a US QSO and it the QSO was 
between  January 1, 2015 and January 1, 2025 (and that part works it 
is that last part of the expression that I can't get right).  Anway, this is what I have so far:

(mode='CW') AND (DXCCPrefix <> 'K') AND  ((QSO_Begin > #01-01-2015 
00:00#) AND (QSO_End < #01-01-2025 00:00#)) AND 
((APP_DXKeeper_LotW_QSL_RCVD<>'V')
OR (QSL_Rcvd <> 'V'))

I don't get any errors.  I want it to now list only DX stations that 
have not been verified.  I realized that is "confirmation" but the 'V' 
appears in the LoTWR or QSLR columns.  Which explains why I have that part at the end.
I looked at the Help (Log Items) at
file:///C:/Ham%20Programs/DXLab/DXKeeper/Help/Items.htm and it shows 
an item App_DXKeeper_QSL_Verified but I couldn't figure out what to do 
with it since it appears one of its values is 'V', but when I tried it 
as a SQL expression I got an error.  What am I missing?

73, Bob KB4CL