Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

filter sql database
sp_NewPost Add Reply sp_NewTopic Add Topic
October 19, 2013
4:37 pm
Henk Helmantel
Forum Posts: 519
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Erick,

The SQL Connector has a fairly simple approach to get SMS messages from the database and store received SMS message to the database. It does not offer functions to filter messages except in order to identify which messages are already handled and on the scheduled message field.

If you want Diafaan SMS Server to do more advanced operation on the database, you can use the Scripting Connector to access the database, filter on any database field and perform other advanced functions. You can find some basic example scripts in the scripting pack that show how to use a C# script to do a simple information look up operation from a database when an SMS message is received. Scripting in Diafaan SMS Server is powerful but requires programming skills in C# or Visual Basic.NET.

Regards, Henk

October 18, 2013
4:17 pm

We have an application where the data is located, we need to route from the modem 1 by example from our database filtering status='send' not status=0 as by default you use, and add another field to filter like date, or customerid, or other flieds, how can we do it?

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: 511

Posts: 1772

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 519