Filtering the Log Page Display

DXKeeper Online Help Contents

The controls in the Filter panel, located at the bottom of the  Main window's Log QSOs tab, allow you to control which QSOs appear in the  Log Page Display; this panel includes a textbox that can be used to specify a callsign, DXCC prefix, date, etc. Many operations -- log reporting, award progress reporting, QSLing and Exporting -- act only upon QSOs appearing in the Log Page Display, so you can use filtering to limit these operations to a specific subset of the QSOs in your log. For example, you could produce a single-band WPX progress report, or export only those QSOs made during last year's ARRL DX contest. Filtering can also be used to quickly see all previous QSOs with a station you're about to work, or all QSOs during a specified day.

At startup, the Log Page Display Filter is cleared, so the Filter panel's caption is Filter: None; thus the Log Page Display contains entries for every QSO in the current log file. If you activate a Log Page Display filter, it will be shown in the Filter panel's caption, e.g. 

• Filter: Call=7O1DX

• Filter: QSL begin between 7/26/2008 00:00 and 7/27/2008 00:00

• Filter: (Mode = 'RTTY') and (Band = '160m') and (QSL_RCVD = 'Y')

The Filter panel displays a textbox and a bank of 9 filter buttons:

Clearing the Log Page Display filter

To clear the Log Page Display filter so that all QSOs are visible , click the Filter panel's X button. Depressing the CTRL key while clicking the Filter panel's X button both clears the Log Page Display filter and sorts the Log Page Display in ascending order of .QSO Begin date-and-time.

Call filter

If you type a callsign into the Filter textbox and click the Filter panel's Call button, the Log Page Display hides entries for any QSOs whose call item does not match the Filter callsign. Similarly, entering a callsign into the Filter textbox and clicking the Filter panel's DXCC button removes entries for any QSOs whose DXCC entity does not match that of the Filter callsign. If the contents of the Filter textbox cannot be mapped to a DXCC Entity, then it is assumed that these contents are DXCC Prefix rather than a callsign, and the Log Page Display is filtered by this DXCC Prefix. For example.

You can use * (asterisk) as a wildcard character in Filter callsigns. For example,

    K6MI*

will match K6MI, K6MIO, and K6MIO/KH6.

When you invoke the Call filter on a callsign that doesn't contain a wildcard character, DXKeeper automatically uses a search expression that will match prepended or appended prefixes or designators. For example

    K6AB

will match K6AB, KH6/K6AB, K6AB/QRP, and KH6/K6AB/P but will not match K6ABC or ZK6AB.

DXCC filter

If you type a callsign or callsign fragment into the Filter textbox and click the Filter panel's DXCC button, DXKeeper will determine the DXCC entity associated with the callsign or callsign fragment, and filter the Log Page Display to show all QSOs with this DXCC entity.

Depressing the CTRL key while clicking the Filter panel's DXCC button displays only QSOs whose DXCC entity prefix matches the DXCC entity prefix specified in the Filter panel textbox

To use the DXCC button to locate QSOs with a deleted DXCC entity, type the deleted entity's DXCC prefix into the Filter textbox preceded by the ~ character. To locate QSOs with Serrana Bank, for example, type ~HK0S into the Filter textbox and click the DXCC button.

Both the Call and DXCC filters select the appropriate DXCC entity in the Progress Grid and provide detailed award status in the Progress Details Grid.

Filtering for Time Intervals

The Date filter limits the Log Page Display to QSOs that began during the interval specified in the Filter panel's textbox. Date-and-time parameters can be specified using any of these formats:

• your locale's standard date or date-and-time formats, as specified in the Windows Control Panel's Regional and Language Options settings

• dd-mmm-yyyy hh:mm:ss

• yyyy-mm-dd hh:mm:ss  

If in the Filter panel's textbox you specify

• a day, e.g. 2008-01-25, then only QSOs that started during that day will be displayed

• a day and time, then the interval depends on the specified hour, minute, and second:

  • 2008-01-25 16:00 - displays only QSOs that began between 16:00 and 17:00 on 2008-01-25

  • 2008-01-25 16:03 - displays only QSOs that began between 16:03 and 16:04 on 2008-01-25

  • 2008-01-25 16:03:15 - displays only QSOs that began  at 16:03:15 on 2008-01-25

Clicking the Filter panel's Since button limits the Log Page Display to QSOs that began any time after the date or date and time specified in the Filter panel's textbox.

Depressing the CTRL key while clicking the Filter panel's Date button updates and then invokes the Advanced Logs Sorts, Filter, and Modifiers window's UTC filter, which allows you to restrict the Log Page Display to those QSOs starting within a range specified in one of two ways: 

• within a specified number of minutes of a specified date-and-time (useful for locating QSOs for which the callsign may have been incorrectly logged), or 

• after one specified date-and-time and before another specified date- and-time; if an after/before range is selected but not before date-and-time is specified when the UTC filter is invoked, the current date-and-time is used for this parameter.  

If the Advanced Logs Sorts, Filter, and Modifiers window's UTC panel specifies a within range, then typing a valid date-and-time in the Filter panel textbox and then clicking the Filter panel's Date button while depressing the CTRL key will set the center of the range to that date-and-time and activate the UTC filter.  If the Advanced Logs Sorts, Filter, and Modifiers window's UTC panel specifies an after/before range, then typing a valid  date-and-time in the Filter panel textbox and then clicking the Filter panel's Date button while depressing the CTRL key will set the beginning of the range to that date-and-time and activate the UTC filter. 

Selection filter

