lookup-values
Installation
SKILL.md
Verifying field values before filtering
Before you filter on a value, confirm it actually exists in the data in that exact form. Filtering on a guessed literal ("Second-hand", "male", "VN") silently returns wrong or empty results when the stored form differs.
When to use
- Any filter on a dimension whose exact stored values you haven't confirmed.
- Especially categorical / text fields — and even "obvious" ones (a
gendercolumn can still hold unexpected values like "f", "m", "F", "M").
How
- Identify the field(s) most likely to carry the concept (check field names, labels, descriptions). Go from the most likely first.
- List the matching values with case-insensitive "contains" patterns. Batch 2–3 candidate patterns in a single call to go faster.
- Once you've identified the exact value(s), proceed to the real query. Don't keep using lookups to compute the answer — write the AQL.