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.
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
|
||
|
|