Re: SQL filters


Stephen Rabinowitz
 

My heartfelt thanks to both Iain and to you, Dave.  WA2DFP Steve

 

From: dxlab@... [mailto:dxlab@...] On Behalf Of Dave AA6YQ
Sent: Sunday, October 27, 2013 12:17 PM
To: dxlab@...
Subject: RE: [dxlab] SQL filters

 

 

>>>AA6YQ comments below

 

From: dxlab@... [mailto:dxlab@...] On Behalf Of Stephen Rabinowitz
Sent: Sunday, October 27, 2013 8:04 AM
To: dxlab@...
Subject: Re: [dxlab] SQL filters

 

Thank you, Iain, that worked perfectly.  My SQL filter is now:

 

((BAND='20M') OR (BAND='15M') OR (BAND='10M')) AND (MODE='SSB') AND ((EQSL='Y') OR (LOTW='Y')) AND ((ORIGIN='NA-M') OR(ORIGIN='NA-E')) AND (NEEDED='D') AND (CountryProgress<>'F') AND (LastTime > DateAdd("n",-60,Now()))()))

 

>>>If you enable Realtime Award Tracking for IOTA, Marathon, VUCC, WAS, WAZ, or WPX, you should replace

 

(NEEDED='D')

 

With

 

(NEEDED like '*D*')

 

 

>>>If you update your log to reflect the granting of DXCC credits, you should replace

 

(CountryProgress<>'F')

 

with

 

((CountryProgress<>'F') and (CountryProgress<>'V'))

 

        73,

 

               Dave, AA6YQ

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