OData substringof or thw 'Like' in sql

Radzen Studio Angular
1

Hi,

was trying to do a OData filter, using substringof, to replicate a Like '1,% 4,%' of SQL, but itt says "An unknown function with name 'substringof' was found." . Is there any way to do this filter without using a ServerMethod.

Thanks

2

You can use contains:
https://www.odata.org/getting-started/basic-tutorial/

substringof was part of OData v3 and no longer available in OData v4