Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_TopicIcon
how apply where condition in out table
sp_NewPost Add Reply sp_NewTopic Add Topic
December 14, 2015
8:21 pm
Henk Helmantel
Admin
Forum Posts: 551
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
ALI
Guest
Guests

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:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 364

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 532

Posts: 1844

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 551