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

Gowtham

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)

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gowtham8y ago
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 S8y ago
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 < ctx.ListData.Row.length; 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();

}

}