Page 1 of 1
How to do partial search through log?
Posted: 16 Dec 2013, 10:23
by yt9tp
When I open dialog to set search option to do partial search is to use LIKE, but it matches only from beginning of the string.
I have to search for some entries where keyword is in the middle of the string. How can I do that?
Re: How to do partial search through log?
Posted: 16 Dec 2013, 10:29
by G4POP
Very soon we will be adding the facility to use regex (Regular Expression) searches which will provide this type of search and many others.
Please let me know what field you want to search on and what is the string with the keyword and I will endeavour to help
Re: How to do partial search through log?
Posted: 16 Dec 2013, 10:35
by yt9tp
Usually I need it for callsign and comment field but i guess it could be used on other fields too.
Regexp would be nice as advanced tool, but I guess it would be more easier for users to have simple option CONTAINS in that drop down list as that is probably the most common search criteria.
Re: How to do partial search through log?
Posted: 16 Dec 2013, 10:56
by G4POP
Yes I agree and when we rework the search parameters we will probably add "Contains" and "Or" for multiple field searches, plus a few other useful ones.
The only way I can think of to do this with the existing search system is to search on a known part of the string
e.g.for something like finding K7PT from the QSO's below
PJ6/G4POP
PJ6/K7PT
PJ6/IW3HMH
Use Like (Starts with) PJ6/
This would refine the list perhaps enough for you to identify the K7PT you are looking for?
Perhaps you can narrow the list further by adding more search fields of know information like Country, mode, band etc
Unfortunately I can't guess how soon the additional search facilities will be added, my best guess is in V2.00 sometime in 2014
Re: How to do partial search through log?
Posted: 16 Dec 2013, 12:31
by yt9tp
Actually, I am running for RAEM diploma and all stations counting have RAEM as suffix in call sign. Also if I want to sort out QSOs for SOTA, WFF, WCA and other awards, keywords may be anywhere in comment field.
I guess until option is added I will have to export log and try to filter out QSO/s in some other manner.
Or maybe to connect directly to database...
Re: How to do partial search through log?
Posted: 17 Dec 2013, 09:55
by IW3HMH
Log4OM adds the % at the end of the search string.
To search "DANIELE" in the whole string, try searching for "%DANIELE"
Re: How to do partial search through log?
Posted: 17 Dec 2013, 10:55
by yt9tp
It works. Thanks!
Functionality is there, it is just not documented!

Re: How to do partial search through log?
Posted: 20 Dec 2013, 11:00
by IW3HMH
we will update our docs

Thanks for reporting