Help/Advice on using Custom searches

Need help? - Post here and we will find a solution for you.
DF2MC
Advanced Class
Posts: 63
Joined: 20 Sep 2015, 06:55

Re: Help/Advice on using Custom searches

Post by DF2MC »

However I got it myself, took me some times, but now it works fine !

should be like this: log.Country = 'Japan' AND (log.mode = 'JT65' OR log.mode = 'JT9')

I did not use the parentheses: (log.mode = 'JT65' OR log.mode = 'JT9')

At > search parameter >Simple if I combine Country-Mode1-Mode2 no result only one mode is ok,
it seems a singel OR or a singel AND command is needed, to get the country and the requested 2 different modes out.

Well, I am a SQLite dummy, sorry for my question !
Perhaps it may help some others as well !

73 Hans DF2MC
User avatar
IW3HMH
Site Admin
Posts: 2925
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: Help/Advice on using Custom searches

Post by IW3HMH »

your query:
Country = 'Japan' AND Mode = 'JT9' OR Mode = 'JT65'
The OR in jt65 works with "japan and jt9) screwing up your results

correct query:
Country = 'Japan' AND (Mode = 'JT9' OR Mode = 'JT65')
Daniele Pistollato - IW3HMH
Locked