Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

sd_dataform Primary.TelephoneNumber

Highlighted
Patrick Geschin
Acclaimed Contributor

sd_dataform Primary.TelephoneNumber

Hi,

i've got a problem.
From my CTI Application i want to open a ServiceCall with prefilled Organization which i will get from the Primary.TelephoneNumber.

It works fine if the Primary.TelephoneNumber is exact as the Telephone number who calls in.
If someone call from the organization with another ISDN Msn SD doesn't recognize it.

I tried this CMD Line Arguments:

"Servicecall" -ForceNew "+Organization.PrimaryTelephonenumber[StartsWith]00160979245*" "+Status=Completed"

with no effect.

Can somebody help ?
6 REPLIES
Ruth Porter
Honored Contributor

Re: sd_dataform Primary.TelephoneNumber

Hi Patrick,

I don't think you can use a forceNew with a Startswith condition; as far as I am aware it will only fill in the details if it can find an EXACT match.

If the phone number matches exactly what is held in organisation, I think it should work. Try
-ForceNew "+Organization.PrimaryTelephonenumber=ExactMatch"

Hope this helps

Ruth
http://www.teamultra.net
Patrick Geschin
Acclaimed Contributor

Re: sd_dataform Primary.TelephoneNumber

Yes this works fine.

But my problem is that from one organization
some people calls with
direct-inward number.

As Example:

Organization Tel.number in HPOVSD is
0511-12345-0

but the one who calls has the direct-inward Tel.number
0511-12345-12

I want to get the Organization who starts with 0511-12345.






Ruth Porter
Honored Contributor

Re: sd_dataform Primary.TelephoneNumber

Hi Patrick,

I do not think you can do this using sd_dataform unless the CTI application can remove the training digits that cause the lack of match.

Can you get the CTI application to assist in this way?

Hope this helps

Ruth

http://www.teamultra.net
Patrick Geschin
Acclaimed Contributor

Re: sd_dataform Primary.TelephoneNumber

The CTI Application i wrote myself.
So i've got the full control of the Tel.Number.

I think i will try with SQL Statements against the OVSD Database.

Thanks for your help

BR

Patrick
Ruth Porter
Honored Contributor

Re: sd_dataform Primary.TelephoneNumber

Hi Patrick,

Just a word of warning about using SQL statements; because of the locks mechanism I would recommend only using SQL to read the DB and not to insert a SC.

If you have control of the CTI application and you know that the critical part of the phone number is (say) the first n characters, then you could have a custom field on the organisation which just had those n characters (say call it OrgTel), and then use
+Organization.OrgTel=truncated number

Hope this helps

Ruth
http://www.teamultra.net
Patrick Geschin
Acclaimed Contributor

Re: sd_dataform Primary.TelephoneNumber

I work with the Like Operator
so i didn't need an extra Field.

The User which connects just have db_read rights.

Here's my Statement.

SELECT ORG_SEARCHCODE FROM ITSM_ORGANIZATIONS WHERE ORG_PRIMARYTELNR LIKE @BS_SEARCH

I kill the 3 last Characters from the tel.number

This work fine now
//Add this to "OnDomLoad" event