Getting SQL Error while using Filter option

[praveenpkm92]

PFA for both my input fetchXML & error details

[dsvyner]

Hi,

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

Thanks

Dan

[dsvyner]

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