Case insensitive query with Java driver

Working with Data Drivers
1

How to search case insensitive with java driver?

I created an index:

db.user.createIndex({ userName: 1 },{ collation: {locale: 'en', strength: 2}});

I can search successfully using shell:

db.names.find( { userName: "betsy" } ).collation( { locale: 'en' } )

This returns expected 1 record

I cannot find similar method collation on the java driver api.

Thanks

2

com.mongodb.client.MongoCollection’s find() method returns a FindIterable; it has a collation​() method where you can specify the collation for the find method returned cursor object.

db.collection.find() returns a cursor, and the cursor object has the collation() method and corresponds to the above mentioned Java method .

3

Thanks for the help. Getting expected results now using code below.

val collation = Collation.builder()
	.locale("en")
	.collationStrength(CollationStrength.SECONDARY)
	.build()

val list = collection.find(and(eq("familyId", item.familyId), eq("userName", item.userName)))
	.collation(collation)
	.toList()