How to do partial search through log?

yt9tp · Post by **yt9tp** » 16 Dec 2013, 10:23

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?

Post by **G4POP** » 16 Dec 2013, 10:29

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

yt9tp · Post by **yt9tp** » 16 Dec 2013, 10:35

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.

Post by **G4POP** » 16 Dec 2013, 10:56

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

yt9tp · Post by **yt9tp** » 16 Dec 2013, 12:31

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...

Post by **IW3HMH** » 17 Dec 2013, 09:55

Log4OM adds the % at the end of the search string.

To search "DANIELE" in the whole string, try searching for "%DANIELE"

yt9tp · Post by **yt9tp** » 17 Dec 2013, 10:55

It works. Thanks!

Functionality is there, it is just not documented!

Post by **IW3HMH** » 20 Dec 2013, 11:00

we will update our docs

Thanks for reporting

How to do partial search through log?

How to do partial search through log?

Re: How to do partial search through log?

Re: How to do partial search through log?

Re: How to do partial search through log?

Re: How to do partial search through log?

Re: How to do partial search through log?

Re: How to do partial search through log?

Re: How to do partial search through log?