Mongo filter collections

[zhenyabodukhin]

Hey,

Is it possible to filter collections in Mongo using $elemMatch instead of $match?
For example:
order: {
"tasks": [
{
"name" : "first",
"priority: 5
},
{
"name" : "second",
"priority": 4
}
]
};

The filter will be: "tasks.name":"first" and "tasks.priority":4.
And this filter return this order, because "first" matches first element of array and "4" matches second element of array, but i needed to match filter for element of array, not for whole array.

[torshid]

For the filter 'tasks.name':'first', the generated expression would be:

{ "$expr" : { "$eq" : ["$tasks.name", "first"]}}

Which will not work since tasks is a collection as you mentionned. I am not sure how to use $elemMatch here, do you have an idea?

[torshid]

It may be possible to use https://www.mongodb.com/docs/manual/reference/operator/aggregation/getField/#query-a-field-in-a-sub-document

[zhenyabodukhin]

Hi! we have fixed this using $anyElementTrue. Here files which we patched.
TransformerUtils.txt
JsonNodeHelperImpl.txt
NotInOperationJsonNodeProcessor.txt
LikeOperationJsonNodeProcessor.txt
InOperationJsonNodeProcessor.txt

Works great. For example: tasks.name:'value' and tasks.technicalName:'value' will find documents where at least one element of tasks matches this filter.
Yes, maybe this code need refactoring, but i have not much time to fix this problem :)
And there is problem with search by date fields. This converter will fix this problem.
Norlmalize method will be :
if (field.getType().equals(LocalDateTime.class) || field.getType().equals(ZonedDateTime.class) || field.getType().equals(LocalDate.class)) {
return new ClassInfo(false, CustomDate.class);
}
ClassInfo its my class which contains info is array field or not, maybe you find better way.
DateConverter.txt