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 gender column can still hold unexpected values like "f", "m", "F", "M").

How

  1. Identify the field(s) most likely to carry the concept (check field names, labels, descriptions). Go from the most likely first.
  2. List the matching values with case-insensitive "contains" patterns. Batch 2–3 candidate patterns in a single call to go faster.
  3. 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.
Installs
1
GitHub Stars
7
First Seen
2 days ago