As of April 12th, you must go to Progress SupportLink to create new support cases or to access existing cases. Please, bookmark the SupportLink URL and use the new portal to contact the support team.
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" ??
Best Answer
P
Pranav J
said
over 4 years ago
Hello Megahard Technologies,
In addition to Martin's earlier comment, I would like to tell you that we ONLY support (or recommend) regex for querying only to the beginning of a string and it should be case sensitive. We have placed restrictions on regex queries because they are very computationally expensive given our current platform setup. We do not recommend the full-text regular expression searches as they are very computationally expensive. We only support regex where strings start with the regex.
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,
1 person likes this
m
megahard technologies
said
over 4 years ago
Damien Bell in the link you provided i didnt find any such examples. can you give some more insight to this. do i need to write $regx is it mandatory.
Martin Apostolov
said
over 4 years ago
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:
In addition to Martin's earlier comment, I would like to tell you that we ONLY support (or recommend) regex for querying only to the beginning of a string and it should be case sensitive. We have placed restrictions on regex queries because they are very computationally expensive given our current platform setup. We do not recommend the full-text regular expression searches as they are very computationally expensive. We only support regex where strings start with the regex.
Dan ponce
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" ??
Hello Megahard Technologies,
In addition to Martin's earlier comment, I would like to tell you that we ONLY support (or recommend) regex for querying only to the beginning of a string and it should be case sensitive. We have placed restrictions on regex queries because they are very computationally expensive given our current platform setup. We do not recommend the full-text regular expression searches as they are very computationally expensive. We only support regex where strings start with the regex.
Thanks,
Pranav
Kinvey
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstDamien Bell
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,
1 person likes this
megahard technologies
Damien Bell in the link you provided i didnt find any such examples. can you give some more insight to this. do i need to write $regx is it mandatory.
Martin Apostolov
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:Let me know if this has helped.
Martin Apostolov
Kinvey Support
Pranav J
Hello Megahard Technologies,
In addition to Martin's earlier comment, I would like to tell you that we ONLY support (or recommend) regex for querying only to the beginning of a string and it should be case sensitive. We have placed restrictions on regex queries because they are very computationally expensive given our current platform setup. We do not recommend the full-text regular expression searches as they are very computationally expensive. We only support regex where strings start with the regex.
Thanks,
Pranav
Kinvey
-
How do I use Kinvey in my web app?
-
Is it safe to include keys/secrets in my client-side JavaScript app?
-
Why is the activeUser null even though I am logged in?
-
Login does not work even though credentials are valid.
-
Social login doesn’t work.
-
Appending objects to an Array (HTML5 - JS)
-
New to node.js - need bootstrap to downloadfiles from Kinvey
-
Problem with Aggregation/Grouping
-
Internal Server Error using Twitter Sign Up
-
Data Store
See all 315 topics