Page 1 of 1

Custom search

Posted: Wed 30. Jul 2014, 02:18
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

Re: Custom search

Posted: Wed 30. Jul 2014, 10:00
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 3112 times
Search.png
Search.png (22.81 KiB) Viewed 3112 times

Re: Custom search

Posted: Wed 30. Jul 2014, 11:40
by k4jh
Thanks!

73 de K4JH