using array of ids as a where clause, using magic sql operator
I really need some help here:
const query = sql` SELECT ${Statistics.variantId}, ${Statistics.from}, SUM(${Statistics.count}) AS conversions FROM ${Statistics} WHERE ${Statistics.variantId} IN ( ${variantIds.join(',')} ) GROUP BY ${Statistics.variantId}, ${Statistics.from} ORDER BY ${Statistics.from} ASC; `;
const query = sql` SELECT ${Statistics.variantId}, ${Statistics.from}, SUM(${Statistics.count}) AS conversions FROM ${Statistics} WHERE ${Statistics.variantId} IN ( ${variantIds.join(',')} ) GROUP BY ${Statistics.variantId}, ${Statistics.from} ORDER BY ${Statistics.from} ASC; `;
I'm getting an error on
variantIds.join(',')
variantIds.join(',')
saying
invalid input syntax for type bigint: "1920,1921"
invalid input syntax for type bigint: "1920,1921"
these variant ids come from a different database so i can't use a subquery like i was using before. Thank you