Add button in report and open modal with selected data from Report

ERPNext
1

I created a query report with button. Showing below:

Screenshot%20from%202022-01-23%2015-59-26
Screenshot%20from%202022-01-23%2015-59-26867×439 23.5 KB

This is the query I used

SELECT
tabSupplier Quotation.supplier_name as Supplier,
tabSupplier Quotation Item.item_name as Item,
tabSupplier Quotation Item.qty as Item_Qty,
tabSupplier Quotation Item.uom as UOM,
tabSupplier Quotation Item.rate as Rate,
tabSupplier Quotation Item.amount as Amount,
CONCAT(‘<button type=“button” class=“btn btn-primary btn-” data=’‘’, tabSupplier Quotation.supplier_name ,‘’’ onClick=‘‘myFunction(this.getAttribute(“data”))’’ >Approve') as Action
FROM tabSupplier Quotation
INNER JOIN
tabSupplier Quotation Item ON tabSupplier Quotation.name = tabSupplier Quotation Item.parent
WHERE tabSupplier Quotation Item.material_request = %(mat_request)s

I don’t know this is the appropriate way or not. Now I need to open a modal with this reports specific data. Is there any way I can do it?

2

Bump

Was there ever a solution found to this?

Thanks