Wed, 10 Apr 2019 11:25 am
"Cari surat yang jatuh temponya hari ini atau sudah lewat"

QUERY:
db.sms.find({"label": {$elemMatch: {"reminder_date": {$lte: "2019-04-15"}}}})

DATA:
{ 
    "_id" : ObjectId("5cac618637abe23de5fbc3d2"), 
    "status" : "active", 
    "time_stamp" : "2019-04-09 17:10:30.5354549 +0800 +08 m=+85715.805921800", 
    "asal" : "KEPALA SEKSI PELAYANAN", 
    "tanggal" : "2019-04-09", 
    "hal" : "Penerusan Permohonan WP NE a.n. MARYATI", 
    "lampiran" : "", 
    "files" : [
        {
            "created_from" : "::1", 
            "nama_file" : "7dzcf_development02.sms.json", 
            "action" : "insert", 
            "by_kodejabatan" : "1-09-07", 
            "by_name" : "HERUDIN", 
            "waktu" : "2019-04-10 10:22:03.3732216 +0800 +08 m=+3015.626155600"
        }, 
        {
            "action" : "insert", 
            "by_kodejabatan" : "1-09-07", 
            "by_name" : "HERUDIN", 
            "waktu" : "2019-04-10 10:39:44.2194074 +0800 +08 m=+4076.499406400", 
            "created_from" : "::1", 
            "nama_file" : "P4v2H_development02.skl.json"
        }
    ], 
    "nomor" : "ND-42NE/WPJ.29/KP.0603/2019", 
    "sifat" : "", 
    "doc_series" : "N3523yDNA", 
    "tag" : {
        "1-09-07" : {
            "createdby_ip" : "10.29.4.99", 
            "to_nama" : "HERUDIN", 
            "to_tanggalditerima" : "2019-04-09", 
            "createdby_time" : "2019-04-09 17:10:30.5354549 +0800 +08 m=+85715.805921800", 
            "to_nomoragenda" : NumberInt(537), 
            "createdby_kodejabatan" : "1-09-07", 
            "createdby_namajabatan" : "Kepala Seksi Waskon I", 
            "createdby_nama" : "HERUDIN", 
            "createdby_iduser" : "iqbyL8aMi", 
            "to_iduser" : "iqbyL8aMi", 
            "to_kodejabatan" : "1-09-07", 
            "to_namajabatan" : "Kepala Seksi Waskon I"
        }, 
        "1-09-07-05" : {
            "createdby_namajabatan" : "Kepala Seksi Waskon I", 
            "createdby_iduser" : "iqbyL8aMi", 
            "to_namajabatan" : "Pelaksana Seksi Waskon I", 
            "createdby_time" : "2019-04-09 17:44:27.0156317 +0800 +08 m=+87752.291242100", 
            "createdby_ip" : "10.29.4.99", 
            "to_iduser" : "KkQDkifgA", 
            "to_nama" : "TIFFANY URWATUL WUTSQO", 
            "to_kodejabatan" : "1-09-07-05", 
            "to_disposisi" : "[\"Selesaikan\"]", 
            "to_catatan" : "Proses sesuai ketentuan", 
            "createdby_kodejabatan" : "1-09-07", 
            "createdby_nama" : "HERUDIN"
        }
    }, 
    "history" : [
        {
            "history_action" : "input", 
            "createdby_kodejabatan" : "1-09-07", 
            "createdby_name" : "HERUDIN", 
            "createdby_time" : "2019-04-09 17:10:30.5354549 +0800 +08 m=+85715.805921800", 
            "createdby_ip" : "10.29.4.99", 
            "data" : {
                "hal" : "Penerusan Permohonan WP NE a.n. MARYATI", 
                "asal" : "KEPALA SEKSI PELAYANAN", 
                "nomor" : "ND-42NE/WPJ.29/KP.0603/2019", 
                "tanggal" : "09/04/2019"
            }
        }
    ], 
    "label" : [
        {
            "by_kodejabatan" : "1-09-07", 
            "by_name" : "HERUDIN", 
            "waktu" : "2019-04-10 09:37:02.9090697 +0800 +08 m=+315.093107700", 
            "created_from" : "::1", 
            "kode_label" : "label_33", 
            "reminder_date" : "2019-04-15", 
            "action" : "insert"
        }
    ], 
    "link" : [
        {
            "waktu" : "2019-04-10 10:26:18.9225707 +0800 +08 m=+3271.182024400", 
            "created_from" : "::1", 
            "doc_series_added" : "vwfemDT0F", 
            "sms_or_skl_added" : "sms", 
            "action" : "insert", 
            "by_kodejabatan" : "1-09-07", 
            "by_name" : "HERUDIN"
        }, 
        {
            "waktu" : "2019-04-10 10:39:12.102827 +0800 +08 m=+4044.382006600", 
            "created_from" : "::1", 
            "doc_series_added" : "8E6kMGVFL", 
            "sms_or_skl_added" : "sms", 
            "action" : "insert", 
            "by_kodejabatan" : "1-09-07", 
            "by_name" : "HERUDIN"
        }
    ]
}

#mongodb #suratmasuk
147
Additional Info: