News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Query Builder Error on...

Customer experience | Sales, Customer Insights,...

Answered

Query Builder Error on Lookup field

(0) Share

Report

Report

Posted on by MadhanSA

115

Hi,

I have a contact lookup field in accounts and I have added a javascript for custom filtering. I am getting '0x80041103 Query Builder Error' while clicking on the lookup.

My fetchXML looks like :

var fetchXML="<link-entity name='ct_contactrole' from='ct_contact' to='contactid' link-type='inner' alias='ab'><filter type='and'><condition attribute='ct_account' operator='eq' value='{RecordID}' /></filter></link-entity>";

I am getting the expected contacts through advanced find though. Let me know what am I missing here.

Thanks in advance.

All responses Img

All responses (3)

Answers Img

Answers (1)

MadhanSA 115 on at

Like (1)

Report

RE: Query Builder Error on Lookup field

Thanks Erhan. I have used addCustomView and it worked!!
Suggested answer

Naveen Ganeshe 3,393 User Group Leader on at

Like (0)

Report

RE: Query Builder Error on Lookup field

Hi there!

Please see these links: anubhavbajpai.wordpress.com/.../

community.dynamics.com/.../fetchxml-linked-entity-with-lookup-filter

Hope it will help you
Verified answer

erhan.keskin 2,247 on at

Like (0)

Report

RE: Query Builder Error on Lookup field

Hi,

I assume you use "addPreSearch" for this FetchXML. However, as you use Link Entity, then you should use "addCustomView" instead.

Regards,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans