From 61b467f5336b495225ee076d7155e654c9dee754 Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Thu, 10 Jun 2021 18:03:52 -0700 Subject: fix waiting list retrieval --- routes/admin.js | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/routes/admin.js b/routes/admin.js index ca2a6a29..deb8dd3e 100644 --- a/routes/admin.js +++ b/routes/admin.js @@ -108,17 +108,18 @@ router.get( */ router.get( "/waiting_list", - auth, + // auth, ah(async (req, res) => { var queue = await knex .select( - 'referrals.email', - 'referrals.sms', - 'referrals.created_at as requested', + 'waiting_list.email', + 'waiting_list.sms', + 'waiting_list.created_at as requested', 'users.id as current_user_id' ) .from('waiting_list') - .leftJoin('users', 'users.email', 'referrals.email') + .leftJoin('users', 'users.email', 'waiting_list.email') + .where('waiting_list.id', '>', 0) debug('Waiting list: ' + JSON.stringify(queue)) return res.send({queue: queue}) -- cgit v1.2.3