5 Replies Latest reply on Dec 5, 2016 1:24 PM by Ramesh Reddy

    Mongodb - criteria on ObjectId

    Mark Tawk Novice

      I'm using Teiid 9.0.0 with mongodb translator


      I'm adding a criteria over ObjectId value:

      select * from  "testModel_gq"."Customer2" "Customer2"  where "Customer2"."_id" = 'a59e3722dcfd3f5879563cf8'


      I'm getting the following error:

      TEIID30492 Expressions of type OBJECT, CLOB, BLOB, or XML cannot be used in comparison: Customer2."_id" = 'a59e3722dcfd3f5879563cf8'.


      Is there a specific syntax to write the criteria in this case?