Microsoft Dynamics CRM oData串联 [英] Microsoft Dynamics CRM oData concatenation

问题描述

http://crmDomain.com:5555/myCompany/xrmservices/2011/OrganizationData.svc/AccountSet?$select=AccountId&$filter=concat(Address1_Line1, Address1_Line2) eq '123 Main StSte D' and Address1_City eq 'Omaha' and Address1_StateOrProvince eq 'NE'

/>
在Microsoft Dynamics CRM 2011中，我尝试进行实时重复检测.在某些情况下，已输入地址，其中街道地址位于街道1，单元号位于街道2，在其他情况下，地址全部位于街道1.我希望能够在串联的街道1和街道2上进行查找，以便只需点击一次服务就可以解决.

In Microsoft Dynamics CRM 2011 I''m attempting to do duplicate detection real time. In some instances addresses have been entered with Street address in Street 1 and Unit # in Street 2 and in other instances it is all on street 1. I want to be able to do a lookup on a concatenated Street 1 and Street 2 so that I can get by with only hitting the service once. Does the iOrganization service support concatenation?

推荐答案

select = AccountId&

select=AccountId&

filter = concat(Address1_Line1，Address1_Line2)eq'123 Main StSte D'和Address1_City eq'Omaha'和Address1_StateOrProvince eq'NE'

filter=concat(Address1_Line1, Address1_Line2) eq '123 Main StSte D' and Address1_City eq 'Omaha' and Address1_StateOrProvince eq 'NE'

在Microsoft Dynamics CRM 2011中，我尝试进行实时重复检测.在某些情况下，已输入地址，其中街道地址位于街道1，单元号位于街道2，在其他情况下，地址全部位于街道1.我希望能够在串联的街道1和街道2上进行查找，以便只需点击一次服务就可以解决. iOrganization服务是否支持串联?

In Microsoft Dynamics CRM 2011 I''m attempting to do duplicate detection real time. In some instances addresses have been entered with Street address in Street 1 and Unit # in Street 2 and in other instances it is all on street 1. I want to be able to do a lookup on a concatenated Street 1 and Street 2 so that I can get by with only hitting the service once. Does the iOrganization service support concatenation?

这篇关于Microsoft Dynamics CRM oData串联的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！