AnsweredAssumed Answered

web service "getGroupMemberListValues" always return empty list

Question asked by chison.cai on Jun 25, 2018
Latest reply on Jun 25, 2018 by pier-olivier.tremblay

web service "getGroupMemberListValues" always return empty list in CA SDM 17.1


request xml:


<soapenv:Envelope xmlns:soapenv="" xmlns:ser="">
<whereClause>group.last_name != 'abc'</whereClause>


response xml:

<soapenv:Envelope xmlns:soapenv="" xmlns:xsd="" xmlns:xsi="">
<getGroupMemberListValuesResponse xmlns="">
<getGroupMemberListValuesReturn xmlns="">&lt;?xml version="1.0" encoding="UTF-8"?>&lt;UDSObjectList/></getGroupMemberListValuesReturn>



I am sure the groups are already created with members added.

I can capture the sql with sql profile as below.


exec sp_executesql N'SELECT FROM grpmem, ca_contact WHERE grpmem.group_id = ca_contact.contact_uuid AND ca_contact.last_name != @P1',N'@P1 nvarchar(4000)',N'abc'




I can executed the sql manually and get the results.


Why the response list is empty?