AXL - Query LineGroups for specific DN

[mmusysnet]

I'm trying to figure out if there is a simple approach to locating which LineGroups a particular Directory Number is associated with without a listLineGroup and searching the members, is this possible with SOAP AXL or using SQL or will I have to listLineGroups and expand on the members seperately (or am i trying to simplify an already simple process)

[Anthony Holloway]

You could use SQL via AXL to run the following query:

select n.dnorpattern as dn, l.name as linegroup from linegroupnumplanmap as m left join numplan as n on m.fknumplan = n.pkid left join linegroup as l on m.fklinegroup = l.pkid where n.dnorpattern = ''

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.