This problem I have is a bit hard to explain, but the thing is I write most of my qsl cards by hand and use CQRLOG as logfile, and to keep my administration about who I sent a card to already.
I want to send everyone a card if I did not send a card for that band-mode before. That's why I would like to see all the qso's from the callsign that does not have a card sent status.
To help me with this I created this qso query, and that does what I want:
WHERE callsign IN (SELECT callsign FROM view_cqrlog_main_by_qsodate WHERE ((qsl_s = '') or (qsl_s is null))) ORDER BY callsign
The thing is now, in order to be able to work with this data it would be nice to have this as a filter in CQRLOG so I can mark qsl sent and things like that. This is not possible with the sql console.
Any solution here?