Version 6.x.x Source

Class DatabaseQuery

Inherits from __builtin__.object

__init__ (self, doctype)

No docs


add_comment_count (self, result)

No docs


add_limit (self)

No docs


add_user_permissions (self, user_permissions, user_permission_doctypes=None)

No docs


append_table (self, table_name)

No docs


build_and_run (self)

No docs


build_conditions (self)

No docs


build_filter_conditions (self, filters, conditions)

build conditions from user filters


build_match_conditions (self, as_condition=True)

add match conditions if applicable


check_sort_by_table (self, order_by)

No docs


execute (self, query=None, fields=None, filters=None, or_filters=None, docstatus=None, group_by=None, order_by=None, limit_start=False, limit_page_length=None, as_list=False, with_childnames=False, debug=False, ignore_permissions=False, user=None, with_comment_count=False)

No docs


extract_tables (self)

extract tables from fields


get_filter (self, f)

Returns a _dict like

{ "doctype": "DocType", "fieldname": "fieldname", "operator": "=", "value": "value" }


get_permission_query_conditions (self)

No docs


get_share_condition (self)

No docs


make_filter_tuple (self, key, value)

No docs


parse_args (self)

Convert fields and filters from strings to list, dicts


prepare_args (self)

No docs


prepare_filter_condition (self, f)

Returns a filter condition in the format:

ifnull(tabDocType.fieldname, fallback) operator "value"


remove_user_tags (self)

Removes optional columns like _user_tags, _comments etc. if not in table


run_custom_query (self, query)

No docs


set_order_by (self, args)

No docs