SQL filters
|
Stephen Rabinowitz
Dave – how do I add the criterion ‘age less than 20 minutes’ to an SQL filter?
WA2DFP Steve
|
|
|
|
On Fri, Oct 25, 2013 at 10:37 AM, Stephen Rabinowitz
<srabin@...> wrote: LastTime > DateAdd("n",<UTCOFFSET>-20,Now()) 73, ~iain / N6ML
|
|
|
|
Stephen Rabinowitz
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",<UTCOFFSET>-60,Now()))()))
and is giving me exactly what I seek. Thanks again, Steve WA2DFP
From: iain macdonnell - N6ML <ar@...>
On Fri, Oct 25, 2013 at 10:37 AM, Stephen Rabinowitz
<srabin@...> wrote: > > > Dave – how do I add the criterion ‘age less than 20 minutes’ to an SQL > filter? LastTime > DateAdd("n",-20,Now()) 73, ~iain / N6ML ------------------------------------ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/dxlab/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/dxlab/join (Yahoo! ID required) <*> To change settings via email: dxlab-digest@... dxlab-fullfeatured@... <*> To unsubscribe from this group, send an email to: dxlab-unsubscribe@... <*> Your use of Yahoo! Groups is subject to: http://info.yahoo.com/legal/us/yahoo/utos/terms/
|
|
|
|
Dave AA6YQ
>>>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
|
|
|
|
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
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
|
|
|