Skip to main content

D365 lookup Custom filtering javascript

 In my case, I need to add custom filtering when I select a lookup it will populate another lookup. when the user will click on the search icon it will show only filter data. 

I was following: https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/controls/addpresearch

sample code:

 var demoLAB = demoLAB || {};   
 var classId;   
  demoLAB.Stuedent = {   
   Form: {   
    Load: function (executionContext) {   
     'use strict';   
     var formContext = executionContext.getFormContext();       
     this.attachEvents(executionContext);   
    },   
    attachEvents: function (executionContext) {   
     'use strict';   
     var formContext = executionContext.getFormContext();   
     var form = demoLAB.Stuedent.Form;       
     // Student Change Event   
     formContext.getAttribute("demo_studentId").addOnChange(form.studentOnChange);       
     
    },   
    studentOnChange: function (executionContext) {   
     'use strict';   
     var formContext = executionContext.getFormContext();   
     var form = demoLAB.Stuedent.Form;   
     if (formContext.getAttribute("demo_studentId").getValue() != null) {   
      var studentId = formContext.getAttribute("demo_studentId").getValue()[0].id.slice(1, -1);   
      // Retrive current student current class   
      Xrm.WebApi.retrieveRecord("student", studentId, "?$select=_classId_value").then(   
       function success(studentResult) {   
        classId = studentResult._classId_value;   
        // Add presearch for teacher    
        formContext.getControl("demo_teacherId").addPreSearch(form.filterTeacher);   
       },   
       function (error) {   
       }   
      );   
     }   
    },   
    // Call back function for teacher    
    filterTeacher: function (executionContext) {   
     'use strict';   
     var formContext = executionContext.getFormContext();   
     var teacherFilter = "<filter type='and'><condition attribute='demo_classId' operator='eq' value='" + classId + "'/></filter>";   
     formContext.getControl("demo_teacherId").addCustomFilter(teacherFilter, "teacher");   
    },         
   }   
  };   


Comments

Popular posts from this blog

The calling thread must be STA, because many UI components require this.

Using Thread: // Create a thread Thread newWindowThread = new Thread(new ThreadStart(() => { // You can use your code // Create and show the Window FaxImageLoad obj = new FaxImageLoad(destination); obj.Show(); // Start the Dispatcher Processing System.Windows.Threading.Dispatcher.Run(); })); // Set the apartment state newWindowThread.SetApartmentState(ApartmentState.STA); // Make the thread a background thread newWindowThread.IsBackground = true; // Start the thread newWindowThread.Start(); Using Task and Thread: // Creating Task Pool, Each task will work asyn and as an indivisual thread component Task[] tasks = new Task[3]; // Control drug data disc UI load optimize tasks[0] = Task.Run(() => { //This will handle the ui thread :The calling thread must be STA, because many U...

SQL Query Execution time of you in SQL Management Studio

You can check the Execution time of you SQL Query in SQL Management Studio. like this It is very simple that you just put your SQL Query in to the Estimated time execution query DECLARE @StartTime datetime DECLARE @EndTime datetime SELECT @StartTime=GETDATE() -- Write Your Query SELECT @EndTime=GETDATE() --This will return execution time of your query SELECT DATEDIFF(NS,@StartTime,@EndTime) AS [Duration in millisecs]

An error occurred while updating the entries. See the inner exception for details.

If you are using EF then you may get the error. This error is not specify where the error exactly occur in your table. To specify the error use this code & use debugger to see the exact error message. try { //Your code db = new FEDALIC_AGRI_DBEntities (); model.FarmerVillage = new Guid(village); model.FarmerThana = new Guid(thana); model.FarmerDistrict = new Guid(district); var _SET_FARMER_INFO = EMFermar.SetToModelObject(model); db.SET_FARMER_INFO.Add(_SET_FARMER_INFO); db.SaveChanges(); } catch (DbUpdateException e) { var innerEx = e.InnerException; while (innerEx.InnerException != null) innerEx = innerEx.InnerException; throw new Exception(innerEx.Message); } catch (DbEntityValidationException e...