Search Across Warehouses (SOSL)

public List<Product__c> searchProducts(String searchTerm) {
    List<List<sObject>> searchResults = [
        FIND :searchTerm IN ALL FIELDS
        RETURNING Product__c(Id, Name__c, SKU__c)
    ];

    return (List<Product__c>) searchResults[0];
}

1. public List<Product__c> searchProducts(String searchTerm) { — this is Module 21's SOSL pattern from Module 22's library search, applied to Product__c instead of Book__c.
2. List<List<sObject>> searchResults = [ — opens the search.
3. FIND :searchTerm IN ALL FIELDS — one search matching either the product name or its SKU.
4. RETURNING Product__c(Id, Name__c, SKU__c) — the object and fields.
5. ]; — closes the search.
6. (blank line)
7. return (List<Product__c>) searchResults[0]; — casts back to a specific type.
8. } — closes the method.

public List<Warehouse_Stock__c> searchProductsWithStock(String searchTerm) {
    List<Product__c> matchingProducts = searchProducts(searchTerm);

    Set<Id> productIds = new Set<Id>();
    for (Product__c product : matchingProducts) {
        productIds.add(product.Id);
    }

    return [
        SELECT Id, Product__r.Name__c, Warehouse_Name__c, Quantity_On_Hand__c
        FROM Warehouse_Stock__c
        WHERE Product__c IN :productIds
    ];
}

1. public List<Warehouse_Stock__c> searchProductsWithStock(String searchTerm) { — combines search with a stock lookup.
2. List<Product__c> matchingProducts = searchProducts(searchTerm); — the SOSL search finds matching products.
3. (blank line)
4. Set<Id> productIds = new Set<Id>(); — a Set<Id> (Module 16) to collect their Ids.
5. for (Product__c product : matchingProducts) { — loops over the matches.
6. productIds.add(product.Id); — collects each Id.
7. } — closes the loop.
8. (blank line)
9. return [ — opens a single follow-up SOQL query.
10. SELECT Id, Product__r.Name__c, Warehouse_Name__c, Quantity_On_Hand__c — the fields needed.
11. FROM Warehouse_Stock__c — the object.
12. WHERE Product__c IN :productIds — IN :productIds (Module 20) pulls every stock record for all of them at once — no query inside a loop.
13. ]; — closes the query.
14. } — closes the method, effectively answering "search and show stock" in one call.

SOSL is excellent at finding matching products, but Warehouse_Stock__c records don't directly contain searchable text like a product name — they only reference a product by Id. Getting from "found matching products" to "here's their stock breakdown" genuinely needs a second, related query, exactly like this lesson's two-step method. Recognizing when a single tool (SOSL) needs a follow-up step is itself part of designing this kind of feature well.