How to override the sort and filter for share-point column

Question

Hi, I am working on CSR rendering I have hidden some list item using jslink,on columns sort and filter it shows hidden items also. In breif ,I have two column in a list Column1 column2 A test1 B test2 A test3 D test4 I have hidden two list items B,D Column1 Column2 ->(for sort option it shows(all items(test1,test2,test3,test4))) A test1 but i need like(test1,test3). A test3 I want to show that on sort which is visible (test1,test3)

Gowtham · Answer

Using CSR - I have hide the list items of lookup column which is sd and ss in charoption column,but when i click the filter in header column , it shows all lookup items as show in the above screenshot. i need to hide/remove the sd and ss lookup filter which is like below screenshot. And even for all header column filter according to their items respectively. Code for your reference : (function() { var overrideCurrentContext = {}; overrideCurrentContext.Templates = {}; overrideCurrentContext.Templates.Item = Rows; SPClientTemplates.TemplateManager.RegisterTemplateOverrides(overrideCurrentContext); })(); function Rows(ctx) { if(ctx.CurrentItem.charoption[0].lookupValue!="efd") { return ""; } return RenderItemTemplate(ctx); }

Manimekalai S · Answer

Hi, The below code is used to hide the blank column. Make the code change in highlighted area according to your requirement (function () { // Create object that have the context information about the field that we want to change it's output render var linkFiledContext = {}; linkFiledContext.Templates = {}; // Add OnPostRender event handler to hide the column if empty linkFiledContext.OnPostRender = linkOnPostRender; SPClientTemplates.TemplateManager.RegisterTemplateOverrides(linkFiledContext); })(); function linkOnPostRender(ctx) { var linkCloumnIsEmpty = 1; for (i = 0; i if (ctx.ListData.Row[i][ "Link" ]) { linkCloumnIsEmpty = 0; break ; } } //Hide "Link" column if it is empty if (linkCloumnIsEmpty) { var cell = $( "div [name='Link']" ).closest( 'th' ); var cellIndex = cell[0].cellIndex + 1; $( 'td:nth-child(' + cellIndex + ')' ).hide(); $( 'th:nth-child(' + cellIndex + ')' ).hide(); } }