"in" filter keyword

How to achieve this in convex?

SELECT 
    employee_id,
    first_name,
    last_name,
    department,
    salary,
    hire_date
FROM 
    employees
WHERE 
    employee_id IN (101, 102, 105);

SELECT 
    employee_id,
    first_name,
    last_name,
    department,
    salary,
    hire_date
FROM 
    employees
WHERE 
    employee_id IN (101, 102, 105);

7 Replies

lee•11mo ago

In this sql example, is there an index on employee_id?

Coffee11OP•11mo ago

yes will be querying _id

lee•11mo ago

If so, the equivalent in convex would be await Promise.all(ids.map((id)=>ctx.db.get(id)))

Coffee11OP•11mo ago

thank you @lee

erquhart•11mo ago

fyi, had to coach it a bit on style, but the docs ai chat converted this sql into a complete convex query really well

Coffee11OP•11mo ago

ai chat in convex website?

erquhart•11mo ago

Yep, kapa may work just as well too Could be handy if you already think in sql

"in" filter keyword

Did you find this page helpful?