I have been using the “Identifying Special Callsigns” feature (http://dxlabsuite.com/spotcollector/Help/ConfigurationSpecialCallsigns.htm) 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

cwops

+ use this SQL expression

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