How to Filter and Search QSOs in Ham Radio Deluxe Logbook

Sometimes the operator will want to search for something in the log.

The "Filter" was created to enable the operator to search the log for something of specific interest.

Graphical user interface, application

Description automatically generated


Menus after clicking Filter button

The Callsign filter limits results to QSOs that match the characters you enter in the box.  For example, if you enter T3 all QSOs that start with T3 will show, and the more text further limits results.

The Date filter limits results based on the sub-filter you choose such as Today, Yesterday, Since, or other choice.  The date entered in the box sets one limit (floor if you choose Since, or ceiling if you choose Before.

The three Field filters allow further limits on results illustrated by the examples below.

The Reset button erases the filters you entered so you can start over, do another search, or exit the filter mode.

Apply returns the QSO display to all records.

Filter to a single call sign

Click on Callsign checkbox and enter desired callsign, then click Apply button.

Graphical user interface, application

Description automatically generated

Any QSOs with the entered callsign should show in the QSO area.  If none show, check your call sign and other filters since filters to the right can limit your results, such as only QSOs since a given date.

Reset to full dataset for another search unless your next search should use the filtered set.

Filter for missing (null) data

Some QSOs lack data in the normal exchange that some hams would like populated.  To search for (and possibly edit) QSOs that lack United States state, follow the steps below.  Similar approaches work for other data elements.

Graphical user interface, application

Description automatically generated

Click the leftmost Field checkbox (means you want to define that filter), select Country from the lookup list, change Match to Equals, and enter United States.  Substitute the name of another country if you need a similar search for Japan, Indonesia, etc.  Note we used country because the US contains several DX entities that would yield only partial results.

Click the second Field check box (leave the logical operator as And which forces both filters to be true for returned values).  Select Equals in the Match box and leave Value empty since that is the condition we seek.  Click the Apply button to see the query results.

If you want to find US counties that are not yet defined, replace State with County and click the Apply button as shown below.

Graphical user interface, application

Description automatically generated

Filter for zero numerical values

To find CQ Zone or ITU Zone values missing from QSOs, do the following:

Click the Reset and Apply buttons if you want to start with all records.

Check the first Field box, select CQ zone (or ITU zone), set match to =, and enter 0 (zero).  Click Apply to run the query.  

Graphical user interface, application

Description automatically generated

If you want to limit QSOs to only Japan, for example, click the second Filter box and select Country from the drop-down menu, set Match to Equals, and enter Japan in the Value box.   Click Apply to see the results.

Graphical user interface, application

Description automatically generated

Important note: Searching by words in the Country field can often miss QSOs, depending on how things are spelled. For that reason, it is advised to search by the DXCC numeric value for the country you're searching instead. You can find the DXCC numeric value for a given country by putting a callsign in the Callsign Lookup pane in Logbook.

General advice

When your result set is much larger than expected or desired (such as when you want to repair a few problems but not all at once), you generally need to add filters to reduce the dataset.  For example, if you want to add ARRL section to QSOs that should have the section but are null a query just on ARRL section will return records from DX entities outside the US and Canada.  Solution: Add a country filter or a state filter to reduce the number you see.  You can then edit those records you choose, change the geographic filter for the next desired subset, and continue the process until you decide to quit (and maybe make more QSOs).

For Yes and No fields use Y or N in the value box for your filter.

Continue to next section