Gitiles
Code Review
Sign In
gerrit.osmocom.org
/
osmo-gbproxy
/
0e8e18ee000878e254812c864b7f3e7974e1a69b
/
.
/
openbsc
/
contrib
/
sms
/
hlr-query.st
blob: bd3f97a4af9c82b8f45093e86f2f4185838e95fd [
file
] [
log
] [
blame
]
"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
.
].
]