AXL: how should the pattern looks like in ListLineReqSearchCriteria, when pattern starts with "+"

[berndgreiner]

Hi together,

I would like to do something like that, but I get no lines:

ListLineReq listLineReq = new ListLineReq();
ListLineReqSearchCriteria listLineReqSearchCriteria = new ListLineReqSearchCriteria();
listLineReqSearchCriteria.pattern = "+49123456789";
listLineReqSearchCriteria.routePartitionName = "myPartition";
listLineReq.searchCriteria = listLineReqSearchCriteria;

Also when I try:

listLineReqSearchCriteria.pattern = "\+49123456789"

I get no line.

And yes, the line "+49123456789" exists.

BTW, when I do something like that I get a line:

GetLineReq getLineReq = new GetLineReq();
getLineReq.ItemsElementName = new ItemsChoiceType60[] { ItemsChoiceType60.pattern, ItemsChoiceType60.routePartitionName };
getLineReq.Items = new object[] { "\+49123456789", "myPartition"};

Any suggestions?

[dstaudt]

It seems the underlying Informix IDS database CUCM uses has something funky going on with its escape character default.  I can't quite figure out what, but you can force it using the ESCAPE keyword, in a custom SQL query:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/12.5">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLQuery sequence="?">
         <sql>SELECT dnorpattern,description,fkroutepartition,tkpatternusage FROM numplan
         	    WHERE dnorpattern LIKE '\\+%' ESCAPE '\'</sql>
      </ns:executeSQLQuery>
   </soapenv:Body>
</soapenv:Envelope>

[berndgreiner]

Sorry, but this does not help me.

Yes, I know when using sql statement you have escape the "extension" with a prefix "+" (E.164)  like:

"SELECT dnorpattern,description,fkroutepartition,tkpatternusage from numplan where dnorpattern = '\\+49123456789'"

But here I want to use ListLineReqSearchCriteria when using ListLineReq  as mentioned above.

The question is how should the string for the pattern looks like when I have a phone number in E.164 format that it works???

When I have no "+" as prefix then it works:

ListLineReq listLineReq = new ListLineReq();
ListLineReqSearchCriteria listLineReqSearchCriteria = new ListLineReqSearchCriteria();
listLineReqSearchCriteria.pattern = "123456789";
listLineReqSearchCriteria.routePartitionName = "myPartition";
listLineReq.searchCriteria = listLineReqSearchCriteria;

AXLAPIService.listLine(listLineReq );

But when I have a "+" as prefix then it does NOT work:

ListLineReq listLineReq = new ListLineReq();
ListLineReqSearchCriteria listLineReqSearchCriteria = new ListLineReqSearchCriteria();
listLineReqSearchCriteria.pattern = "\\+49123456789";
listLineReqSearchCriteria.routePartitionName = "myPartition";
listLineReq.searchCriteria = listLineReqSearchCriteria;

AXLAPIService.listLine(listLineReq );

[berndgreiner · Accepted solution]

It works like this when I have a "+" as prefix:

ListLineReq listLineReq = new ListLineReq();
ListLineReqSearchCriteria listLineReqSearchCriteria = new ListLineReqSearchCriteria();
listLineReqSearchCriteria.pattern = "\\\\+49123456789";
listLineReqSearchCriteria.routePartitionName = "myPartition";
listLineReq.searchCriteria = listLineReqSearchCriteria;

AXLAPIService.listLine(listLineReq );