Hi! For example I have the names "Alan" and "Alen" in my collection. There is a query for the case where I search all the names starting with "al" ??

Hi Dan,

Doing this via the API console is pretty simple you can simply request: /appdata/kid_Te5Spq4_zC/firstNames/?query={"firstName":{"$regex":"^Jo"} }

Which would match "Joe" or "John" but not "john" or "joe" (it's case sensitive / anchored to the beginning of the string).

Doing this in one of the javascript libraries means that you could use the "contains" query:  which is outlined over here:  http://devcenter.kinvey.com/html5/guides/datastore#operators

Please let me know if you need anymore help with this.

Thanks,

Hi,

The REST API request is indeed /appdata/KID-HERE/COLLECTION-NAME/?query={"firstName":{"$regex":"^Jo"} }.

If you are using the Kinvey JavaScript SDK, you would use matches operator like this:

      const collection = "Authors";
      const field = "firstName";
      const regex = "^Jo";

      const query = new Kinvey.Query();
      query.matches(field, regex);

      const bookStore = Kinvey.DataStore.collection(collection, Kinvey.DataStoreType.Network);
      bookStore.find(query)
      .subscribe(function onNext(data) {
        console.log(data);
      }, function onError(error) {
        console.log("err", err);
      }, function onCompleted() {
        console.log("done");
      });

Let me know if this has helped.

Martin Apostolov

Kinvey Support