all qso's from callsigns where one contact does not have a qsl card sent

6 posts / 0 new
Last post
on8wr
all qso's from callsigns where one contact does not have a qsl card sent

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?

k8wdx
k8wdx's picture
Filter

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

on8wr
re:

The problem is that what I want to do is not available as filter, I only can make it using the sql menu.

ok2cqr
ok2cqr's picture
re:

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.

on8wr
Any possibility to do this

Any possibility to do this per band mode?

ok2cqr
ok2cqr's picture
Re: Any possibility to do this

Yes, you can specify also band and mode in the filter window. QSO can be sorted by mode or band.