Sql to fetchXml limitations

(0) Share

Report

Posted on by Don foufione

270

I was trying to convert the below Sql request to fetch xml, unfortunately the count and haviang are not supported in fetch xml, is there any way to get this done and have the same result?

select PLI.productID, PLI.Customerid, count(*) as 'Total'

from productlist PLI

where

pricelisttype = '100000002'

and PLI.statecode = 0

and PLI.productID is not null

and PLI.Customerid is not null

and ('2017-04-06' between PLI.Startdate and PLI.EndDate)

group by PLI.productID,PLI.Customerid

having count(*)>1

order by Total desc

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nithya Gopinath 17,078 on at

Like (0)

Report

RE: Sql to fetchXml limitations

Hi Don,

You can't use SQL functions in FetchXML query. CRM has support for some built-in functions, but any additional SQL functions are not supported.

See: www.kingswaysoft.com/.../Limitations-with-CRM-FetchXML

Was this reply helpful? Yes No