Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

how apply where condition in out table
sp_NewPost Add Reply sp_NewTopic Add Topic
December 14, 2015
8:21 pm
Henk Helmantel
Forum Posts: 519
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Ali,

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.

Regards, Henk

December 14, 2015
8:15 pm

Hi Henk,

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 ?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 354

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 512

Posts: 1773

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 519