Custom search

QSO logging software for the Mac
k4jh
Posts: 33
Joined: Sat 13. Aug 2011, 10:25

Custom search

Unread post by 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
User avatar
DL2RUM
Administrator
Posts: 2770
Joined: Mon 27. Aug 2007, 13:36
Location: JO40DF

Re: Custom search

Unread post by 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
Search.png (22.81 KiB) Viewed 3083 times
Search.png
Search.png (22.81 KiB) Viewed 3083 times
73 and best dx de Tom, DL2RUM
k4jh
Posts: 33
Joined: Sat 13. Aug 2011, 10:25

Re: Custom search

Unread post by k4jh »

Thanks!

73 de K4JH
Locked