How to select specific value in JSON field
Hello,
i'am strugling how to get specific value from json field. I want to get the processor value from the selection_group field
This is working:
const result = await db.run(sql
SELECT supplier, brand, selection_group->>'processor', COUNT("id") as productCount
FROM products
GROUP BY supplier, brand, selection_group->>'processor');
When i use this:
.select(sqlsupplier, brand, selection_group->>'processor', COUNT("id") as productCount)
.from(products)
.groupBy(products.brand, products.supplier)
.$dynamic();
i get the error: Maximum call stack size exceeded
and when i use
.select({
brand: products.brand,
supplier: products.supplier,
processor: products.selection_group.processor,
count: count(products.id),
})
.from(products)
.groupBy(products.brand, products.supplier)
.$dynamic();
i get error: Cannot convert undefined or null to object
the last code is my preferred way of doing this code and here i have to add also a group by on the processor field.
i also don't know how to do this.
Hopefully someone knows how to solve this problem.2 Replies