search

bcolpaert / Colso.Xrm.DataTransporter

XrmToolbox plugin to help you to transfer records across organizations
MIT License
21 stars 15 forks source link

Getting SQL Error while using Filter option #46

Open praveenpkm92 opened 4 years ago

praveenpkm92 commented 4 years ago

ErrorDataTrans PFA for both my input fetchXML & error details

dsvyner commented 3 years ago

Hi,

I am also having this issue. Is there a solution for this?

Thanks

Dan

dsvyner commented 3 years ago

Hi @praveenpkm92 I have found the issue for me was rather than copying in the whole fetchxml you only need the filter section

for example my original fetch was:

but once i stripped this back to the filter only:

<filter type="and">
  <condition attribute="nfp_volunteeringroleid" operator="eq" uiname="Student Takeover" uitype="nfp_volunteeringrole" value="{27F1BAB5-F666-EB11-A812-0022481A59DB}" />
</filter>

This worked for me

Hope that helps

Dan