Re: Help with SQL Expression for DXKeeper wanted


Gerhard "Gary" Jaeger, DF2RG
 

Joe, thanks for your help too. This made things even easier for me.
There was a file named "DXKeeper Filters" available back in 2013, which was assembled by K9UW. Is this still being updated or available?
I think there is still a lot to learn with the powerful SQL expressions.

73 de Gary, DF2RG

-----Urspr√ľngliche Nachricht-----
Von: DXLab@groups.io <DXLab@groups.io> Im Auftrag von Joe Subich, W4TV
Gesendet: Montag, 5. April 2021 00:21
An: DXLab@groups.io
Betreff: Re: [DXLab] Help with SQL Expression for DXKeeper wanted


> Mode like 'FT[48]' and QSL_Sent <> 'Y'

If you are looking for QSOs in 2020, try the following:

QSO_Begin >= #2020-01-01 and QSO_Begin < #2021-01-01# and
Mode like 'FT[48]' and QSL_Sent <> 'Y'

73,

... Joe, W4TV


On 2021-04-04 4:31 PM, Gerhard "Gary" Jaeger, DF2RG wrote:
Iain, thanks very much. I will give it a try tomorrow, when I am at the shack computer again.

73 de Gary, DF2RG

-----Urspr√ľngliche Nachricht-----
Von: DXLab@groups.io <DXLab@groups.io> Im Auftrag von iain macdonnell - N6ML
Gesendet: Sonntag, 4. April 2021 21:55
An: DXLab@groups.io
Betreff: Re: [DXLab] Help with SQL Expression for DXKeeper wanted

On Sun, Apr 4, 2021 at 12:37 PM Gerhard "Gary" Jaeger, DF2RG <gary@df2rg.de> wrote:
At the beginning of every year or so, I print out all the cards for contacts, which have not been printed out so far.

I want to print out all the cards for FT4/FT8, which have not been sent out from the previous year. I hope that you get my point.
Perhaps:

Mode like 'FT[48]' and QSL_Sent <> 'Y'

73,

~iain / N6ML

Join DXLab@groups.io to automatically receive all group messages.