aboutsummaryrefslogtreecommitdiffstats
path: root/openbsc/contrib/sms/hlr-query.st
blob: bd3f97a4af9c82b8f45093e86f2f4185838e95fd (plain)
1
2
3
4
5
6
7
8
9
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.
].
]