blob: 99f3085e2a913c3d8798ba35699b7f5325f19033 [file] [log] [blame]
Rushabh Mehtad0251332012-02-21 17:26:50 +05301import webnotes
2
3@webnotes.whitelist()
4def get_report_list(arg=None):
5 """return list of reports for the given module module"""
6 webnotes.response['values'] = webnotes.conn.sql("""select
7 distinct criteria_name, doc_type, parent_doc_type
8 from `tabSearch Criteria`
9 where module='%(module)s'
10 and docstatus in (0, NULL)
11 order by criteria_name
12 limit %(limit_start)s, %(limit_page_length)s""" % webnotes.form_dict, as_dict=True)