vijaywm/frappe-pivot-table ? reverse-engineered prompt
Reverse engineered prompt
Build me a Frappe app that lets query reports render as interactive pivot tables using PivotTable.js.
I want to be able to open a query report and see the results in a pivot style view where I can drag fields around, change rows and columns, and summarize the data without leaving Frappe. Please wire it up so it works cleanly inside the report page, and make sure the needed JavaScript dependencies are included so PivotTable.js runs properly.
There’s one important issue to handle, the date picker used by jQuery UI can conflict with Frappe’s own date picker, so please make sure forms with Date fields do not break. If you need to check current docs or examples online while doing it, go ahead.
Keep it simple and usable, and make sure the final result feels like a natural part of Frappe query reports.
Are you gonna build this?
make sure you review the code using coderabbit