How search by integer type column using morphia, mongodb, play framework

[Manoj Prasanna Handapangoda]

HI I have following data items in mongo db 

{ "id" : 950,  "name" : "Name 1" },

{ "id" : 951,  "name" : "name 2" }

I have tried mapping id as both Integer and String.

and I used morphia + play to connect mongodb and used DAO of morphia.

I need to do a search by id like (in sql where id like '95%' ) and get the result as list.

List<Person> pList =  ds.createQuery(Person.class).field("id").startsWith("95").asList();  // this is not working 

Any ideas how get this done ??

[green]

what about ds.createQuery(Person.class).filter("id >", 950).filter("id <", 960).asList() ?

--
You received this message because you are subscribed to the Google Groups "play-framework" group.
To unsubscribe from this group and stop receiving emails from it, send an email to play-framewor...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Justin Lee]

startsWith() is a text operation.  It can't be used on numeric values.  You'll have to use greaterThan/lessThan comparisons.

[Manoj Prasanna Handapangoda]

Great, the used with <,> worked for me.

Thanks.