User defined scalar function of sql in MS CRM

(0) Share

Report

Posted on by Community Member

Hello Guys,

I got a requirement where I have to convert all sql queries to MS CRM fetchxml I am able to do simple and straight-forward queries but I don't have knowledge how to convert sql user defined function ex Select memcod, memtxn, memupdat, dbo. Examplefunction(xyz) as exfunc where Id=1

Plz help

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

Hello,

I'm really sorry but this is not possible.

Inside FetchXml report you can't use user-defined functions so to make your report work you will have to move usage of a function from a query level to report level. What is the purpose of that function(functions)?

Was this reply helpful? Yes No