@MongoId(targetType = STRING) forces _id : {…} query documents to String

[blueiceprj]

Spring data version: 3.3.0-M2

I use "_id" field as a string type and I want to use this field with $in operator like this.

@Override
	public List<T> findAllById(Iterable<String> ids)
	{
		final Query query = new Query();
		query.addCriteria(Criteria.where("_id").in(ids));
		return template.find(query, type);
	}

But console output is like this:

find using query: { "_id" : "{\"$in\" : [\"5b8bedceb1e0bfc07b008828\", \"5b8bedceb1e0bfc07b008829\", \"5b8bedceb1e0bfc07b00882a\"]}"} fields: Document{{}} for class:

But $in operator running properly with other fields.

public List<RolePrivilege> findPermissions(String tenantId, List<String> roles)
	{
		final Query query = new Query(Criteria.where("tenantId").is(tenantId));
		if (CollectionUtil.isNotEmpty(roles))
		{
			query.addCriteria(Criteria.where("roleId").in(roles));
		}
		query.addCriteria(notDeletedItemsCriteria);
		return template.find(query, RolePrivilege.class);
	}

find using query: { "tenantId" : "5b8bedceb1e0bfc07b00882f", "roleId" : { "$in" : ["5b8bedceb1e0bfc07b008828", "5b8bedceb1e0bfc07b008829", "5b8bedceb1e0bfc07b00882a", "5b8bedceb1e0bfc07b00882e", "5c6f3b1f1c36570fc572765c", "5eb8b5f540e3006cfa56de26"]}, "deleted" : false} fields: Document{{}} for class

On execution time the criteria api adding backslash "\" to the query and don't return any data.

[blueiceprj]

Because of this problem I had to change $in operator to $or.

[blueiceprj]

Same result "is" operator when use with Match operator.

String assignmentId = ....
final Criteria assignmentCriteria = Criteria.where("_id").is(assignmentId);
Aggregation.match(assignmentCriteria)

[{ "$match" : { "_id" : { "$oid" : "5f4e7f18fa69b26c3ba619f8"},......]

[mp911de]

Thanks for the details. Spring Data MongoDB performs an implicit type conversion to ObjectId when using identifiers that represent a valid ObjectId string. Check out the two variants:

@Document
static class Foo{
	 String id;
}

Query query = new Query();
query.addCriteria(Criteria.where("_id").in(Arrays.asList("5b8bedceb1e0bfc07b008828", "5b8bedceb1e0bfc07b008829", "5b8bedceb1e0bfc07b00882a")));

renders

{"_id": {"$in": [ObjectId("5b8bedceb1e0bfc07b008828"), ObjectId("5b8bedceb1e0bfc07b008829"), ObjectId("5b8bedceb1e0bfc07b00882a")]}}

you can hint Spring Data to use a specific Id field type with @MongoId (defaults to retain the actual type):

@Document
static class Foo{
	 @MongoId
	 String id;
}

Query query = new Query();
query.addCriteria(Criteria.where("_id").in(Arrays.asList("5b8bedceb1e0bfc07b008828", "5b8bedceb1e0bfc07b008829", "5b8bedceb1e0bfc07b00882a")));

renders

{"_id": {"$in": ["5b8bedceb1e0bfc07b008828", "5b8bedceb1e0bfc07b008829", "5b8bedceb1e0bfc07b00882a"]}}

Note that the Mongo query is rendered using Mongo shell settings.

[blueiceprj]

Thank you for your reply. Id description like here on my side:

	@MongoId(targetType = FieldType.STRING)
	private String id;

[blueiceprj]

And sometimes I use custom data object (DTO) to mapping. Its not a mongodb document object and it has id field. But on custom object as same problem.

[mp911de]

Thanks a lot. What happens is that the $in clause is being converted to a String. It should been preserved as Document. You can see this through the escaped quotes {\"$in\" : [\"5b8bedceb1e0bfc07b008828\", \"5b8bedceb1e0bfc07b008829\".