logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Using OR in the same spot alert filter
K7PDW
#1 Posted : Monday, December 3, 2018 3:50:19 PM(UTC)
DAVE

Rank: Advanced Member

Groups: Registered
Posts: 61
Location: Syracuse, Utah

Thanks: 11 times
Was thanked: 8 time(s) in 8 post(s)
When I use the Expression Builder it only lets me build the following select criteria (CQ_ZONE='18' OR CQ_ZONE='22').
Can I expand the criteria as follows, (CQ_ZONE='18' OR CQ_ZONE='21' OR CQ_ZONE='22' OR CQ_ZONE='23' OR CQ_ZONE='34' OR CQ_ZONE='37' OR CQ_ZONE='39') by typing in the additions filter criteria in the select criteria area of the Spot Alert Setup window? I do not get a syntax error so am I correct in thinking that this is ok?

Dave, K7PDW
Sponsor
WN4AZY
#2 Posted : Tuesday, December 4, 2018 1:43:31 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 2,212
Man
Location: Auburn, GA

Thanks: 402 times
Was thanked: 298 time(s) in 236 post(s)
Yes, that looks good to me! The parenthesis are actually not necessary. Not sure why the Query By Example form includes them.


Here is another way:

INLIST(CQ_ZONE, '18, 21', '22', '23', '34', '37, '39')




Tnx & 73,

Dennis WN4AZY
1 user thanked WN4AZY for this useful post.
K7PDW on 12/4/2018(UTC)
Users browsing this topic
Guest (2)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.032 seconds.