FetchXML query with link entities giving error: Generic SQL error.

(0) Share

Report

Posted on by Community Member

Hi,

We have a fetchxml query which works one of our CRM instance while fails on another instance with error: Generic SQL error.

gc_orderlineitem is a text field on 'gc_productkey' entity which holds the GUID of salesorderdetail.

One more observation on the CRM instance where the query fails was that when we remove either of the link statements, query successfully gives results.

Note: Both are Dynamics 365 instances with same CRM version.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

Link entity works if you have relationship between two entities, i.e. lookup of one entity on another entity.

In your case "gc_orderlineitem" is a text field if you make it lookup then it may solve your issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Thanks for reply.

FetchXML works for fields even if they are not lookup. In the 'gc_orderlineitem' field we store the GUID of order line item.

Was this reply helpful? Yes No
Verified answer

Alex Fun Wei Jie 33,628 on at

Like (0)

Report

Hi,

I would advice you to use one of the tool in XRMtoolbox called fetchxml builder to build the query and test the result.

https://fxb.xrmtoolbox.com/

Was this reply helpful? Yes No