Selecting Lookup View Dynamically Using JavaScript In Dynamics CRM/ 365

Ashish Vishwakarma
7y
55.1k
0
1

Article

Lookup Views are shown when the user clicks on "Look Up More Records" in any Lookup field. In Dynamics CRM/365, Lookup Views are available in almost all entities. In newly created custom entities also, it will be available by default. Lookup View of Account Entity is shown.

Introduction

If you haven’t worked with Lookup Views before, follow the below screenshots, or you can skip to the next section.

Dynamics CRM

Parent Account field is a Lookup in Account, so you can see Lookup View here.

Dynamics CRM

Setting Custom View with JavaScript

Now, if we want to show some other View here by default, the setDeafautView() method does our job. See the syntax below.

Xrm.Page.getControl("<ControlName>").setDefaultView("<ViewGUID>");

Now, the question is how to get View Id. Well, Advanced Find is here to the rescue.

Select Look for as "View" and condition as "Equals".

Dynamics CRM

Select your desired View from Lookup. It must belong to your Entity otherwise it won’t show any error but won’t work also, I am taking Active Accounts view Here.

Download and Open Fetch XML

Dynamics CRM

You can find View ID here, which is {00000000-0000-0000-00AA-000010001002} for me.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="savedquery">
<attribute name="name" />
<attribute name="description" />
<attribute name="savedqueryid" />
<order attribute="name" descending="false" />
<filter type="and">
<condition attribute="savedqueryid" operator="eq" uiname="Active Accounts" uitype="savedquery" value="{00000000-0000-0000-00AA-000010001002}" />
</filter>
</entity>
</fetch>

Let’s use this in setDefaultView() and use in Form. I am setting this to Parent Account of Account Main Form onLoad event. Add below code to JS web resource and Add to Form.

function formOnLoad(){
Xrm.Page.getControl("parentaccountid").setDefaultView("{00000000-0000-0000-00AA-000010001002}");
}

Attach the function to Form OnLoad event, and Save & Publish it.

Dynamics CRM

Now, go back to the Account Form, refresh it to Load JavaScript, and in Parent Account, click Look Up More Records.

Congrats! Your default Lookup View is "Active Accounts" now.

Dynamics CRM

Let’s make it more generic and useful by retrieving View Id from the name with WebAPI AJAX call.

I’m creating new generic function with name setLookupViewByName(). Replace your web resource content with the below-given code. Then, save and publish it.

function formOnLoad() {
setLookupViewByName("parentaccountid", "Customers", true);
}
function setLookupViewByName(fieldName, viewName, asynchronous) {
var req = new XMLHttpRequest();
req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/savedqueries?$select=savedqueryid&$filter=name eq '" + viewName + "'", asynchronous);
req.setRequestHeader("OData-MaxVersion", "4.0");
req.setRequestHeader("OData-Version", "4.0");
req.setRequestHeader("Accept", "application/json");
req.setRequestHeader("Content-Type", "application/json; charset=utf-8");
req.setRequestHeader("Prefer", "odata.include-annotations=\"*\"");
req.onreadystatechange = function () {
if (this.readyState === 4) {
req.onreadystatechange = null;
if (this.status === 200) {
var results = JSON.parse(this.response);
if (results.value.length > 0) {
var savedqueryid = results.value[0]["savedqueryid"];
Xrm.Page.getControl(fieldName).setDefaultView(savedqueryid);
} else {
Xrm.Utility.alertDialog(viewName + " view is not available.");
}
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
}