Hi all i am trying to retrieve a list of campaign response by using RetrieveMultiple as below: ColumnSet cols_resp = new ColumnSet(); cols_resp.Attributes = new string[] { "activityid" }; ConditionExpression condition_resp = new ConditionExpression(); condition_resp.AttributeName = "customer"; condition_resp.Operator = ConditionOperator.Equal; FilterExpression filter_resp = new FilterExpression(); filter_resp.FilterOperator = LogicalOperator.And; filter_resp.Conditions = new ConditionExpression[] { condition_resp }; QueryExpression query_resp = new QueryExpression(); query_resp.ColumnSet = cols_resp; query_resp.EntityName = EntityName.campaignresponse.ToString(); query_resp.Criteria = filter_resp; condition_resp.Values = new object[] {"69127E88-1C53-DD11-B4CF-0019B9BFB022"}; BusinessEntityCollection responses = service.RetrieveMultiple(query_resp); however,when i run this query, i get "Server was unable to process request." error message. Does anyone know what ConditionOperator and Values should be? thanks!
Can anyone help me? "ludi" wrote: > Hi all > i am trying to retrieve a list of campaign response by using > RetrieveMultiple as below: > ColumnSet cols_resp = new ColumnSet(); > cols_resp.Attributes = new string[] { "activityid" }; > ConditionExpression condition_resp = new ConditionExpression(); > condition_resp.AttributeName = "customer"; > condition_resp.Operator = ConditionOperator.Equal; > FilterExpression filter_resp = new FilterExpression(); > filter_resp.FilterOperator = LogicalOperator.And; > filter_resp.Conditions = new ConditionExpression[] { > condition_resp }; > QueryExpression query_resp = new QueryExpression(); > query_resp.ColumnSet = cols_resp; > query_resp.EntityName = EntityName.campaignresponse.ToString(); > query_resp.Criteria = filter_resp; > condition_resp.Values = new object[] > {"69127E88-1C53-DD11-B4CF-0019B9BFB022"}; > BusinessEntityCollection responses = > service.RetrieveMultiple(query_resp); > > however,when i run this query, i get "Server was unable to process request." > error message. > > Does anyone know what ConditionOperator and Values should be? > > thanks!
I try to use Advance Find to retrieve campaign response by Customer,but i get the 'Invalid Argument' error. (before to do this you need to set searchable to yes for 'customer' attribute in customization) "ludi" wrote: > Hi all > i am trying to retrieve a list of campaign response by using > RetrieveMultiple as below: > ColumnSet cols_resp = new ColumnSet(); > cols_resp.Attributes = new string[] { "activityid" }; > ConditionExpression condition_resp = new ConditionExpression(); > condition_resp.AttributeName = "customer"; > condition_resp.Operator = ConditionOperator.Equal; > FilterExpression filter_resp = new FilterExpression(); > filter_resp.FilterOperator = LogicalOperator.And; > filter_resp.Conditions = new ConditionExpression[] { > condition_resp }; > QueryExpression query_resp = new QueryExpression(); > query_resp.ColumnSet = cols_resp; > query_resp.EntityName = EntityName.campaignresponse.ToString(); > query_resp.Criteria = filter_resp; > condition_resp.Values = new object[] > {"69127E88-1C53-DD11-B4CF-0019B9BFB022"}; > BusinessEntityCollection responses = > service.RetrieveMultiple(query_resp); > > however,when i run this query, i get "Server was unable to process request." > error message. > > Does anyone know what ConditionOperator and Values should be? > > thanks!
when i open the DevErrors in Web.config and try it again i get 'Cannot add attribute customer of type partylist in a condition' error message. "ludi" wrote: > Hi all > i am trying to retrieve a list of campaign response by using > RetrieveMultiple as below: > ColumnSet cols_resp = new ColumnSet(); > cols_resp.Attributes = new string[] { "activityid" }; > ConditionExpression condition_resp = new ConditionExpression(); > condition_resp.AttributeName = "customer"; > condition_resp.Operator = ConditionOperator.Equal; > FilterExpression filter_resp = new FilterExpression(); > filter_resp.FilterOperator = LogicalOperator.And; > filter_resp.Conditions = new ConditionExpression[] { > condition_resp }; > QueryExpression query_resp = new QueryExpression(); > query_resp.ColumnSet = cols_resp; > query_resp.EntityName = EntityName.campaignresponse.ToString(); > query_resp.Criteria = filter_resp; > condition_resp.Values = new object[] > {"69127E88-1C53-DD11-B4CF-0019B9BFB022"}; > BusinessEntityCollection responses = > service.RetrieveMultiple(query_resp); > > however,when i run this query, i get "Server was unable to process request." > error message. > > Does anyone know what ConditionOperator and Values should be? > > thanks!
problem have been resolved as below,it must to use LinkEntity to ActivityParty ColumnSet cols_resp = new ColumnSet(); cols_resp.Attributes = new string[] { "activityid" }; ConditionExpression condition_resp = new ConditionExpression(); condition_resp.AttributeName = "partyid"; condition_resp.Operator = ConditionOperator.Equal; LinkEntity linkap = new LinkEntity(); linkap.LinkFromEntityName = EntityName.campaignresponse.ToString(); linkap.LinkFromAttributeName = "activityid"; linkap.LinkToEntityName = EntityName.activityparty.ToString(); linkap.LinkToAttributeName = "activityid"; linkap.JoinOperator = JoinOperator.Inner; linkap.LinkCriteria = new FilterExpression(); linkap.LinkCriteria.Conditions = new ConditionExpression[] { condition_resp }; QueryExpression query_resp = new QueryExpression(); query_resp.ColumnSet = cols_resp; query_resp.EntityName = EntityName.campaignresponse.ToString(); query_resp.LinkEntities = new LinkEntity[] { linkap }; condition_resp.Values = new string[] {"69127E88-1C53-DD11-B4CF-0019B9BFB022"}; BusinessEntityCollection responses = service.RetrieveMultiple(query_resp); "ludi" wrote: > Hi all > i am trying to retrieve a list of campaign response by using > RetrieveMultiple as below: > ColumnSet cols_resp = new ColumnSet(); > cols_resp.Attributes = new string[] { "activityid" }; > ConditionExpression condition_resp = new ConditionExpression(); > condition_resp.AttributeName = "customer"; > condition_resp.Operator = ConditionOperator.Equal; > FilterExpression filter_resp = new FilterExpression(); > filter_resp.FilterOperator = LogicalOperator.And; > filter_resp.Conditions = new ConditionExpression[] { > condition_resp }; > QueryExpression query_resp = new QueryExpression(); > query_resp.ColumnSet = cols_resp; > query_resp.EntityName = EntityName.campaignresponse.ToString(); > query_resp.Criteria = filter_resp; > condition_resp.Values = new object[] > {"69127E88-1C53-DD11-B4CF-0019B9BFB022"}; > BusinessEntityCollection responses = > service.RetrieveMultiple(query_resp); > > however,when i run this query, i get "Server was unable to process request." > error message. > > Does anyone know what ConditionOperator and Values should be? > > thanks!
