Microsoft Dynamics 365 | Integration, Dataverse...

JavaScript dynamically filter lookup

(0) Share

Report

Posted on by Community Member

I am required to update the case quick create form so users enter a category [subjectid (lookup to the subject entity) and a subcategory [cb_subcategory (also a lookup to the subject entity). When a user enters a category [subject I'd like to dynamically filter the lookup on the subcategory field [cb_subcategory. It should only be possible to select subjects where the parent subject is the category. If a user changes the category field then the subcategory should be empty.

When a user enters a category [subjectid the JavaScript below successfully adds a filter to the subcategory field. On change of subject the subcategory field [cb_subcategory successfully updates to null but the subcategory lookup filter is not updated. What am I doing wrong?

function setSubjectsFilter(executionContext) {
    formContext = executionContext.getFormContext();
    formContext.getAttribute("cb_subcategory").setValue(null);
    formContext.getControl("cb_subcategory").addPreSearch(filterSubCategory);
    debugger;
}

function filterSubCategory(){
    var parentSubject = (formContext.getAttribute("subjectid").getValue()[0].id).replace("{", "").replace("}", "");
    debugger;
        var fetchXML = "" 
        "" 
          "" 
          "" 
            "" 
          "" 
        ""
      "";
      console.log(fetchXML);
      debugger;
        var layoutXML = "" 
        "                " 
        "                  " 
        "                " 
        "              ";
        var viewID  = "00000000-0000-0000-0000-000000000010";
        var viewDisplayName = "SubCategories";
    if(parentSubject != null) 
    {
        formContext.getControl("cb_subcategory").addCustomView(viewID, "subject",viewDisplayName, fetchXML, layoutXML, true);
    }
    else{
        formContext.getControl("cb_subcategory").setVisible(false);
    }
}

All responses (3)

Answers (0)

Suggested answer

JeganathanG 27 on at

Like (0)

Report
RE: JavaScript dynamically filter lookup

Hi,

Here's an example of how you can dynamically filter the "cb_subcategory" lookup field based on the selected "subjectid" value in JavaScript:

function setSubjectsFilter(executionContext) { formContext = executionContext.getFormContext(); formContext.getAttribute("cb_subcategory").setValue(null); formContext.getControl("cb_subcategory").addPreSearch(filterSubCategory); } function filterSubCategory() { var parentSubject = (formContext.getAttribute("subjectid").getValue()[0].id).replace("{", "").replace("}", ""); var fetchXML = "" "" "" "" "" "" "" ""; var layoutXML = "" "" "" "" ""; var viewID = "00000000-0000-0000-0000-000000000010"; var viewDisplayName = "SubCategories"; if (parentSubject != null) { formContext.getControl("cb_subcategory").addCustomView(viewID, "subject", viewDisplayName, fetchXML, layoutXML, true); } else { formContext.getControl("cb_subcategory").setVisible(false); } }

In this code, the setSubjectsFilter function sets the value of the "cb_subcategory" attribute to null and adds a "pre-search" event to the "cb_subcategory" control. The filterSubCategory function filters the data in the "cb_subcategory" lookup field based on the selected value of the "subjected" field.
Suggested answer

Community Member on at

Like (0)

Report

RE: JavaScript dynamically filter lookup

Hi Celal Bey,

I don't think you did something wrong. I tested your code with Subject entity and I got the same error with yours. The custom view can't be updated. And I also tried addCustomFilter() method and it can't work as well.

Then I created another entity which has many to one relationship to Subject entity and also create a one to many relationship to case entity. And just changed the properties name in your code, it could work:

Change Query to Service:

So as a workaround, you could create a custom entity.

I'm not sure why this code can't work on Subject entity. This could be a bug. I recommend you contact Microsoft Support.
SP9 25 on at

Like (0)

Report

RE: JavaScript dynamically filter lookup

Use formContext as parameter in function definition

function filterSubCategory(formContext)

{

............

}