I need to delete my duplicate documents in database. How can i delete those documents.
Share some examples of what the data looks like.
{
"_id": {
"$oid": "5fbff503a4d80a0008052b64"
},
"meta": {
"origin_port": "INNSA",
"destination_port": "DEHAM",
"load_type": "20GP",
"start_date": {
"$date": {
"$numberLong": "1604188800000"
}
},
"leg_code": "l4_fcl",
"id": "8188",
"weight_upto": null
},
"data": {
"schedule": {
"url": "",
"data": []
},
"analytics": {
"graph": {
"url": null
}
},
"ltl_load_details": null,
"is_special": false,
"special_meta": [],
"price_id": null,
"sailing_date": null,
"charges": [
{
"charge_id": "40001",
"charge_name": "Destination Terminal Handling charges",
"charge_description": "",
"charge_basis": "per equipment",
"per_unit_rate": 130,
"total_units": 1,
"charge_cost": 130,
"charge_currency": "EUR",
"minimum_charge_cost": "NA",
"is_minimum": false,
"container_type": "20GP",
"global_charge_id": "FBDC2130",
"customer_currency_cost": 130,
"created_at": "2020-11-26T18:33:39.037Z",
"updated_at": "2020-11-26T18:33:39.037Z",
"leg_currency_cost": 130,
"charge_source": "DB",
"charge_type": "FIXED",
"slab_type": "INCREMENTAL",
"slab_rate": null,
"slab": "NULL",
"id": {
"$oid": "5fbff503a4d80a0008052b5d"
}
},
{
"charge_id": "40060",
"charge_name": "Manifest Fee",
"charge_description": "",
"charge_basis": "per equipment",
"per_unit_rate": 120,
"total_units": 1,
"charge_cost": 120,
"charge_currency": "EUR",
"minimum_charge_cost": "NA",
"is_minimum": false,
"container_type": "20GP",
"global_charge_id": "",
"customer_currency_cost": 120,
"created_at": "2020-11-26T18:33:39.037Z",
"updated_at": "2020-11-26T18:33:39.037Z",
"leg_currency_cost": 120,
"charge_source": "DB",
"charge_type": "FIXED",
"slab_type": "INCREMENTAL",
"slab_rate": null,
"slab": "NULL",
"id": {
"$oid": "5fbff503a4d80a0008052b5e"
}
},
{
"charge_id": "40061",
"charge_name": "Container Facilitation Charges",
"charge_description": "",
"charge_basis": "per container",
"per_unit_rate": 80,
"total_units": 1,
"charge_cost": 80,
"charge_currency": "EUR",
"minimum_charge_cost": "NA",
"is_minimum": false,
"container_type": "20GP",
"global_charge_id": "",
"customer_currency_cost": 80,
"created_at": "2020-11-26T18:33:39.037Z",
"updated_at": "2020-11-26T18:33:39.037Z",
"leg_currency_cost": 80,
"charge_source": "DB",
"charge_type": "FIXED",
"slab_type": "INCREMENTAL",
"slab_rate": null,
"slab": "NULL",
"id": {
"$oid": "5fbff503a4d80a0008052b5f"
}
},
{
"charge_id": "40062",
"charge_name": "Off Dock Charges",
"charge_description": "",
"charge_basis": "per container",
"per_unit_rate": 90,
"total_units": 1,
"charge_cost": 90,
"charge_currency": "EUR",
"minimum_charge_cost": "NA",
"is_minimum": false,
"container_type": "20GP",
"global_charge_id": "",
"customer_currency_cost": 90,
"created_at": "2020-11-26T18:33:39.037Z",
"updated_at": "2020-11-26T18:33:39.037Z",
"leg_currency_cost": 90,
"charge_source": "DB",
"charge_type": "FIXED",
"slab_type": "INCREMENTAL",
"slab_rate": null,
"slab": "NULL",
"id": {
"$oid": "5fbff503a4d80a0008052b60"
}
},
{
"charge_id": "40110",
"charge_name": "Dray",
"charge_description": null,
"charge_basis": "per container",
"per_unit_rate": 2,
"total_units": 1,
"charge_cost": 2,
"charge_currency": "EUR",
"minimum_charge_cost": "NA",
"is_minimum": false,
"container_type": "20GP",
"global_charge_id": null,
"customer_currency_cost": 2,
"created_at": "2020-11-26T18:33:39.037Z",
"updated_at": "2020-11-26T18:33:39.037Z",
"leg_currency_cost": 2,
"charge_source": "DB",
"charge_type": "FIXED",
"slab_type": "INCREMENTAL",
"slab_rate": null,
"slab": "NULL",
"id": {
"$oid": "5fbff503a4d80a0008052b61"
}
},
{
"charge_id": "40124",
"charge_name": "container movement doc stuffing",
"charge_description": null,
"charge_basis": "per equipment",
"per_unit_rate": 10,
"total_units": 1,
"charge_cost": 10,
"charge_currency": "EUR",
"minimum_charge_cost": "NA",
"is_minimum": false,
"container_type": "20GP",
"global_charge_id": null,
"customer_currency_cost": 10,
"created_at": "2020-11-26T18:33:39.037Z",
"updated_at": "2020-11-26T18:33:39.037Z",
"leg_currency_cost": 10,
"charge_source": "DB",
"charge_type": "FIXED",
"slab_type": "INCREMENTAL",
"slab_rate": null,
"slab": "NULL",
"id": {
"$oid": "5fbff503a4d80a0008052b62"
}
},
{
"charge_id": "40135",
"charge_name": "Charge",
"charge_description": null,
"charge_basis": "per equipment",
"per_unit_rate": 70,
"total_units": 1,
"charge_cost": 70,
"charge_currency": "EUR",
"minimum_charge_cost": "NA",
"is_minimum": false,
"container_type": "20GP",
"global_charge_id": null,
"customer_currency_cost": 70,
"created_at": "2020-11-26T18:33:39.037Z",
"updated_at": "2020-11-26T18:33:39.037Z",
"leg_currency_cost": 70,
"charge_source": "DB",
"charge_type": "FIXED",
"slab_type": "INCREMENTAL",
"slab_rate": null,
"slab": "NULL",
"id": {
"$oid": "5fbff503a4d80a0008052b63"
}
}
],
"manual": 0,
"airline_code": null,
"airline": null,
"slab_currency": null,
"slab": null,
"rate_type": "msr_rate",
"alternate_object": null,
"leg_name": "Destination Charges",
"leg_code": "l4_fcl",
"vendor_id": "109",
"agent_id": "",
"sub_vendor_id": "2",
"contract_number": "",
"remarks": "",
"inclusions": "",
"expiry": {
"$date": {
"$numberLong": "1617148800000"
}
},
"other_charges": "",
"if_applicable_charges": "",
"load_stat": null,
"global_leg_id": "l4",
"leg_total_cost": 0,
"leg_total_currency": null,
"leg_currency_cost": 0,
"leg_currency": null,
"is_master": 0,
"batchcode": "0DEt0r3Xzrb2SSw50FGhJ36aG5h8RLY95sdhntWr",
"vendor": {
"vendor_name": "FWDBFWDB"
},
"sub_vendor": {
"sv_id": 2,
"sub_vendor_name": "CMA CGM",
"carrier_code": "CMDU",
"logo": "https://s3.amazonaws.com/storage-dir-fb-test%2Fsub_vendors%2Flogo%2Fsv-17a3304d88fc/sv-17a3304d88fc.PNG"
},
"agent": null,
"card_id": 0,
"tags": [
{
"tag_name": null,
"tag_ribbon_url": null,
"show_tag": false,
"tag_type": "master"
},
{
"tag_name": "Special Rate",
"tag_ribbon_url": "",
"show_tag": false,
"tag_type": "special"
},
{
"tag_name": "Rollable",
"tag_ribbon_url": "",
"show_tag": false,
"tag_type": "rollable"
}
],
"promotions": [],
"terms_and_condition": {
"url": null
},
"demurrage": null,
"detention": null,
"via_pol": "",
"haulage_available": false,
"origin_haulage": "",
"destination_haulage": "",
"value_of_good": {
"cost": 0,
"currency": ""
},
"rollable_available": false,
"penalty_details": null,
"via_pod": "",
"cfs_stuffing": "F",
"rate_origin": "",
"service_type": "",
"cargo_type": "FAK",
"cargo_type_data": {
"name": "FAK",
"code": "FAK"
},
"commodity": "",
"commodity_data": []
},
"__v": 0
}