Query report with Like keyword

ERPNext Reports
1

How use like keyword in query report, I am trying like , but not work.

SELECT
	tpe.name,
	tpe.posting_date ,
	tpe.status ,
	tpe.party,
	tpe.mode_of_payment,
	tpe.paid_amount,
	tpe.cost_center ,
	tpe.remarks  
from
	`tabPayment Entry` tpe
WHERE tpe.name like %(name)s
2

What is an issue you’re facing because query looks perfect. Please describe your issue in brief.

3

i tried this too on erpnext ui and ig it only work on the server script where you edit stranding report etc … , you can use python script for filters and change the report to script report with frappe.sql.db