From 4849c6ac324df67d2f5fc20ed4a958fe9a2bfa1f Mon Sep 17 00:00:00 2001 From: Adam Soltys Date: Fri, 25 Sep 2020 16:25:28 -0700 Subject: group account balances by pubkey --- routes/info.js | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/routes/info.js b/routes/info.js index 5f9e06df..f8a0fa72 100644 --- a/routes/info.js +++ b/routes/info.js @@ -17,9 +17,10 @@ app.get("/balances", ah(async (req, res, next) => { const accounts = await db.Account.findAll({ attributes: [ "asset", + "pubkey", [sequelize.fn("sum", sequelize.col("balance")), "total"] ], - group: ["asset"], + group: ["asset", "pubkey"], }); let lnchannel; -- cgit v1.2.3