This is not possible with Diafaan SMS Server. The SQL Connector does not have the functionality to filter specific messages dependent on the value of a specific field.
You might be able to achieve this with a trigger on the database that copies all records with 'countryid' = '1' to a separate database table and use this table as the 'MessageOut' table in Diafaan SMS Server.
I am using db connector to connect to smpp_out table to fetch msgs and send it ...
smpp_out table contains a filed : "countryid"
I want to bring only msgs with countryid= 1 to send ,,, otherwise ignore the record
can I apply where condition on db connector ?
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 503
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 942