Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Join MessageOut and MessageIn tables
sp_NewPost Add Reply sp_NewTopic Add Topic
May 23, 2023
11:17 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Jhiancarlo,

There is no clear link between the USSD request in the MessageOut/MessageLog table and the corresponding USSD reply in the MessageIn table because the USSD transaction does not have a unique transaction ID. To connect the two you can compare the date and time of the USSD request and the USSD reply from the same gateway.

Regards, Henk

May 22, 2023
8:24 pm

How can I join the MessageOut table with MessageIn to capture the message that is obtained as a response after sending a USSD query. I am using SQL Server as connector.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
6 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502