convert _id(ObjectId) to String in aggregation for lookup Spring boot

Question

THIS IS NOT QUESTION

I had a problem for a long time to convert objectId to string in spring boot aggregation and I can't find any useful way to solve it. finally, I figure out and I like to share my way to those who have the same problem; As you know lookup need two sides of lookup the same value, for example, two sides objectId or two sides string if you have objecteId and string in another side you have to make this objectId to string and then write your lookup stage; the stage before lookup should be the project stage with usage of $toString expression like bellow:

ProjectionOperation projectionOperation = Aggregation.project(/*your nedded fields */)
.and(ConvertOperators.ToString.toString("$_id)).as("aggId");

and then you can use lookup easily like below:

Aggregation agg = Aggregation.newAggregation(
                Aggregation.match(
                        Criteria.where("cratorId").is(userId)
                )
                ,
                projectionOperation
                ,
                Aggregation.lookup("post", "aggId", "courseId", "postList"),

my full aggregation is:

ProjectionOperation projectionOperation = Aggregation.project(/*your nedded fields */)
.and(ConvertOperators.ToString.toString("$_id")).as("aggId");

Aggregation agg = Aggregation.newAggregation(
                Aggregation.match(
                        Criteria.where("creatorId").is(userId)
                )
                ,
                projectionOperation
                ,
                Aggregation.lookup("post", "aggId", "courseId", "postList")
);

return this.aggregate(agg, entityClass, Object.class).getMappedResults();

hope it can be useful

Mohamd Ali · Accepted Answer · 2021-09-06 15:31:48Z

1

I was looking into the answer to this question also and I found this solution.

I am using spring-data-mongodb:3.0.0.RELESE.

In your aggregation pipeline

AddFieldsOperation.builder().addField("strId")
                    .withValue(
                        ConvertOperators.ToString.toString("$_id")
                    ).build()

This is the equivalent to

{
    $addFields: {
        strId: {$toString: "$_id"}
    }
}

You can replace strId with any name you want and use it in the next operation.

answered Sep 6, 2021 at 15:31

Mohamd Ali

2,2564 gold badges25 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dada · Accepted Answer · 2021-12-17 09:05:45Z

1

List<Map> getMultiTable(){
    ProjectionOperation projectionOperation = Aggregation.project(/*your nedded fields */)
            .and(ConvertOperators.ToString.toString("$_id")).as("_id")
            .and(ConvertOperators.ToObjectId.toObjectId("$userId")).as("userId");

    Aggregation agg = Aggregation.newAggregation(
            Aggregation.match(
                    Criteria.where("status").is(0)
            ),
            projectionOperation,
            Aggregation.lookup("videoComment", "_id", "videoId", "commentList"),
            Aggregation.lookup("user", "userId", "_id", "userList")
    );

    List<Map> result = mongoTemplate.aggregate(agg, "mediaFile", Map.class).getMappedResults();
    System.out.println(result);
    return result;
}

edited Dec 17, 2021 at 9:05

Dada

6,7657 gold badges28 silver badges48 bronze badges

answered Dec 17, 2021 at 1:39

user17697477

111 bronze badge

1 Comment

user17697477 Over a year ago

the three table with two different converters for different style fields: 1. objectId to string ; 2. ToObjectId.toObjectId

Rjadiya · Accepted Answer · 2024-09-24 12:22:29Z

0

{ $lookup: { from: "groupmembers", let: { cID: "$cID" }, pipeline: [ { $match: { $expr: { $and: [ { $eq: ["$groupId", "$$cID"] }, { $eq: ["$status", "ACTIVE"] }, // { $eq: ["$member.userId", "[email protected]"] }, { $eq: ["$organizationId", 260] } ] } } },

want equlent code for this

answered Sep 24, 2024 at 12:22

Rjadiya

13 bronze badges

1 Comment

Abra Over a year ago

Use markdown to format your JSON. Also, did you actually mean equlent? Shouldn't that be equivalent ?

Collectives™ on Stack Overflow

convert _id(ObjectId) to String in aggregation for lookup Spring boot

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related