Request for help: SQL Expression to find K1FOC 2021 QSO's in W1EBM log


Gary Smetana
 

Hi Dave & the Group,


Need some help.  Think my SQL's not quite right.

 

Here’s the steps I did :

  

#1)  Created (in ADV window, in Filter #1 at bottom:  an  SQL User-Defined Sort as:  

  

 (STATION_CALLSIGN='K1FOC')   AND  (QSO_ Begin >#2021-01-01 00:00#)



#2)  In TQSL, I confirmed  I had added "Home  Station (K1FOC)” as an  

       Added Location.

  

#3) In Main Window, clicked on QSL;   then clicked  “QSL Config.” 

  

#4) In the new window,  selected  the LoTW  tab.    In the TQSL area @  

      bottom, I changed the "Station Location”  to "Home Station (K1FOC)”    

      and changed the "Station Call Sign" to K1FOC. 

  

#5) Clicked on "Filter"


#6) Get Error Message:  "Invalid Filter Expression"


Got a bad character or a missing character...?


73,

Gary W1EBM


 


 



John Etling
 

CHECK -- "Home  Station (K1FOC)”

 

You have 2 spaces between Home and Station.

 

Just a quick look see… that caught my attention.

 

 

73 de K3JAE

JOHN A. ETLING

 

Email: k3jae@...

Benton County, TN ARES EC

AF MARS: AFA4WO

 

 

 

 

From: DXLab@groups.io <DXLab@groups.io> On Behalf Of Gary Smetana
Sent: Friday, January 21, 2022 11:37 AM
To: DXLab <dxlab@groups.io>
Subject: [DXLab] Request for help: SQL Expression to find K1FOC 2021 QSO's in W1EBM log

 

Hi Dave & the Group,



Need some help.  Think my SQL's not quite right.

 

Here’s the steps I did :

  

#1)  Created (in ADV window, in Filter #1 at bottom:  an  SQL User-Defined Sort as:  

  

 (STATION_CALLSIGN='K1FOC')   AND  (QSO_ Begin >#2021-01-01 00:00#)





#2)  In TQSL, I confirmed  I had added "Home  Station (K1FOC)” as an  

       Added Location.

  

#3) In Main Window, clicked on QSL;   then clicked  “QSL Config.” 

  

#4) In the new window,  selected  the LoTW  tab.    In the TQSL area @  

      bottom, I changed the "Station Location”  to "Home Station (K1FOC)”    

      and changed the "Station Call Sign" to K1FOC. 

  

#5) Clicked on "Filter"



#6) Get Error Message:  "Invalid Filter Expression"



Got a bad character or a missing character...?



73,

Gary W1EBM

 

 

 

 

 


Dave AA6YQ
 

+ AA6YQ comments below

(STATION_CALLSIGN='K1FOC') AND (QSO_ Begin >#2021-01-01 00:00#)

+ Remove the space between the _ and the word Begin



#2) In TQSL, I confirmed I had added "Home Station (K1FOC)" as an

Added Location.

+ This has nothing to do with filtering the Log Page Display.


#4) In the new window, selected the LoTW tab. In the TQSL area @

bottom, I changed the "Station Location" to "Home Station (K1FOC)"

and changed the "Station Call Sign" to K1FOC.

+ This has nothing to do with filtering the Log Page Display.

73,

Dave, AA6YQ