javascript- match partial name empty

hi, in javascript if i match a partial name the result is an empty object. my code is this

 function Users(){};
 var contactStorage = Backendless.Persistence.of(Users);
 var dataQuery = {
 condition: "name = '%pa%'"
 }


 var users = contactStorage.find(dataQuery);
 console.log(users);

i used sync and async method but the result is the same. i have one user with the name “paperino”. the function dont find it. the permission is for all users

Try “pa%”.

dont work “pa%” or “%pa”

Have you tried “like” instead of “=”?

yes, same result :confused:

Use LIKE:

condition: "name LIKE '%pa%'"

ok maiusc LIKE work. i dont know SQL language and this is a not intuitive solution. thanks