News and Announcements icon

Dynamics 365 CommunityForums Service | Customer Service, Contact Center, Fie... We want to filter the ...

Service | Customer Service, Contact Center, Fie...

Unanswered

We want to filter the Products on purchase order

(0) Share

Report

Report

Posted on by Anubha Soni

35

Hi there,

we want to achieve the functionality in which I want to filter the product lookup according to the vendor lookup. there is the N:N relationship between the two, to achieve this functionality I have written the javaScript where we are fetching the records of product as per vendors.

The Problem i am facing is, that my javaScript is extracting the products but when i am attaching it with the product lookup, it is showing an error that 0x80072500 Invalid URI: The Uri string is too long.

it might be possible because of the large number of products that are coming up in my results, so how do I resolve it .

Here is my FetchXml in script which i am using,

fetchXml = "<filter type ='or'>";

for (var i = 0; i < results.value.length; i++) {

var product = results.value[i]["_fwh_product_value"];

if (product != null || product != undefined) {

//getting Vendors Products

fetchXml += "<condition attribute='productid' operator='eq' value='{" + product + "}'/>";

}

}

fetchXml += "</filter>";

formContext.getControl("product").addCustomFilter(fetchXml);

Thanks!

All responses Img

All responses (1)

Answers Img

Answers (0)

Anubha Soni 35 on at

Like (0)

Report

RE: We want to filter the Products on purchase order

Hi,

it is quite urgent please, respond to it.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,149 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans