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?
How to do partial search through log?
How to do partial search through log?
YT9TP, op. Pedja, QTH Uzice, Serbia, http://www.yt9tp.iz.rs
- G4POP
- Log4OM Alpha Team
- Posts: 10815
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: How to do partial search through log?
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
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
73 Terry G4POP
Re: How to do partial search through log?
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.
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.
YT9TP, op. Pedja, QTH Uzice, Serbia, http://www.yt9tp.iz.rs
- G4POP
- Log4OM Alpha Team
- Posts: 10815
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: How to do partial search through log?
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
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
73 Terry G4POP
Re: How to do partial search through log?
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...
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...
YT9TP, op. Pedja, QTH Uzice, Serbia, http://www.yt9tp.iz.rs
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: How to do partial search through log?
Log4OM adds the % at the end of the search string.
To search "DANIELE" in the whole string, try searching for "%DANIELE"
To search "DANIELE" in the whole string, try searching for "%DANIELE"
Daniele Pistollato - IW3HMH
Re: How to do partial search through log?
It works. Thanks!
Functionality is there, it is just not documented!
Functionality is there, it is just not documented!
YT9TP, op. Pedja, QTH Uzice, Serbia, http://www.yt9tp.iz.rs
- IW3HMH
- Site Admin
- Posts: 2927
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: How to do partial search through log?
we will update our docs
Thanks for reporting
Thanks for reporting
Daniele Pistollato - IW3HMH