topic Interaction between Telecom and ITSM in App Development

Interaction between Telecom and ITSM

jagadesh — Tue, 27 May 2025 17:16:05 GMT

Hi Folks,

I'm Developing SLAs for one Account, i have a requirement is the combination of ITSM and Telecom. based on these 2 sources i have to showcase data for 1 SLA.

For Telecom i have separate template in that template i will be loading ITSM data by using Ad hoc. here the ITSM data has been loaded but interaction between these two tables not available because there is no matching columns to join in the script. can anyone please help me out how we can join both tables. i tried to join with the company and Account columns but not getting expected result. please find the below columns for reference.

ITSM Columns:

Number,
Company
sys_created_on,
sys_created_on,
Type,
State,
opened_at,
closed_at,
WaitTime,
handling_duration

Telecom Columns:

Call_ID
Accountid
Accountname
Arrive_Datetime
Callduration
Wrap_time
Answered_In_SLA

Re: Interaction between Telecom and ITSM

-SW- — Wed, 28 May 2025 14:40:58 GMT

Hi,

Technically you can join any field(s) from one table to another table by simply having the same field names.

However your issue is most likely due to the data underneath rather than the fieldnames itself. If those data values dont match completely (case-sensitive), they will not link. You will need to inspect the data before deciding what to link.

Re: Interaction between Telecom and ITSM

jagadesh — Wed, 28 May 2025 15:43:06 GMT

here having account column in telecom company in ITSM. but we can give alias name for company for join but this condition also not working. each record getting multiple times that is wrong. so without any matching column is there any possibility to join both tables?

Re: Interaction between Telecom and ITSM

-SW- — Wed, 28 May 2025 15:57:12 GMT

Unfortunately, wont be able to help without seeing the data.

If you can annonymise, and display a few screenshots of the data model and also the front end, this will help.