Монгоэкспорт JSON Field не может получить правильный результат
Мои данные: первая строка:
{"_id":{"$oid":"5965c0dc8279d5fd342435fc"},"supplierId":1411,"supplierSendQty":1,"receiveQty":1,"modifiedOn":{"$date":"2017-07-12T15:34:03.928Z"},"modifiedBy":"wangyaqing","createdOn":{"$date":"2017-07-12T14:25:32.844Z"},"createdBy":"liufei","qcVersion":"","factoryId":"","putAwayBy":"","putAwayOn":{"$date":"2017-07-12T15:34:03.928Z"},"putAwayCarNo":"1002","sortNum":14,"shelfSortOn":{"$date":"2017-07-12T14:37:19.000Z"},"shelfSortBy":"liufei","shelfSortBatch":"liufei_1499841438","isAddStock":"true","zoneSortBoxNo":"1002","zoneSortedSortQty":1,"zoneSortedOn":{"$date":"2017-07-12T14:25:55.000Z"},"zoneSortedBy":"liufei","goodCodeStr":"sh,CO170710161,a12021600ux0443","qcFinishOn":null,"qcBy":"","ngBoxNo":"","goodBoxNo":"GoodBox888","ngDescription":"","goodQty":1,"ngQty":0,"returnStatus":"","inStockStatus":"accepted","receiveStauts":"qced","qcBoxNo":"","qcType":"","receiveRemark":"","receiveBy":"liufei","receiveOn":{"$date":"2017-07-12T14:25:32.844Z"},"slotCode":"SZ-2F-36R-09G-03S-03L-02P","slotZone":"2F","billDetailId":"4569761","skuId":"a12021600ux0443","billNo":"CO170710161","billBoxNo":"XN_BOX8888","__v":0,"price":0,"skuWeight":0,"toPackNode":"","packBoxNo":"","packBoxNoLogId":"","packBy":"","packReceiveQty":0,"packedQty":0,"receiveStatus":"qced","returnForsurfaceStatus":"","surfaceReceiveQty":0,"surfaceNgBoxNo":"","surfaceGoodQty":0,"surfaceNgQty":0,"qcReceiveQty":0,"surfaceNgDescription":"","qcNgDescription":"","sendToSampleNum":0,"inStockQty":0,"receiveInfoNgRemark":"","ngNode":"","ngType":"","lastToNgBy":"","lastToNgGoodBy":"","qcBoxNoLogId":"","surfaceNgBoxNoLogId":"","goodBoxNoLogId":"","ngBoxNoLogId":"","zoneSortBoxNoLogId":"","putAwayCarNoLogId":"","receiveBox":"","receiveBoxLogId":"","skuReceiveType":"","surfaceBy":"","packReturnStatus":"","packReturnRemark":"","packReturnBoxNo":"","packReturnBoxNoLogId":"","tortReturnBoxNo":"","tortReturnBoxNoLogId":"","tortReturnStatus":"","tortReturnQty":0,"packReturnQty":0,"surfaceOn":"","packStartOn":"","packEndOn":"","putAwayCarOn":"","lastToNgOn":"","lastToNgGoodOn":""}
Мои данные: последняя строка:
{"_id":{"$oid":"5a5405f8242407be08cfe091"},"supplierId":1676,"modifiedOn":{"$date":"2018-01-09T07:59:52.946Z"},"modifiedBy":"liaoyuexiu","createdOn":{"$date":"2018-01-09T07:59:52.946Z"},"createdBy":"liaoyuexiu","tortReturnStatus":"","tortReturnBoxNoLogId":"","tortReturnBoxNo":"","tortReturnQty":0,"packReturnBoxNoLogId":"","packReturnBoxNo":"","packReturnRemark":"","packReturnQty":0,"packReturnStatus":"","surfaceOn":null,"surfaceBy":"","skuReceiveType":"MROSQCBox","receiveBoxLogId":"5a5364f9283fcc847de697b7","receiveBox":"3993","qcVersion":"","factoryId":"","putAwayCarNoLogId":"","zoneSortBoxNoLogId":"","ngBoxNoLogId":"","goodBoxNoLogId":"","surfaceNgBoxNoLogId":"","qcBoxNoLogId":"","lastToNgGoodOn":null,"lastToNgGoodBy":"","lastToNgOn":"","lastToNgBy":"","ngType":"","ngNode":"","receiveInfoNgRemark":"","putAwayBy":"","putAwayOn":null,"putAwayCarOn":null,"putAwayCarNo":"","sortNum":null,"shelfSortOn":null,"shelfSortBy":"","shelfSortBatch":"","inStockQty":0,"isAddStock":"false","zoneSortBoxNo":"","zoneSortedSortQty":0,"sendToSampleNum":0,"zoneSortedOn":null,"zoneSortedBy":"","goodCodeStr":"sh,CO180105017,a13112000ux0238","qcFinishOn":null,"qcBy":"","ngBoxNo":"","goodBoxNo":"","qcNgDescription":"","surfaceNgDescription":"","goodQty":0,"qcReceiveQty":0,"surfaceNgQty":0,"ngQty":0,"surfaceGoodQty":0,"surfaceNgBoxNo":"","surfaceReceiveQty":0,"returnForsurfaceStatus":"","returnStatus":"","inStockStatus":"","receiveStatus":"received","qcBoxNo":"","qcType":"","receiveRemark":"","packedQty":0,"packReceiveQty":0,"packEndOn":null,"packBy":"","packBoxNoLogId":"","packBoxNo":"","toPackNode":"","packStartOn":null,"receiveBy":"liaoyuexiu","receiveOn":{"$date":"2018-01-09T07:59:52.000Z"},"slotCode":"SZ-7F-16R-04G-04S-03L","slotZone":"7F","skuWeight":0,"receiveQty":0,"supplierSendQty":2,"price":7.14,"billDetailId":"5079818","skuId":"a13112000ux0238","billNo":"CO180105017","billBoxNo":"BXN_CO180105017_2","__v":0}
как я могу использовать mongoexport для получения тех же данных, Columns supplierSendQty,receiveQty Может быть отброшен