0

looking for help

I have 3 different collections in mongo DB.

1.FormSubmissions 2.FormAnswers 3.FormQuestions

I want retrieve data from 3 different collections using mongo DB

I want below response

[
{
        "_id":{"$oid":"5f8d5e164f243b1d0e7c8a85"},
        "LanguageId":{"$oid":"5a6304ffc3c3f119fc0e60c9"},
        "FormId":{"$oid":"5da7f7dfa6334912bc30a3f5"},
        "FormVersionId":{"$oid":"5e4d43c19ee80910ef49a21c"},
        "SubmittedOn":{"$date":"2020-10-19T09:36:22.737Z"},
        "EmployeeId":{"$oid":"5e50b0843bd4c66692ee72c0"},
        "Name":"1212",
        "Type":"Follow-up",
        
},
{
        "_id":{"$oid":"5f8d5c7d4f243b1d0e7c88d7"},
        "LanguageId":{"$oid":"5a6304ffc3c3f119fc0e60c9"},
        "FormId":{"$oid":"5da7f7dfa6334912bc30a3f5"},
        "FormVersionId":{"$oid":"5e4d43c19ee80910ef49a21c"},
        "SubmittedOn":{"$date":"2020-10-19T09:37:22.737Z"},
        "EmployeeId":{"$oid":"5e50afd33bd4c66692ee72b5"},
        "Name":"1111",
        "Type":"NEW",   
}
]

FormSubmissions collection data

[
{
        "_id":{"$oid":"5f8d5e164f243b1d0e7c8a85"},
        "LanguageId":{"$oid":"5a6304ffc3c3f119fc0e60c9"},
        "FormId":{"$oid":"5da7f7dfa6334912bc30a3f5"},
        "FormVersionId":{"$oid":"5e4d43c19ee80910ef49a21c"},
        "SubmittedOn":{"$date":"2020-10-19T09:36:22.737Z"},
        "EmployeeId":{"$oid":"5e50b0843bd4c66692ee72c0"},
},
{
        "_id":{"$oid":"5f8d5c7d4f243b1d0e7c88d7"},
        "LanguageId":{"$oid":"5a6304ffc3c3f119fc0e60c9"},
        "FormId":{"$oid":"5da7f7dfa6334912bc30a3f5"},
        "FormVersionId":{"$oid":"5e4d43c19ee80910ef49a21c"},
        "SubmittedOn":{"$date":"2020-10-19T09:37:22.737Z"},
        "EmployeeId":{"$oid":"5e50afd33bd4c66692ee72b5"},
}
]

FormAnswers collection data

[{
    "_id":{"$oid":"5f8d5e164f243b1d0e7c8c27"},
    "FormId":{"$oid":"5da7f7dfa6334912bc30a3f5"},
    "FormVersionId":{"$oid":"5e4d43c19ee80910ef49a21c"},
    "FormSubmissionId":{"$oid":"5f8d5e164f243b1d0e7c8a85"},
    "LanguageId":{"$oid":"5a6304ffc3c3f119fc0e60c9"},
    "Answers":[
        {
            "_id":{"$oid":"5f8d5e164f243b1d0e7c8a86"},
            "FormQuestionId":{"$oid":"5e4d476a9ee80910ef49a3d4"},
            "ElementType":11,
            "Value":"1212"
        },
        {
            "_id":{"$oid":"5f8d5e164f243b1d0e7c8a87"},
            "FormQuestionId":{"$oid":"5e4d476a9ee80910ef49a3d5"},
            "ElementType":8,
            "Value":"Follow-up"
        }
        ]
},
{
    "_id":{"$oid":"5f8d5e164f243b1d0e7c8c27"},
    "FormId":{"$oid":"5da7f7dfa6334912bc30a3f5"},
    "FormVersionId":{"$oid":"5e4d43c19ee80910ef49a21c"},
    "FormSubmissionId":{"$oid":"5f8d5c7d4f243b1d0e7c88d7"},
    "LanguageId":{"$oid":"5a6304ffc3c3f119fc0e60c9"},
    "Answers":[
        {
            "_id":{"$oid":"5f8d5e164f243b1d0e7c8a86"},
            "FormQuestionId":{"$oid":"5e4d476a9ee80910ef49a3d4"},
            "ElementType":11,
            "Value":"1111"
        },
        {
            "_id":{"$oid":"5f8d5e164f243b1d0e7c8a87"},
            "FormQuestionId":{"$oid":"5e4d476a9ee80910ef49a3d5"},
            "ElementType":8,
            "Value":"NEW"
        }
        ]
}]

FormQuestions collection data

{
    "_id":{"$oid":"5f857076d1e44f6af1adb526"},
    "FormId":{"$oid":"5da7f7dfa6334912bc30a3f5"},
    "FormVersionId":{"$oid":"5e4d43c19ee80910ef49a21c"},
    "LanguageId":{"$oid":"5a6304ffc3c3f119fc0e60c9"},
    "Questions":[
        {
            "_id":{"$oid":"5e4d476a9ee80910ef49a3d4"},
            "ElementType":11,
            "Question":"Name",
            "Index":0,
        },
        {
            "_id":{"$oid":"5e4d476a9ee80910ef49a3d5"},
            "ElementType":8,
            "Question":"Type",
            "Index":1,
        }
    ]
}

Thanks in advance.

looking for quick response.

0 Answers0