From fa4ed0f3b1ce5decfc6ee59d38e63e78a7793de4 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Fri, 22 Dec 2017 07:11:26 +0100 Subject: new keyword form --- bucky/db/index.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'bucky/db/index.js') diff --git a/bucky/db/index.js b/bucky/db/index.js index e26124a..d3ee2ea 100644 --- a/bucky/db/index.js +++ b/bucky/db/index.js @@ -224,7 +224,7 @@ db.getKeyword = function (keyword) { return Keyword.query("where", "keyword", "=", keyword).fetch() } db.getThreadGroups = function (keyword) { - return knex.column('keyword').sum('viewed').as('viewed').column('id').column('title').column('lastmodified').column('privacy').select().from('threads').groupBy('keyword') + return knex.column('keyword').sum('viewed').as('viewed').count('*').as('count').column('id').column('title').column('lastmodified').column('privacy').select().from('threads').groupBy('keyword') } db.createKeyword = function(data){ return new db.Keyword(data).save() -- cgit v1.2.3-70-g09d2