Re: Spot Collector Email Alarm ?


Joe Subich, W4TV
 

With multiple elements, the correct syntax is:

Callsign in ('C91BVA', ZF2BJ', 'PJ7AA', 'LY11LY') or
Callsign like ('*/KH9') or Callsign like ('KH9*')

"in" expects a list of discrete elements (individual calls),
"like" supports wildcards (incomplete calls).


73,

... Joe, W4TV

On 2021-03-02 10:08 AM, w2eck wrote:
When entering an SQL expression in the Email Alarm Trigger panel are parenthesis required around the call signs entered?
For example:
     callsign =( 'KH9', 'C91BVA', ZF2BJ'. 'PJ7AA', 'ly11ly')
Also are the single quotes marks around each call required?
tnx & 73
Paul
w2eck

Join DXLab@groups.io to automatically receive all group messages.