Re: SQL filter help


Jamie WW3S
 

thanks Dave.....

any chance of a future enhancement to the operator ID field.....13 characters is too small for some multi op operations.

------ Original Message ------
From: "Dave AA6YQ" <@AA6YQ>
To: DXLab@groups.io
Sent: 9/19/2020 8:15:10 PM
Subject: Re: [DXLab] SQL filter help

+ AA6YQ comments below

Need help filtering by contest ID and year, like CQWW cw in 2015, I thought I had it, but must have a bracket in the wrong place....

+ Try this:

(CONTEST_ID = 'CQWW') and (YEAR(QSO_BEGIN)=2015)

+ If your CQWW contest QSOs specify something other than CQWW in their CONTEST_ID items (like CQ-WW-CW), adjust the above expression
accordingly.

73,

Dave, AA6YQ





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