I’d like to filter SharEPoint list using values from another list via JS Link. I know how to filter using for example list of ID’s. I found nice article for that but now I need firstly to connect to another list then find relevant item and take value from relevant column to use it as a filter. For filtering I use the following function:
(function () { var excludeRows = [0,2,3]; function renderListItemTemplate(renderCtx) { if(excludeRows.indexOf(renderCtx.CurrentItemIdx) > -1) { return ''; //do not render row } return RenderItemTemplate(renderCtx); } function registerListRenderer() { var context = {}; context.Templates = {}; context.Templates.Item = renderListItemTemplate; SPClientTemplates.TemplateManager.RegisterTemplateOverrides(context); } ExecuteOrDelayUntilScriptLoaded(registerListRenderer, 'clienttemplates.js'); })()
As I mentioned it works for me. Now I’d like to retrieve some data from another list to filter this list. I try to use SP.ClientContext() … firstly but it doesn’t work for me. I suppose problem with code structure or maybe I have to load any library before. I have no idea how to do it correctly. Maybe another idea would be useful?