¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io
  1. DXLab
  2. Topics

SQL filter for specific spotters?

 

Hi,

I want to fine tune a query so it will only include spots from my own skimmer (fed to RBN).? It sort of works. When a spot spotted by me comes in, it shows up in the grid, but then quickly disappears. I believe this is because it has been re-spotted by someone else.

Is there any setting or trick I could use to make this work?? Basically I would like to filter out all my spots that are needed for better visibility and also audio announcements.

Thanks and 73
Andy
KU7T
 

On Thu, Mar 3, 2016 at 10:48 AM, ku7t@... [dxlab]
<dxlab@...> wrote:

I want to fine tune a query so it will only include spots from my own skimmer (fed to RBN). It sort of works. When a spot spotted by me comes in, it shows up in the grid, but then quickly disappears. I believe this is because it has been re-spotted by someone else.

Is there any setting or trick I could use to make this work? Basically I would like to filter out all my spots that are needed for better visibility and also audio announcements.
Try:

Cumulative like '*de KU7T *'

(assuming that's the 'Source' of your skimmer spots - don't include
the '-#' suffix, since SpotCollector appears to chop that off before
adding to 'Cumulative')

73,

~iain / N6ML
 

¿ªÔÆÌåÓý

Works great. Even the audio announcements work correctly (announcing only when spot comes in from me for the first time and not on consecutive spots from others).

?

Thanks and 73

Andy

KU7T

?

From: dxlab@... [mailto:dxlab@...]
Sent: Thursday, March 3, 2016 11:36 AM
To: dxlab <dxlab@...>
Subject: Re: [dxlab] SQL filter for specific spotters?

?

?

On Thu, Mar 3, 2016 at 10:48 AM, ku7t@... [dxlab]
<dxlab@...> wrote:
>
> I want to fine tune a query so it will only include spots from my own skimmer (fed to RBN). It sort of works. When a spot spotted by me comes in, it shows up in the grid, but then quickly disappears. I believe this is because it has been re-spotted by someone else.
>
> Is there any setting or trick I could use to make this work? Basically I would like to filter out all my spots that are needed for better visibility and also audio announcements.

Try:

Cumulative like '*de KU7T *'

(assuming that's the 'Source' of your skimmer spots - don't include
the '-#' suffix, since SpotCollector appears to chop that off before
adding to 'Cumulative')

73,

~iain / N6ML

1 - 3 of 3