From 2e5b3b87a6ba2bf3d48ba19f0e54f10fa4187288 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Thu, 12 Oct 2023 02:25:39 +0300
Subject: CaseAttribute: Bug: Fix query - include time_stamp.

---
 gn3/case_attributes.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'gn3')

diff --git a/gn3/case_attributes.py b/gn3/case_attributes.py
index 3e3079b..250478f 100644
--- a/gn3/case_attributes.py
+++ b/gn3/case_attributes.py
@@ -267,7 +267,7 @@ def __save_diff__(conn: Connection, diff_data: dict, status: EditStatus) -> int:
     with conn.cursor() as cursor:
         cursor.execute(
             "INSERT INTO "
-            "caseattributes_audit(id, status, editor, json_diff_data) "
+            "caseattributes_audit(id, status, editor, json_diff_data, time_stamp) "
             "VALUES(%(db_id)s, %(status)s, %(editor)s, %(diff)s, %(ts)s) "
             "ON DUPLICATE KEY UPDATE status=%(status)s",
             {
-- 
cgit 1.4.1