From d92ed91063c9eca30b16a23f680e526df49dbbe8 Mon Sep 17 00:00:00 2001 From: Agnibho Mondal Date: Wed, 22 Jan 2025 02:33:13 +0530 Subject: [PATCH] Report order by date --- vaccination.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/vaccination.py b/vaccination.py index a219baf..058fb17 100644 --- a/vaccination.py +++ b/vaccination.py @@ -77,7 +77,7 @@ def list_by_inventory(cursor, iid): def list_by_date(cursor, fromDate, toDate): try: - result=cursor.execute("SELECT * FROM vaccination LEFT JOIN inventory ON vaccination.iid=inventory.iid LEFT JOIN patients ON vaccination.pid=patients.pid WHERE date BETWEEN ? AND ? ORDER BY vaccination.iid", (fromDate, toDate)) + result=cursor.execute("SELECT * FROM vaccination LEFT JOIN inventory ON vaccination.iid=inventory.iid LEFT JOIN patients ON vaccination.pid=patients.pid WHERE vaccination.date BETWEEN ? AND ? ORDER BY vaccination.date, vaccination.iid", (fromDate, toDate)) if(cursor.rowcount==0): return (False, "Record not found.") else: -- 2.39.5