How To Use Dynamic Value Filters To Track High-Priority Part Numbers & NSNs – DLA/DIBBS

Overview

Dynamic Value Filters allows you to use a list or a table as the input for filters instead of values manually. For this example, we’ll use the new Dynamic Value Filters to track high-priority part In this tutorial, we’re going to learn how to use Dynamic Value Filters in Loocey. This is a new feature that allows to create dynamic filters.

Step by step

The walkthrough covered in the video, written out so you can follow along inside Loocey.

1. Dynamic Value Filters allows you to use a list or a table as the input for filters instead of values manually.
2. For this example, we’ll use the new Dynamic Value Filters to track high-priority part In this tutorial, we’re going to learn how to use Dynamic Value Filters in Loocey. This is a new feature that allows to create dynamic filters.
3. So, let’s get started, first we’ll try the manual way so you can see the difference.
4. First, go to the Bidding Board.
5. click on Filters then add filter.
6. From the dropdown, select NSN as the Name.
7. Next, for the Condition, choose in.
8. At this point, you can type in the list of NSNs you want to track.
9. For this example, let’s take this NSNs:
10. Let’s save the view and name it My NSNs
11. Then let’s Do a Save As and name it My NSNs 2
12. Let’s edit the new view and add the 3rd NSN in the filters and save.
13. Now, if we go back to My NSNs view and look at the filters, we’ll see the initial 2 NSNs we had entered, and because we entered the 3rd one on the other view, it’ll only be available for the other view.
14. As you can see, this may create an issue of us remembering to edit all the views if our list of NSNs changes.
15. We can solve this with the new Dynamic Value filters. The idea is that, instead of manually entering the NSNs in the filters, we’ll keep the NSNs in a separate list and map our filters to the list, so that if we ever add additional NSNs to the list, all the views will be updated automatically.
16. Now, let’s see how the new Dynamic Filter Values work.
17. First we’ll create a new List, call it High Priority NSNs and enter all of our 3 examples in that list.
18. The idea is that we want to use this list for filtering, so anytime we want to change the filters, we’ll just have to update the values in this list.
19. Next, let’s go to the Main Table and create a new view and we’ll mostly follow the same process, select NSN column.
20. For the Condition, choose in, but this time switch it over to Dynamic Values.
21. Then, choose the list we just created — in this case, High Priority NSNs — and also select Name.
22. Finally, click Apply.
23. And that’s it! Loocey will now automatically find and display the NSNs included in our list.
24. Now, Let’s save our view.
25. Click on save then choose save as new. We’ll call this view High Priority NSN, and hit Save.
26. So, if later we decide to add more NSNs to our High Priority NSNs list, the saved view will automatically include them. So everything updates dynamically.
27. That means there’s no need to manually update the filters each time — Loocey takes care of it for you.
28. Let’s test it, we’ll add the 4th example to the High Priority NSNs list and go back to our view, we should see the new item in the list as well, and we didn’t have to change any of the filters.

Where this fits

This tutorial covers the Advanced & Related-Data Search part of Loocey DLA. Cross-join RFQs with approved sources, approved parts and award history to answer questions DIBBS cannot.

• Loocey DLA Getting Started guide — account setup and the full bidding workflow
• Saved-search recipes — the exact column, condition and value for 20 common DLA searches
• DLA / DIBBS glossary — what every field on a solicitation means
• All Loocey DLA video tutorials