« Back to Administration XML Questions

Searching Directory Numbers

Combination View Flat View Tree View
Threads [ Previous | Next ]
Hi,
 
im looking for a method, that returns all directory numbers, which are starting with a 55 for example. I only found the listRoutePlanByType method, which returns all DNs, but there ist no filter.
 
Does anyone have an idea?
 
greetings
 
Rocco

what version are you using? I think that request is not available from 8.x ?

Anyway, you could use listRoutePlan and use dnOrPattern (i.e. 55*) and type in the searchCriteria

oh sorry i forget it to post, we have the 7.1(3)

you cann try to use the axl method "executeSQLQuery" with the parameter

<sql>SELECT numplan.dnorpattern AS numplan_dnorpattern FROM numplan WHERE numplan.dnorpattern LIKE '55%'</sql>

yes of cause with a sql statement, but i want to know an axl-soap-method not an direct sql statement

Rocco Prielipp:
yes of cause with a sql statement, but i want to know an axl-soap-method not an direct sql statement

 
Rocco,
The ListRoutePlanReq is just performing a SQL query for you. When it ask for the dnOrPattern use the SQL pattern i.e 55% would return 55 and anything after that. This is also true for type and partition. i.e if you have a partition name "MyPT" and you search "My%" it would return "MyPT" You can also flip these around and use %55 which would return 12355. You can even do %55% which would return 125534. Hope this helps!

And I apologize I thought it worked on partition as well but I was incorrect.

Is listLine available in 7.x?  I have been working in 8.6 so not paying attention to older ones. 
 
listLine allows wildcards (oddly the % sign) so:
<ns:listLine sequence="?">
    <searchCriteria>
        <pattern>55%</pattern>
    </searchCriteria>
</ns:listLine sequence="?">