diff options
Diffstat (limited to 'contrib/sms/hlr-query.st')
| -rw-r--r-- | contrib/sms/hlr-query.st | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/contrib/sms/hlr-query.st b/contrib/sms/hlr-query.st new file mode 100644 index 000000000..bd3f97a4a --- /dev/null +++ b/contrib/sms/hlr-query.st @@ -0,0 +1,10 @@ +"Query for one SMS" + +Eval [ +1 to: 100 do: [:each | + Transcript show: 'SELECT SMS.* FROM SMS + JOIN Subscriber ON SMS.receiver_id = Subscriber.id + WHERE SMS.id >= 1 AND SMS.sent IS NULL AND Subscriber.lac > 0 + ORDER BY SMS.id LIMIT 1;'; nl. +]. +] |