QSO Manager search parameters

Need help? - Post here and we will find a solution for you.
Locked
User avatar
VK7XX
Old Man
Posts: 442
Joined: 24 Jan 2013, 04:07
Location: Planet Earth on Tasmania Island
Contact:

QSO Manager search parameters

Post 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
User avatar
IW3HMH
Site Admin
Posts: 2988
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: QSO Manager search parameters

Post 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
Daniele Pistollato - IW3HMH
User avatar
DF5WW
Log4OM Alpha Team
Posts: 2035
Joined: 02 May 2013, 09:49
Location: Kraam, Rhineland Palatinate, Germany
Contact:

Re: QSO Manager search parameters

Post 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 ;) ;)
73´s .. Juergen ... ALT-512 SDR (10W) , 50 m random wire at SG-211 autotuner, 2 x Xiegu G90 (20W HF TRX) one as portable Radio. Also TS-790E (40 W) for VHF/UHF with X-50 vertical and Duoband 4-Element LPDA.
User avatar
IW3HMH
Site Admin
Posts: 2988
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: QSO Manager search parameters

Post 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:
Daniele Pistollato - IW3HMH
OE6CLD
Log4OM Alpha Team
Posts: 214
Joined: 04 Jun 2013, 08:54
Location: Nuremberg
Contact:

Re: QSO Manager search parameters

Post 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
Claus, OE6CLD/DJ0DX/EI7JZ
User avatar
IW3HMH
Site Admin
Posts: 2988
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: QSO Manager search parameters

Post 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
Daniele Pistollato - IW3HMH
Locked