SQL filters


Stephen Rabinowitz
 

Dave – how do I add the criterion ‘age less than 20 minutes’ to an SQL filter?

 

WA2DFP

Steve


iain macdonnell - N6ML
 

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",<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@...>
Date: 10/25/2013 1:55 PM (GMT-05:00)
To: dxlab <dxlab@...>
Subject: Re: [dxlab] SQL filters


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