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

Filtering Vews in Dynamics 365

(0) Share

Report

Posted on by Bidabehere

I have a view and I can filter it using jquery

$(document).ready(function (){
  var list = $(".entitylist.entity-grid")

  list.on("loaded", function () {
    list.find("table tbody tr").each(function () { $(this).find("td").eq(8).remove(); });
    list.find("table thead th").eq(8).remove();
    list.find("table tbody > tr").each(function (index, value) {
      var tr = $(this);
      //the first value in the row
      var code = tr.find("td:eq(0)").text();
     
          if(code != 25526){
            tr.remove();
                    }
                    
    })
  })
 
})

works fine, but there are many empty pages.

someone knows how to remove the rows that do not match and only leave the ones with a specific code. and from there make the paging

Cheers

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Filtering Vews in Dynamics 365

Hi Bidabehere,

The simplest way to filter view in portal is customize the view in dynamics 365, which don’t need any code.

You can first go Portal Management > Entity Lists to check which view is used.

Then go Settings > Customization > Customize the system>entities > views.

Open the view you need, click ‘Edit Filter Criteria’ to set filter.

You can also configure ‘Filter Condition’ and Metadata Filter in entity list form.

for more detailed information, you can refer following link:

https://rajeevpentyala.com/2019/02/16/dynamics-portal-entity-list-filters/

https://community.adxstudio.com/products/adxstudio-portals/documentation/configuration-guide/entity-list/entity-list-filter-configuration/

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Suggested answer

Fubar 2,750 on at

Like (0)

Report

RE: Filtering Vews in Dynamics 365

The Portal entity list is only showing 1 page of the results and so that is all you filter using that method. If you know that the total number of records will be small then increase the number of records (defaults to 10) on the Entity List to cover your data set.

Alternatively, use the out of the box filtering (but not sure exactly what you are filtering on so don't know if this is suitable or not) or write your own in Liquid using FetchXML and JS.