|
let queryString = `SELECT products.*, json_agg( |
let queryString = `SELECT products.*, json_agg(
json_build_object(
'feature', features.feature,
'value', features.value
)
) as features FROM products JOIN features ON products.id=features.product_id WHERE products.id=$1 group by products.id`;
let queryString = `
SELECT products.*, json_agg(
json_build_object(
'feature', features.feature,
'value', features.value
)
) AS features
FROM products
JOIN features
ON products.id=features.product_id
WHERE products.id=$1 group by products.id`;
Products/Server/Model/index.js
Line 16 in 8f36ce4