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



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

Rank: Advanced Member

Groups: Registered
Posts: 79
Location: Syracuse, Utah

Thanks: 15 times
Was thanked: 13 time(s) in 12 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
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
#2 Posted : Tuesday, December 4, 2018 1:43:31 PM(UTC)

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 2,454
Location: Auburn, GA

Thanks: 559 times
Was thanked: 361 time(s) in 286 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
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 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.037 seconds.