Create Filter Question

3 posts / 0 new
Last post
DK5TX
DK5TX's picture
Create Filter Question

Hi all,

perhaps someone can point me in the right direction:

I want to search for all QSO in the QSO List, where the field "Award" is not empty. Because there are no specific fields for e.g. GMA or FloraFauna Awards, I simply put the reference (in this field, when making a contact. Now I want to export all those QSO with an entry in the "Award" field it for further evaluation, but I don't find a way to do so. Any ideas?

73
Ulf DK5TX

oh1kh
Create Filter Question

Hi Ulf!

I have used same field for FF, but also for other special purposes. With latest version (only compiled from source) there is also possibility to use Ctrl+V to paste information part from DXCluster spot line to any of NewQSO columns.
It is very handy in cases when makin qso with spoted callsign. (lot less typing)

I think you have now situation that you have not always entered XXFF-1234 type information. Maybe just the number part?
If you have used XXFF you can simply search Award column as FF (include). Then you should get all FF qsos.

But if you need all qsos that have anything, but empty, in Award column then you should use SQL console.

With Cqrlog SQL console ( NewQSO/Window/QSO list/Filter/SQL console ) :
Write to upper part:

select * from cqrlog_main where award <>""

press run icon (green triangle) at top left corner to get results to lower part.

You can use two inverted commas ' or two inverted double commas " in line.

--
Saku
OH1KH

DK5TX
DK5TX's picture
Create Filter Question

Hello Saku,

tnx for the suggestions. I'll try the SQL console and will add the specific kind of reference to the award field in future, so I can simply search for "GMA" or "FF". I didn't do that in the past (only the reference code), because I was not thinking of ever exporting those QSO.

73
Ulf DK5TX