SQL Keywords
The following keywords can be used in the SQL templates used for logging
outgoing and incoming SMS messages.
Incoming messages
| $username | The user or application who received a copy
of the message |
| $msgtype | The message type |
| $msgid | The ozeki message ID assigned to the message |
| $sender | The sender phone number |
| $receiver | The recipient phone number |
| $msgsubject | The first 1024 characters of the messages
text |
| $msgdata | The message text |
| $senttime | The time the messages was sent to the mobile
network |
| $receivedtime | The time the message was received |
| $operator | The service provider name specified on the
configuration form of the service provider connection that received the
message. |
| $pducount | The number of messages: in how many parts the original message was sent. |
Messages accepted for delivery
| $username | The user or application who posted the
message |
| $msgtype | The message type |
| $msgid | The ozeki message ID assigned to the message |
| $sender | The sender phone number |
| $receiver | The recipient phone number |
| $msgsubject | The first 1024 characters of the messages
text |
| $msgdata | The message text |
| $acceptedfordeliverytime | The time when the messages was
delivered to the network |
| $cost | The number of message parts it took to send the
message. |
| $operator | The list of serviceprovider names specified
by the user sending the message |
| $usedoperator | The name of the Service Provider connection
which used for sending out the message. |
Messages delivered to network
| $deliveredtonetworktime | The time the message was
delivered to the network |
| $callbackid | A reference string returned by the mobile
network operator (or the service provider) when the message was
delivered to the network. This number can be used as reference. |
| $msgid | The ozeki message ID assigned to the message |
| $sentthroughbackup | The message was sent through a backup
route. Possible values: yes/no |
| $serviceoperator | The service provider name specified on
the configuration form of the service provider connection, where the
message was actually sent to the network. |
| $servicephonenum | The telephone number specified on
the configuration form of the service provider connection, where the
message was actually sent to the network. |
| $serviceprovider | The connection name (logfile name)
assigned by ozeki to the service provider connection, where the
message was actually sent to the network. |
| $usedoperator | The name of the Service Provider connection
which used for sending out the message. |
Messages delivered to handset
| $deliveredtohandsettime | The time the message was
delivered to the destination handset |
| $msgid | The ozeki message ID assigned to the message |
| $usedoperator | The name of the Service Provider connection
which used for sending out the message. |
Message delivery error
| $errormessage | The error message |
| $msgid | The ozeki message ID assigned to the message |
| $usedoperator | The name of the Service Provider connection
which used for sending out the message. |
