Page 2 of 2

Re: Help/Advice on using Custom searches

Posted: 07 Nov 2015, 13:02
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

Re: Help/Advice on using Custom searches

Posted: 08 Nov 2015, 07:21
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')