Hi Will!

I wrote a long message for you, but seems that I only Previewed it and not saved as it does not show up forum list.
That happens sometimes when writing is interrupted by other tasks.

If you have "save log data to local machine" checked in Database connection then you can connect mysql from command console as
mysql -S ~/.config/cqrlog/database/sock
But only when Cqrlog is running.

From mysql console you can do what ever you want to seek from log database. Consult local Elmer if you need support for SQL command language.
It is good to know that logs are saved in databases named as "cqrlog001" (for log 1)... and so on. The log number has always 3 digits.

Database has table called "cqrlog_main" that holds qsos.
Most of that table column names are clear, but DXCC country for qso is found from column named "adif" as number.

There is another database "cqrlog_common" that is common for all logs.
There is table "dxcc_ref" that holds DXCC info and from there you find "adif" number corresponding country information.

Keeping these in mind you can create queries to fill your needs.

-----------

For Qsos worked but not confirmed you can create filter "Qso_List/Filter/Create"

Top right select date from--to if you need to specify time. Otherwise default (empty) is ok.

In middle of window select QSL/R,( eQSL/R and LoTW/R if you use them). Values for those three are "Empty, N, N" in same order.
It requires that you have set manually "QSO_list/EditQSO->NewQSO/QSL_R" or "QSO_list/select QSO/Ctrl+R" when you have received paper card for qso.
eQSL and LoTW received will be set automated when downloading qsos from them.

At bottom check "Remember filter" if you need to come back to fix filter you will see your previous values instead of clean start.
You can do clean with button "Clear" when needed.

Then press "OK". Compare "QSO_List/QSO in log:" value to value before filter and you see what your filter affected.

Then you say you need list.
Closest outputs in list text format are "QSO_list/File/Export/Csv for SOTA website".
There is nothing much to set but filename for export in this case.
Then button "Export" for exporting.

Another text list format can be found from "QSO_list/QSL/Export for label printing".
At the top left check "Export all QSOs". (it will export all qsos in filter)
Then set 1 to "Print 1 QSOs on one label"
Press button "Choose fields for export" and select what fields from qso you need for your list.
When that is set check filename for export in "Export to" and press button "Export"

Both these can do a TEXT output from your filtered qsos that appears in CSV format (comma separated values).
You can open the export with OpenOffice Calc (or Windows Exel) if you need to manipulate it more, or else with plain text editor.

When you have done you can release your filter with Shift+F12 to see your whole log again in QSO_List.

(Now I try to remember to save this message....hi)