Clicking the Filter panel's Sel button displays all QSOs whose Select items are set to Y.  Every QSO's Select item can be manually set to N or Y, so this provides a means of specifying and selecting an arbitrary group of QSOs. You can also configure DXKeeper to set the Select item of each imported QSO to Y; with this option enabled and the Select items of all logged QSOs were set to N before the import operation, the Sel filter will show only newly-imported QSOs after the import operation completes.

To set the Select item of all QSOs in  the Log Page Display to N, depress the CTRL key while clicking the Sel button. Note that this only affects QSOs in the Log Page Display; to set the Select item of all QSOs in the current log to N, either reset the Log Page Display filter before invoking CTRL-Sel, or click the Set all Select to N button on the Main window's Import QSOs tab.

Logbook of the World (LotW) filter

Clicking the LotW button displays all QSOs whose LotW Sent items are set to U, meaning that their acceptance by LotW has not been verified.

Broke filter

Clicking the Broke button filters the Log Page Display to display only QSOs that

• are missing required information: 

  • Band

  • Begin date/time

  • Callsign

  • Country code

  • DXCC prefix

  • Mode

  • Operator

• have a Begin date/time prior to 1/1/1930

• have an End date/time that occurs before their Begin date/time

• do not contain a valid callsign

• include a Satellite name but do not have Propagation Mode set to SAT

• have an empty myQTH field in a Log for which  multiple QTHs have been defined

If the Subdivisions box is checked on the Config window's Awards tab, the Broke filter also displays QSOs that

• have PrimaryInvalid set to Y, which means that the specified Primary Administrative Subdivision code or abbreviation is not formally defined by the QSO's DXCC entity

• have SecondaryInvalid set to Y, which means that the specified Secondary Administrative Subdivision code or abbreviation is not formally defined by the QSO's DXCC entity and Primary Administrative Subdivision

Advanced filters

DXKeeper's Advanced Logs Sorts, Filter, and Modifiers window, which appears when you click the Adv button located above the Log Page Display on the Main window's Log QSOs tab or when you click the Advanced button at the bottom of the Main window's Check Progress tab, enables you to

• specify a within or after/before date-and-time range, and click the UTC Filter panel's Filter button to display only QSOs that began within that range

• specify one or more bands, and click the Band Filter panel's  Filter button to display only QSOs made on the specified bands

• specify one or more modes and click the Mode Filter panel's  Filter button to display only QSOs made in the specified modes

• specify up to 16 SQL Query Filters in 4 banks of 4, and invoke them as filters

• run a script file containing Filter, Retain Filter, Report, Sort, and Modify commands

Depressing the Ctrl key while clicking the UTC, Band, Mode, or SQL panel's Filter buttons refines the existing Log Page Display filter by applying the new filter to those QSOs visible in the Log Page Display.

Invoking SQL Query Filters from the Filter panel

SQL Query Filters can also be invoked from the Filter panel textbox on the Main window's Log QSOs tab. A bank of SQL Query filters is considered active if at least one caption is specified. Allowing the mouse cursor to hover over an SQL Query filter button for a few seconds will produce a popup window that displays the SQL expression associated with the filter. By clicking the ~ button in the Filter panel textbox, buttons for each filter in the next active bank of SQL Query filters will appear in the Filter panel textbox, each bearing its specified caption. If buttons for the last active bank of SQL Query filter are being displayed in the Filter panel textbox, then clicking the ~ button will display the Call, DXCC, Date, Since, Sel, LotW, and Broke filter buttons.  

An SQL expression typed directly into the Filter panel textbox can be used to filter Log Page Display by striking Ctrl-S.

Running Scripts from the Filter panel

Clicking the ~ button in the Filter panel textbox displays buttons for each filter in the next active bank of SQL Query Filters in the Filter panel textbox and a Script button that when clicked prompts you to specify a script file for execution. If no bank of SQL Query Filters is active, clicking the ~ button will still display the first bank of SQL Query Filters and a Script button.

Keyboard actions and shortcuts in the Filter panel textbox

Filters can also be invoked by striking control keys in the filter textbox.

To facilitate sequential filter operations, striking the Enter key with the cursor in the filter textbox invokes the last filter operation. For example to quickly check for previous QSOs with JY4NE, IK4VYX, and YV1DIG, one would

1. enter JY4NE in the filter textbox

2. click the Call button in the filter panel to see previous QSOs with Ali

3. enter IK4VYX in the filter text box and strike the Enter key to see previous QSOs with Fab

4. enter YV1DIG in the filter text box and strike the Enter key to see previous QSOs with Paul

Double-clicking an item's label in the Capture window will filter the Log Page Display to show all QSOs whose item matches the value in the Capture window.  If the Capture window's IOTA item contains OC-005, for example, double-clicking the IOTA label will filter the Log Page Display to show all QSOs whose IOTA item is OC-005.

Depressing the ALT key while clicking the Log button will reset the Log Page Display filter; if the Sort panel is set to UTC, the most recent QSO will be made current.

DXKeeper's title bar shows the number of QSOs visible in the Log Page Display, taking any specified filtering into account.

QSL and Export operations only apply to QSOs visible in the Log Page Display, thus you can use filtering to choose a specific subset of QSOs to which these activities apply.

Filtering for Previous QSOs

Double-clicking on a callsign in the Call field in the Main window's Log QSOs tab filters the Log Page Display to show previous QSOs with that callsign; if Contest-mode is checked, then only QSOs whose recorded Contest IDs match the current Contest ID setting are shown. Double-clicking on an entry in the Log Page Display filters the Log Page Display to show previous QSO's with that entry's callsign; if Contest-mode is checked, then only QSOs matching the current Contest ID are shown. Double-clicking on an entry in the Log Page Display while depressing the Ctrl key filters the Log Page Display to show show all QSO's with that entry's DXCC entity.