我被困在如何通過to字段中的電子郵件地址從電子郵件實體過濾器中查詢。private static EntityCollection GetEmails(IOrganizationService service, string entityName, string emailaddress, ColumnSet cols) { QueryExpression query = new QueryExpression { EntityName = "email", Criteria = new FilterExpression { //FilterOperator = LogicalOperator.And, Conditions = { new ConditionExpression { AttributeName = "statuscode", Operator = ConditionOperator.LessThan, Values = { 1 } } } }, LinkEntities = { new LinkEntity { LinkFromEntityName = "activitypointer", LinkFromAttributeName = "activityid", LinkToEntityName = "activityparty", LinkToAttributeName = "activityid", LinkCriteria = new FilterExpression { FilterOperator = LogicalOperator.And, Conditions = { new ConditionExpression { AttributeName = "addressused", Operator = ConditionOperator.Equal, Values = { "agus@yahoo" } } } } } } }; return service.RetrieveMultiple(query); }右邊有一條記錄，其中to字段包含agus@yahoo. 但是此方法返回零記錄。
2 回答
交互式愛情
TA貢獻1712條經驗 獲得超3個贊
您應該使用ConditionOperator.Likewith%而不是ConditionOperator.Equal
更新：
我很快在 XrmToolBox Fetchxml builder 中進行了查詢，并從那里復制了等效的 QueryExpression。是的，你必須使用activityparty而不是activitypointer. （不確定您的查詢如何因未找到列而失敗?。浚?/p>
// Instantiate QueryExpression QEemail
var QEemail = new QueryExpression("email");
QEemail.TopCount = 50;
// Add columns to QEemail.ColumnSet
QEemail.ColumnSet.AddColumns("activityid", "activitytypecode");
// Define filter QEemail.Criteria
QEemail.Criteria.AddCondition("activitytypecode", ConditionOperator.Equal, 4202);
// Add link-entity QEemail_activityparty
var QEemail_activityparty = QEemail.AddLink("activityparty", "activityid", "activityid");
// Add columns to QEemail_activityparty.Columns
QEemail_activityparty.Columns.AddColumns("addressused");
// Define filter QEemail_activityparty.LinkCriteria
QEemail_activityparty.LinkCriteria.AddCondition("addressused", ConditionOperator.Like, "%arunvinoth%");
MMMHUHU
TA貢獻1834條經驗 獲得超8個贊
為了完整起見，這里是代碼..
private static EntityCollection GetEmails(IOrganizationService service, string entityName, ColumnSet cols)
{
QueryExpression query = new QueryExpression
{
EntityName = "email",
Criteria = new FilterExpression
{
//FilterOperator = LogicalOperator.And,
Conditions = {
new ConditionExpression {
AttributeName = "statuscode",
Operator = ConditionOperator.Equal,
Values = { 1 }
}
}
},
LinkEntities = {
new LinkEntity {
LinkFromEntityName = "email",
LinkFromAttributeName = "activityid",
LinkToEntityName = "activityparty",
LinkToAttributeName = "activityid",
LinkCriteria = new FilterExpression {
FilterOperator = LogicalOperator.And,
Conditions = {
new ConditionExpression {
AttributeName = "addressused",
Operator = ConditionOperator.Like,
Values = { "%" + "agus@yahoo" + "%" }
}
}
}
}
}
};
return service.RetrieveMultiple(query);
}
- 2 回答
- 0 關注
- 230 瀏覽
添加回答
舉報
0/150
提交
取消