Using "LIKE" operator in Rest API with "%" symbol at the end

I’m using “%” on my “LIKE” filters but seems it only works if it placed in the end. for example:


it will return some results…

But this one:


it will return empty result

Why it happens? Am I using it wrong?

In SQL and Frappe queries, using % at the beginning of the search pattern is not always supported, and it might not work as expected. The % wildcard is typically used for matching at the end or both ends of the pattern.

If you want to perform a substring match for records that contain “2023-00002” anywhere in the name, you can use % at both ends

you mean something like this:


because it also not working. nothing return