How To Search Approved Sources and Records with Multiple Keywords in Loocey

Overview

In this tutorial, we’ll learn to use the Starts With Any and Ends With Any filters for searching by multiple keywords.

Step by step

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

1. For example, if we had a list of company names and we wanted to find all records matching with those company names, we would use Starts With Any, Ends With Any or Contains Any filter conditions.
2. These options will allow us to enter either comma separated keywords or multiple keywords, one per line.
3. Let’s go to Approved Sources page and let’s say we had a list of 10 companies and we wanted to see if those companies are in the database or not.
4. Let’s open the filters, add a filter, select company name, and Starts With Any condition, we’ll see a input box to enter all of our keywords.
5. Let’s insert the some examples we have and let the system find the matching ones with Starts With option.
6. If it doesn’t find the ones we have searched it will only show the matching ones. And the same with the other filter options.
7. As you may have guessed, the other options, Ends With Any or Contains Any options will work as name implies.The ends with option, will do match if keyword is found at the end of the company name.
8. Contains Any will do a match if keyword is found anywhere in the company name.
9. These filters are global and work on all types of columns and not just company name columns.

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