Re: Filtering SC for special callsigns by mode

iain macdonnell - N6ML

On Fri, Apr 23, 2021 at 11:16 AM Dave AA6YQ <aa6yq@...> wrote:
I have been using the “Identifying Special Callsigns” feature ( of SpotCollector with good success, but I wonder if there is some beneficial additional functionality available that I am missing.

I would like SC to display the callsigns of CWops members that I have yet to work on a given band, but only for the CW mode, in pursuit of CWops awards, along with any spots relevant to my DXCC or Challenge objectives without regard to band or mode.

Using the CWops roster as the Leaderboard special callsign list, I can display spots for all CWops members on unworked bands along with spots needed for DXCC or Challenge objectives, but the spot database display shows this for all modes and not just CW.  So, in the case of CWops members, I end up seeing many spots for modes that are not of interest.

If I invoke the Mode filter and set it for CW, then SC displays only the needed entries for CW, which works fine for the CWops awards, but I will miss other desirable entries such as an ATNO on FT8.

The ideal solution would be to allow me to further filter the Leaderboard spot displays by mode so that it contributes only the CWops counters that I need to the display, in conjunction with the display of other spots I need for DXCC and Challenge goals regardless of mode.

Is there a way to do this in the existing program?

+ Yes. Assuming that the tag you've specified for CWops members in the "Special Callsign List" is


+ use this SQL expression

<NEEDFILTER> or ((TAGS like '*<cwops>*') and (MODE='CW'))

That doesn't solve the problem, which was to show only CWOps members *on CW, who have not been worked before on CW* (but also show other stations who are Needed on other modes).

I can't think of any way to do it with SpotCollector's current capabilities....


    ~iain / N6ML


Join to automatically receive all group messages.