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
When i use this:
.select(sql
.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.
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(sql
supplier, 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.
