Get Full Route Pattern Info

Version 1
    This document was generated from CDN thread

    Created by: Chris Halverson on 26-07-2013 06:56:57 AM
    I'm basically trying to replicate the Call Routing -> Route Hunt -> Route Pattern then the info from clicking on a "Pattern". I'd like to be able to get this via SQL or AXL (I'll be using Java). In particular, I'll be searching for ones that have "911" in them.

    I am having problems getting the associated Gateway/Route List (whic I think is a "Device"). I also need the "Calling Party Transformation" info.

    The basic query I'm using is:

    select rp.name, np.callingpartytransformationmask, np.dnorpattern from numplan np join routepartition rp on np.fkroutepartition = rp.pkid where np.tkpatternusage = 5 and np.description like '%911%' order by rp.name

    If I need to do multiple queries/AXL calls, no problem, I just feel I'm missing something fairly simple. Any pointers would be appreciated. Thanks!!