This document was generated from CDN thread
Created by: Jacob Henson on 11-01-2012 03:15:35 PM
Goal: I want to be
able to generate a list of users and their 10 digit phone number using AXL.
I am able to query the enduser table to get their extension. But how do I tie that information to a transformation
to figure out the 10 digit number.
In an ideal result set I would get back 3 columns User, extension,
and transformation.
Userid extension transformation
user1 83245 1555555XXXX
user2 89804 1555555XXXX
If anyone could tell me the right table combination, I would be able to write the query. Thanks for any help.