Re: 13Colonies how to make SQL Spot Collector filter


Jon KM8V
 

In the for what it's worth category, here is the SpotCollector filter I use, without using Special Callsigns or Tags. I'm trying to "triple-play" it, so work each one on digital, phone and CW. I remove the callsign from the appropriate line after I've worked it.

(CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'CW' and <AGEFILTER> and SpotCount > 1) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE = 'SSB' and <AGEFILTER>) or (CALLSIGN IN('K2A','K2B','K2C','K2D','K2E','K2F','K2G','K2H','K2I','K2J','K2K','K2L','K2M','WM3PEN','GB13COL','TM13COL') and <ORIGINFILTER> and MODE LIKE 'FT*' and <AGEFILTER> and SpotCount > 1)

And to keep track of it, I built a Google Sheet a few years back, which is available for others to use if you like:

https://km8v.com/u/13colsblank

Here's mine so far this year: https://km8v.com/u/13cols2022

I'll also mention my annual request for SpotCollector leaderboard functionality with an "ignore before date" capability :)

73 de KM8V Jon

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