Dynamic selection on query report

ERPNext Reports
1

Hi ,

Have anyone ever done dynamic selection on query report.

i have tried to set “fieldtype” : select but it didnt work, only dynamic link is read and goes into my frappe call.

image
image793×395 8.84 KB

Any input is really appreciated.Thanks

2

Hi @naim5441 I guess that you can try something like this:

{
“fieldname”:“group_by”,
“label”: __(“Group By”),
“fieldtype”: “Select”,
“options”: [
“”,
{ “value”: “Item”, “label”: __(“Item”) },
{ “value”: “Customer”, “label”: __(“Customer”) }
],
“default”: “”
},

Or the get_query.

3

Options not option (plural).

4

Oh…wow that’s an good thing to that at least you have tried it. Yes, thanks for sharing the code yes this code is working.