Database
[{"_id":ObjectId("632158ed6fe76c381114ef71"),"MSISDN":"0","tot_out_duration":NumberLong(46),"num_out":NumberLong(2),"tot_in_duration":NumberLong(0),"num_in":NumberLong(0),"CALL_DATE_HOUR":"2022091400"},{"_id":ObjectId("632158ed6fe76c381114ef72"),"MSISDN":"14169364496","tot_out_duration":NumberLong(29),"num_out":NumberLong(1),"tot_in_duration":NumberLong(0),"num_in":NumberLong(0),"CALL_DATE_HOUR":"2022091400"},{"_id":ObjectId("632158ed6fe76c381114ef73"),"MSISDN":"22393750115","tot_out_duration":NumberLong(135),"num_out":NumberLong(2),"tot_in_duration":NumberLong(0),"num_in":NumberLong(0),"CALL_DATE_HOUR":"2022091400"},{"_id":ObjectId("632158ed6fe76c381114ef74"),"MSISDN":"2250797667529","tot_out_duration":NumberLong(0),"num_out":NumberLong(0),"tot_in_duration":NumberLong(2),"num_in":NumberLong(1),"CALL_DATE_HOUR":"2022091400"}]
Query
db.collection.find({"CALL_DATE_HOUR":{$regex:"20220914"}})