Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Created by: Gionata Navarra on 22-06-2010 03:50:40 PM Hi all. I've used Axl on CUCM 7.0 to retrieve data about EndUsers. With a simple query I obtained informations requested but trying to aggregate results with GROUP_CONCAT I have following exception: javax.xml.ws.soap.SOAPFaultException: Routine (group_concat) can not be resolved. at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:189) at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:130) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119) at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89) at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:118) this is the query: "SELECT EU.userid, D.name, GROUP_CONCAT(NP.DnOrPattern) from Enduser EU, Device D, DeviceNumPlanMap DNPM, NumPlan NP WHERE D.fkEnduser==EU.pkid AND D.pkid==DNPM.fkDevice AND DNPM.fkNumPlan==NP.pkid GROUP BY EU.pkid, D.pkid" I've added GROUP_CONCAT to obtain a single instance of each EndUser with a list of multiple lines, and not an instance of EndUser for each line. E.g: User A with 3 lines Expected res: User A --> line1, line2, line3 and not: User A --> line 1 User A --> line 2 User A --> line 3 Is there any other way to aggregate fields? Thank you Gionata Navarra
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: