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. 

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

Button Function
X
  • clears the Log Page Display filter

  • CTRL-X clears the Log Page Display filter and sets the Sort panel to UTC

Call
  • filters the Log Page Display by the callsign specified in the textbox; if the textbox is empty, filters the Log Page Display by the currently-selected QSO's callsign
DXCC
  • filters the Log Page Display by the DXCC entity specified in the textbox; if the textbox is empty, filters the Log Page Display by the current-selected QSO's DXCC entity
Date
  • filters the Log Page Display to show only QSOs that started on the Date specified in the textbox

  • CTRL-Date updates and invokes the Advanced Sorts, Filters, and Modifiers window's UTC filter

Since
  • filters the Log Page Display to show only QSOs that started on or after the Date and time specified in the textbox, or optionally QSOs that started on or after the date and time that the Since filter was last invoked
Sel
  • filters the Log Page Display to show only QSOs whose Select items are set to Y
LotW
  • filters the Log Page Display to show only QSOs uploaded by not yet accepted by LotW

  • CTRL-LotW filters the Log Page Display to show all QSOs not confirmed via LotW with stations that have subsequently uploaded to LotW and sets the Select item in each such QSO to Y (if the LotW database is present in DXView's Databases folder or in DXKeeper's Databases folder). QSOs with stations whose LotW Sent items are set to X will not have their Select items set to Y.

Broke
  • filters the Log Page Display to show only QSOs that are missing critical information or contain invalid information
~
  • displays the next active bank of 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.

Filter textbox contents Clicking the Filter panel's DXCC button filters for all QSOs with
3B8IK Mauritius Island (DXCC = 3B8)
UN1DX Kazakhstan (DXCC = UN)
UL1DX Uzbekistan (DXCC = UJ)
Y German Democratic Republic (DXCC = Y)


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:

If in the Filter panel's textbox you specify

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 Since button limits the Log Page Display to QSOs that  began any time after the date and time at which the Since filter was last invoked.

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: 

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.

Depressing the CTRL key while clicking the LotW button filters the Log Page Display to show all QSOs not confirmed via LotW with stations that have subsequently uploaded to LotW and sets the Select item in each such QSO to Y (if the LotW database is present in DXView's Databases folder or in DXKeeper's Databases folder). QSOs with stations whose LotW Sent items are set to X will not have their Select items set to Y.


Broke filter

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

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

QTH filter

You can filter the Log Page Display to show only QSOs made from the currently-selected QTH.

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

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.

To save all 16 SQL Query Filters to a text file, click the Save button; to restore all SQL Query Filters from a text file, click the Restore button. These functions can be used as a backup mechanism before making significant changes to an SQL expression, or to maintain multiple sets of SQL filters optimized for different operating conditions.

 

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.  

If the Display panels in two columns option is enabled,  the Call, DXCC, Date, Since, Sel, LotW, and Broke filter buttons will always be visible. Clicking the ~ button will toggle between displaying eight filter buttons for SQL Query Filter banks 1 and 2, and eight filter buttons for SQL Query Filter banks 3 and 4.

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.

If the Display panels in two columns option is enabled, the Script button will aways be visible.

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. If Display previous comments on Lookup is checked, these operations will display a scrollable window containing comments extracted from previous QSOs with the same base callsign, each preceded by the QSO's start time and terminated by the QSO's callsign.