Using jongo runcommand for regex

Question

How to use jongo runcommand to execute regex for the below example :

       Command command = jongo.runCommand("{" +
            "find : 'sales', filter : {$and : [{date : {$gte : #}},"
            + "{date : {$lte : #}}, { name: { $regex: /^TEST/ } } ]}  "
            + "}", d1,d2);


    List<MyDate> t = command.throwOnError().field("cursor").as(MyDate.class);

Its throwing me this exception :

   {find : 'sales', filter : {$and : [{date : {$gte : #}},{date : {$lte : #}}, { name: { $regex: /^TEST/ } } ]}  }

 at org.jongo.query.BsonQueryFactory.createQuery(BsonQueryFactory.java:233)
at org.jongo.Command.<init>(Command.java:43)
at org.jongo.Jongo.runCommand(Jongo.java:69)
at com.mtrojahn.boot.JongoTest.start(JongoTest.java:152)
at com.mtrojahn.boot.JongoTest.main(JongoTest.java:50)
    Caused by: com.mongodb.util.JSONParseException: 




  Regards
  Kris

replace regex with `$regex: '/^TEST/'` – s7vr Jan 08 '18 at 14:06 — s7vr, Jan 08 '18 at 14:06

score 0 · Answer 1 · answered Jan 08 '18 at 14:59

0

Found the answer reframed the query with $options with $regex

like this :

   {find : 'sales', filter : {$and : [{date : {$gte : #}},{date : {$lte : #}}, { 'name' : { '$regex' : "^Test" , "$options" : "i"} ]}  }

answered Jan 08 '18 at 14:59

chiku

485
2
8
23

Using jongo runcommand for regex

1 Answers1