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:
SELECT *
FROM view_cqrlog_main_by_qsodate
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?
Instead of using the consol just go to filter in qso list, check boxes that you want to filter, when the qso's come up that you are looking for go to "file" then "group edit", change what you want and that is it. HTH
Tom K8WDX
The problem is that what I want to do is not available as filter, I only can make it using the sql menu.
This IS possible to do using filter. In QSL Send drop down box, choose "Empty" and you can also use group by function to get only one QSO from callsign you haven't sent QSL.
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Any possibility to do this per band mode?
Yes, you can specify also band and mode in the filter window. QSO can be sorted by mode or band.
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com