run_query_report
Execute Frappe query reports with custom filters to extract specific data from Frappe Framework sites using string-based filter syntax.
Instructions
Execute a Frappe query report with filters.
Args:
report_name: Name of the report to run
filters: Filter string (optional). Uses custom syntax to bypass MCP validation issues.
Filter Syntax: Use the same string-based syntax as count_documents and list_documents.
Examples: "status:Open", "date:>=:2025-01-01", "status:in:Open|Working"
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filters | No | ||
| report_name | Yes |
Input Schema (JSON Schema)
{
"properties": {
"filters": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Filters"
},
"report_name": {
"title": "Report Name",
"type": "string"
}
},
"required": [
"report_name"
],
"title": "run_query_reportArguments",
"type": "object"
}