From 4a133c1f9d26456831fc97be733eb1716d2edc82 Mon Sep 17 00:00:00 2001 From: Charles-Henri Decultot Date: Sat, 30 Mar 2024 14:15:19 +0100 Subject: [PATCH] fix: Consider _submitted as datetime field --- frappe/model/db_query.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/frappe/model/db_query.py b/frappe/model/db_query.py index 5d97d7cb41..ac100d65da 100644 --- a/frappe/model/db_query.py +++ b/frappe/model/db_query.py @@ -817,12 +817,12 @@ class DatabaseQuery: f.value = date_range fallback = f"'{FallBackDateTimeStr}'" - if f.operator in (">", "<", ">=", "<=") and (f.fieldname in ("creation", "modified")): + if f.operator in (">", "<", ">=", "<=") and (f.fieldname in ("creation", "modified", "_submitted")): # @dokos value = cstr(f.value) fallback = f"'{FallBackDateTimeStr}'" elif f.operator.lower() in ("between") and ( - f.fieldname in ("creation", "modified") + f.fieldname in ("creation", "modified", "_submitted") # @dokos or (df and (df.fieldtype == "Date" or df.fieldtype == "Datetime")) ): escape = False -- GitLab