Knowledge Base

How to quick filter items by using column header on List Collection Web Part?

After roll up list items from different SharePoint sites on a List Collection Web Part using BoostSolutions’ List Collection, you can enable filter on column header, and then filter the items based on a column value as same as in SharePoint list.

Now, let’s demonstrate how to enable filter on column header to quick filter items on List Collection Web Part.

WHAT YOU'LL GET

WHAT YOU'LL NEED

The sample data we use for this case

There is another SharePoint list named as PT Tasks with following columns and tasks on a SharePoint site – PT Project.

Quick filter items by using column header on List Collection Web Part

  1. Download the trial version of List Collection and install it to your SharePoint server.

  2. Navigate to page or site where you want to add the List Collection web part to, click the Edit command in the top right of the page.

    Or click Settings and then click Edit Page.

    If you already add SharePoint lists on the List Collection Web Part, please skip to step 11 to create an item directly.

  3. Click the Insert tab, and then click Web Part.

  4. Under Categories, select BoostSolutions Web Parts; then select BoostSolutions List Collection Web Part; lastly click Add.

  5. On the Web Part, click Add Collection Part from Settings menu.

  6. On the Add Collection Part page, in Collection Information From Site section, select site Project PT; select list PT Tasks, and keep other options as default.

  7. In Column Mapping section, select the following columns.

  8. Then click OK.

  9. Repeat step 5 to 8 to add another SharePoint list DC Tasks on List Collection Web Part.

  10. And then, you will find that the items of above two lists are shown on the List Collection Web Part as following.

  11. Click Create Collection View in Settings menu.

  12. In the Create View page, choose Standard View.

  13. In the View Name box, type the name for this view. Select Make this the default view option to make this the default view.

  14. In the Audience section, under View Audience, select Create a Personal view or Create a Public view. Here we select Create a Public View option.

  15. In the Filter section, choose two lists which means that the items of these lists items will be shown in this view.

  16. In the Columns section, select checkboxes before the following columns, which means that the columns will be shown in the view.

  17. In the Edit Menu section, select one column which is used to linked to context menu, here we select Task Name.

  18. In the Header Filter section, select the checkbox before Enable filter on header option.

  19. Keep default settings for other settings and click OK.

    The configuration and functionality of these sections are same as SharePoint, you can refer to SharePoint’s.

  20. Now a standard view is created in the List Collection Web Part as following.

  21. In the view, hover over the header for one column such as Priority and click the down arrow.

  22. In the lower section of the drop-down box, click High.

  23. Then the items which Priority is High are shown on the list collection web part as following.

  24. To clear the filters, click Clear Filer from Priority in the drop-down box.

Login