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
Join MessageOut and MessageIn tables
sp_NewPost Add Reply sp_NewTopic Add Topic
May 23, 2023
11:17 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

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

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.

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

Most Users Ever Online: 529

Currently Online:
7 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