Database
[{"_id":"61c1c0efc204bb170e280d2f","title":"Searching Relevant Cases","question":"Your Industry","vendor_id":"61b8324040fb21d80f3e6702","answer_type":"is_radio","optional_answer":false,"sub_question_type":"none","answers":[{"is_rating":false,"is_specific_date":false,"_id":"61c1c0efc204bb170e280d30","answer":"Bank"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c0efc204bb170e280d31","answer":"Tech"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c0efc204bb170e280d32","answer":"Other"}],"view":"list_view","is_active":true,"is_delete":false,"sub_question":[],"draggable_list":[],"__v":0},{"_id":"61c1c142c204bb170e280d45","title":"Searching Relevant Cases","question":"Employee size","vendor_id":"61b8324040fb21d80f3e6702","answer_type":"is_radio","optional_answer":false,"sub_question_type":"none","answers":[{"is_rating":false,"is_specific_date":false,"_id":"61c1c142c204bb170e280d46","answer":"SMB (<100)"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c142c204bb170e280d47","answer":"Mid (100 - 1000)"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c142c204bb170e280d48","answer":"Enterprise (> 1000)"}],"view":"list_view","is_active":true,"is_delete":false,"sub_question":[],"draggable_list":[],"__v":0},{"_id":"61c1c24ac204bb170e280d5e","title":"Dependent","question":"On previous Chosen option","vendor_id":"61b8324040fb21d80f3e6702","answer_type":"is_radio","optional_answer":false,"sub_question_type":"has_parent","sub_question":[{"question_id":"61c1c0efc204bb170e280d2f","_id":"61c1c24ac204bb170e280d5f","answer":"Bank"},{"question_id":"61c1c142c204bb170e280d45","_id":"61c1c24ac204bb170e280d60","answer":"SMB (<100)"}],"answers":[{"is_rating":false,"is_specific_date":false,"_id":"61c1c24ac204bb170e280d61","answer":"answer 1"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c24ac204bb170e280d62","answer":"answer2"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c24ac204bb170e280d63","answer":"answer3"}],"view":"list_view","is_active":true,"is_delete":false,"draggable_list":[],"__v":0},{"_id":"61c1c2d7c204bb170e280d7e","title":"Dependent 1","question":"On previous Chosen option 1","vendor_id":"61b8324040fb21d80f3e6702","answer_type":"is_radio","optional_answer":false,"sub_question_type":"has_parent","sub_question":[{"question_id":"61c1c142c204bb170e280d45","_id":"61c1c2d7c204bb170e280d7f","answer":"Mid (100 - 1000)"},{"question_id":"61c1c0efc204bb170e280d2f","_id":"61c1c2d7c204bb170e280d80","answer":"Tech"}],"answers":[{"is_rating":false,"is_specific_date":false,"_id":"61c1c2d7c204bb170e280d81","answer":"answer 11"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c2d7c204bb170e280d82","answer":"answer 22"},{"is_rating":false,"is_specific_date":false,"_id":"61c1c2d7c204bb170e280d83","answer":"answer 33"}],"view":"list_view","is_active":true,"is_delete":false,"draggable_list":[],"__v":0}]
Query
db.collection.aggregate([{"$addFields":{"userInput":{"obj":{"question_id":"61c1c0efc204bb170e280d2f","answer":"Bank"},"obj1":{"question_id":"61c1c142c204bb170e280d45","answer":"SMB (<100)"}}}},{"$addFields":{"userInput":{"$objectToArray":"$userInput"}}},{"$addFields":{"userInput":{"$map":{"input":"$userInput.v.question_id","as":"q","in":{"$in":["$$q","$sub_question.question_id"]}}}}},{"$match":{$expr:{$eq:[true,{"$allElementsTrue":["$userInput"]}]}}}])