Page 1 of 1

QSO Manager search parameters

Posted: 01 Sep 2014, 06:08
by VK7XX
Is it possible to use QSO manager to search my log for a series of letters in a suffix and, if so, how ?? For example, I would like to search for all calls I have worked that have XX in the suffix.... possible :?:


73
John
VK7XX

Re: QSO Manager search parameters

Posted: 01 Sep 2014, 13:44
by IW3HMH
you should not set anything in the qso manager top field, and set search parameters in the grid itself, using the "ends with" parameter

Re: QSO Manager search parameters

Posted: 01 Sep 2014, 14:26
by DF5WW
Hi Daniele,

tried this and using "Callsign" in the search paramaters. I found a "LIKE (starts with)" in the dropdown but not a "ends with" ..... Have tried to use end with in the field where i can set what i need but "ends with WW" and also "(ends with) WW" are not given a result and i have worked many stations with WW in the suffix :D B.t.w. the "" which you can see here in my description i not used in the search paramaters ....

Not shure i´m a "Dummy" but i got no result when i search for "WW" .... Latest QSO with a "WW" Suffix was 2day on 20 with RA/DL5WW ;) ;)

Re: QSO Manager search parameters

Posted: 02 Sep 2014, 15:55
by IW3HMH
mumble mumble...
i was pretty sure that was in the list of parameters...
something new to add... let me think if i can have other brilliant ideas... :D :mrgreen:

Re: QSO Manager search parameters

Posted: 03 Sep 2014, 19:10
by OE6CLD
Looks like the

Code: Select all

LIKE(starts with)
automatically adds a % at the end, so

Code: Select all

CALL LIKE '%XX'
does not work.

A normal LIKE would solve this (without adding anything), so the user can use whatever he wants ('XX%' (beginning), '%XX%' (middle), or '%XX' (end).

With Christmas coming closer, I also would love to have the REGEXP operator, which would make it easier to parse my comment and note fields :D

73,
Claus, EI7JZ/OE6CLD

Re: QSO Manager search parameters

Posted: 04 Sep 2014, 13:03
by IW3HMH
use LIKE without %
It's already built in at software side (not everyone knows how "like" works in SQL)
This means a % is placed on at the END of every string by code...
i need to create a "custom query" field for that