List view – only show parent rows with vLookup data

[AdamP]

I’ve got a need to only display rows in the parent list when they have vLookup child items, basically a high level filter of the parent list using data from the child list.
Unfortunately the vLookupIsLoadedCallback doesn’t work for list views;

Please note that this code does NOT trigger in a list view, only in NewForm, DispForm and EditForm.

I think I’ve come up with a reasonable method to achieve what I need, but would welcome feedback and ideas to improve on it. This snippet is added to a CEWP below the list and CEWP containing vLookup_ListView.html;

setInterval(function(){
$( “span.vLookupNoItemsLabel” )
.closest( “tr.ms-itmhover” )
.hide();
}, 2000);

It runs on a 2 second interval, looks for the vLookupNoItemsLabel class in the list view, then hides the associated table row for the parent item. I think the 2 second interval should account for grouping expand/collapse and delayed or slow loading of the vLookup. See attached a couple of images standard/filtered

Any thoughts?

AdamP

• This topic was modified 6 years, 3 months ago by AdamP.

Attachments:

1. 

   vLookupStandard.png
   

2. 

   vLookupFiltered.png
   

[Author]

Posts