Rushabh Mehta | d025133 | 2012-02-21 17:26:50 +0530 | [diff] [blame^] | 1 | import webnotes |
2 | |||||
3 | @webnotes.whitelist() | ||||
4 | def 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) |