Gitiles
Code Review
Sign In
gerrit.osmocom.org
/
osmo-mgw
/
eddaa9f19e6894cc2aa4caedb9530348c8210d0f
/
.
/
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
.
].
]