You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

The extended JSON data type REGULAR_EXPRESSION is not supported

Received Response
14
Views
3
Comments

Summary:

I have an application that uses the MongoDB API for Autonomous JSON Database. I was attempting to do a case-insensitive find query on a collection using regex but came across the error The extended JSON data type REGULAR_EXPRESSION is not supported. After doing some research, I found out that regex fields aren't supported by the MongoDB API. In this case, how would I perform a case-insensitive search on this data? For context, the field I am trying to search in is an array, like so:

variants: [ "Hello", "hi", "hey" ]

I just need to do a search to find if a word exists in this array, without taking case into account.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!