2 Replies Latest reply on Nov 5, 2013 12:03 PM by Ramesh Reddy

    MongoDB LIKE operator could not return data

    Raymond Ng Newbie

      Hi i have setup a MongoDB resource adaptor and created the schema in the VDB.

       

      Most of the basic query are able to run and return a correct result.

      But the LIKE operator seems not working as expected.

       

      We have a transaction table in MongoDB and we want to query on the transaction_date varchar(100) with LIKE.

      The query we use is just "Select transaction_date from transaction WHERE transaction_date LIKE '%2010%'"

      The server log has no exception but return empty result.