import json
db = json.load(open("/home/rmlac2fmr/public_html/jn.com/ops/data/db.json"))

p = next((p for p in db["persons"] if "brown" in p.get("lastName","").lower() and "dean" in p.get("firstName","").lower()), None)
if p:
    print(f"Person: dept='{p.get('dept','')}' (len={len(p.get('dept',''))})")
    print(f"  repr: {repr(p.get('dept',''))}")

r = next((r for r in db["travelRequests"] if p and r.get("personId") == p["id"]), None)
if r:
    print(f"Request: submittedDept='{r.get('submittedDept','')}' (len={len(r.get('submittedDept',''))})")
    print(f"  repr: {repr(r.get('submittedDept',''))}")

# Check what depts the filter uses
depts = set()
for req in db["travelRequests"]:
    pr = next((p for p in db["persons"] if p["id"] == req.get("personId")), None)
    d = pr["dept"] if pr and pr.get("dept") else req.get("submittedDept","")
    if d:
        depts.add(d)
print(f"\nAll depts in travel requests: {sorted(depts)}")