Custom search

[k4jh]

How does "custom search" work? I looked in the fine manual, but did not see this explained, did I miss it?

For example, I would like to find all QSOs I had with stations in Nebraska. I click on "custom search" and the on "state" on the Select Field drop-down menu. Now "state" is inserted in the search field. I tried things like state=ne, state is ne, state .eq. ne, and so on, but all the search attempts fail, even though I have contacts with stations in Nebraska (and all of the QSOs with USA stations have the state info present).

73, k4jh

[DL2RUM]

This option is for an advanced user only. You can query direct the log database using the SQLite syntax: http://www.sqlite.org/lang.html
The most simple syntax for your example is:

Code: Select all

select * from logbook where state like "NE"

You should use the search options provided in the Search Window. I marked the relevant settings:

Search.png (22.81 KiB) Viewed 3961 times

Search.png (22.81 KiB) Viewed 3961 times

[k4jh]

Thanks!

73 de K4JH