AggregationUpdate : supported operations `set`, `unset` ok, but what about `push` ?

[boly38]

Hi 👋,

I'm relying on AggregationUpdate with ConditionalOperators and switchCases in order to update multiple documents in one shot.

This work well for set, unset, conditional set..
cf. doc or my example below:

AggregationUpdate update = AggregationUpdate.update()
                .set("updateTs").toValue(updateTs)
                .set("result").toValue(
		  ConditionalOperators.switchCases(
                    CaseOperator.when(In.arrayOf("$myArray.state").containsValue("VALA")).then("VALA"),
                    CaseOperator.when(In.arrayOf("$myArray.state").containsValue("VALB")).then("VALB")
		  ).defaultTo("UNKNOWN")
                )
                .unset("updateRequested");

UpdateResult result = mongoTemplate.updateMulti(query, update, ResultDocument.class);

Now, I want to add a push operation to my existing update,

ideally something like that:

// .push("myArray", newValueToPush);// no
// .set("myArray").toValueOf(Aggregation.group("myArray").push(newValueToPush));// unexpected usage

but I'm unable to find a way to do that
(push is available in common update, or else in newAggregation as for example group("myArray").push(..)).

Could you explain me if this is possible and then how to do that ?
or else mark this as improvement (if allowed by mongo for this kind of aggregation) ?

In advance thanks

[christophstrobl]

Thanks for getting in touch, but it feels like this is a question that would be better suited to Stack Overflow. We prefer to use GitHub issues only for bugs and enhancements. Feel free to update this issue with a link to the re-posted question (so that other people can find it) or add some more details if you feel this is a genuine bug.

$set with $concatArrays might be what you're looking for.

[boly38]

thanks I posted this on SO

[boly38]

@christophstrobl using $concatArrays is the way 🙏 🙏

TL;DR; .set("myArray").toValue(ConcatArrays.arrayOf("myArray").concat(ConcatArrays.arrayOf(List.of("a","b")))); // push like

In addition and for exotic type (ex OffsetDateTime array entry), I had to use converter to build values because mongo client config related converters dont apply at this level of use (I imagine that this is expected).