Edit Question - KnowledgeHub

Title Body

Please go through this question of mine: MongoDB $group and explicit group formation with computed column But this time, I need to compare strings, not numbers.The CASE query must have a LIKE : CASE WHEN source LIKE '%Web%' THEN 'Web' I then need to group by source. How to write this in Mongo? I am trying the following but not sure if $regex is supported inside $cond . By the way, is there a list of valid operators inside $cond somewhere? Looks like $cond isn't very fond of me :) db.Twitter.aggregate( { $project: { "_id":0, "Source": { $cond: [ { $regex:['$source','/.* Android.*/'] }, 'Android', { $cond: [ { $eq: ['$source', 'web'] }, 'Web', 'Others' ] } ] } } } ); There're many other values that I need to write in there, doing a deeper nesting. This is just an example with just 'Android' and 'Web' for the sake of brevity. I have tried both with $eq and $regex . Using $regex gives error of invalid operator whereas using $eq doesn't understand the regex expression and puts everything under 'Others'. If this is possible with regex, kindly let me know how to write it for case-insensitive match. Thanks for any help :-)

Tags (comma-separated) Cancel