Frappe.get_list with filter between two datetime objects

itsdave · January 13, 2021, 6:14pm

Hi,

its possible to filter between two dates like:

data = frappe.get_list("Weather Data",
filters={"weather_time": ["between",  ("2020-10-01", "2020-10-02")})

But is it possible to use get_list or get_all with a filter with datetime, not just date?

When i try something like this:

data = frappe.get_list("Weather Data",
filters={"weather_time": ["between",  ("2020-10-01 09:00:00", "2020-10-02 18:00:00")}

It falls back on to the current day.

I think this is done in

github.com

frappe/frappe/blob/1ac556d30e80499b1adbcb93cda6978cf43c282f/frappe/model/db_query.py#L869


      
          def has_any_user_permission_for_doctype(doctype, user, applicable_for):
          	user_permissions = frappe.permissions.get_user_permissions(user=user)
          	doctype_user_permissions = user_permissions.get(doctype, [])
          
          
	for permission in doctype_user_permissions:
          		if not permission.applicable_for or permission.applicable_for == applicable_for:
          			return True
          
          
	return False
          
          
def get_between_date_filter(value, df=None):
          	'''
          		return the formattted date as per the given example
          		[u'2017-11-01', u'2017-11-03'] => '2017-11-01 00:00:00.000000' AND '2017-11-04 00:00:00.000000'
          	'''
          	from_date = frappe.utils.nowdate()
          	to_date = frappe.utils.nowdate()
          
          
	if value and isinstance(value, (list, tuple)):
          		if len(value) >= 1: from_date = value[0]
          		if len(value) >= 2: to_date = value[1]

but i have to admit that i don`t fully understand what this code is doing.

Can i somehow achieve this, or should i go with with frappe.db.sql?

ranz · June 3, 2023, 4:51am

Any luck on this?