From ea13b8d7511b35bb4307ef3d296ca677f50804bc Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 15 Oct 2018 12:36:22 +0100 Subject: [PATCH] people: Don't show duplicate calls Signed-off-by: Michael Tremer --- src/backend/talk.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/backend/talk.py b/src/backend/talk.py index ab07b436..ed0b1210 100644 --- a/src/backend/talk.py +++ b/src/backend/talk.py @@ -50,7 +50,8 @@ class Freeswitch(Object): def get_cdr_by_account(self, account, limit=None): res = self.db.query("SELECT * FROM cdr \ - WHERE caller_id_number = %s OR destination_number = %s \ + WHERE (caller_id_number = %s AND bleg_uuid IS NOT NULL) \ + OR (destination_number = %s AND bleg_uuid IS NULL) \ ORDER BY end_stamp DESC LIMIT %s", account.sip_id, account.sip_id, limit) for row in res: -- 2.47.3