How to use a date range with DB API

clarkej · June 7, 2020, 10:32pm

Frappe filter expressions support IN rather than OR

frappe/frappe/blob/develop/frappe/database/database.py#L352


      
          		except Exception as e:
          			frappe.errprint(f"error in query explain: {e}")
          		else:
          			frappe.errprint(json.dumps(self.fetch_as_dict(), indent=1))
          			frappe.errprint("--- query explain end ---")
          
          
	def sql_list(self, query, values=(), debug=False, **kwargs):
          		"""Return data as list of single elements (first column).
          
          
		Example:
          
          
		        # doctypes = ["DocType", "DocField", "User", ...]
          		        doctypes = frappe.db.sql_list("select name from DocType")
          		"""
          		return self.sql(query, values, **kwargs, debug=debug, pluck=True)
          
          
	def sql_ddl(self, query, debug=False):
          		"""Commit and execute a query. DDL (Data Definition Language) queries that alter schema
          		autocommit in MariaDB."""
          		self.commit()
          		self.sql(query, debug=debug)

IN is more compact than a compound expression of OR clauses.

Here’s an IN filter expression example How to filter Tasks on both Open OR Overdue Tasks - #7 by clarkej