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).


... 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

Join to automatically receive all group messages.