RE: Data export
An SQL example that results in OR (in other words paper QSL or LoTW) is (((QSO.L_QSL_RECEIVED = 1 OR QSL.L_LOTW_RECEIVED = 1 = -1))) AND (YEAR = 2017) AND (Band = 80m) AND (MODE = FT8)
Substitute year, band , mode as you need.
Jordi has already done this for you (he's a good guy) and you only need to open a logbook view and change the Query to
Swisslog/Queries/Examples/Confirmed QSO by QSL or LOTW.spq
To get separate totals for paper QSL and LoTW, open a Logbook view with QSL Rec and LOTW_RECEIVED fields. Select your year, band , mode as I described in my first email and then, using the drop down column headers for QSL Rec and afterwards LOTW_RECEIVED, pick '1' from the list (you will see ALL, CUSTOM, 0, 1 as the options). The QSO count for these criterion will show on the right hand side of the bottom bar in Swisslog.
Erik.
|