Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
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: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_EditHistory sp_Permalink sp_Print sp_QuotePost Quote

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
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

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 ?

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488