db.getCollection('bills').find({'customer.code': '7898019', txStatus : 'PROCESSED'})…
- User
db.getCollection('bills').find({'customer.code': '7898019', txStatus : 'PROCESSED'})
This is sample document { "_id" : ObjectId("670676ecb18a402d2aa8ad6a"), "incident" : { "visitType" : "OP", "patientMRN" : "SEHVNS/553/24", "patientName" : "Utakarsh Pandey", "visitId" : "13124842" }, "category" : "MAIN", "patientCategory" : "GENERAL", "totalPatientAmount" : 0, "totalPayer1Amount" : 0, "openPatientAmount" : 0, "openPayer1Amount" : 0, "txStatus" : "PROCESSED", "txAttempted" : 3, "tranId" : "VNS/SOP/24/576", "tranDate" : ISODate("2024-10-09T12:22:10.000Z"), "tranType" : "BILL-CREATE", "internalId" : "13241959", "customer" : { "code" : "7898019", "name" : "SEH-VARANASI", "stateCode" : "09-UP" }, "payer1" : { "code" : "", "name" : "", "gstin" : "", "stateCode" : "", "preAuthReferenceNumber" : "", "preAuthApprovalNumber" : "" }, "unit" : { "code" : "VNS005", "name" : "PAYING - INPATIENT WARD" }, "insuranceProvider" : { "code" : "", "name" : "" }, "processingAgency" : { "code" : "", "name" : "" }, "remarks" : "between soft launch and formal inauguration", "totalGrossAmount" : 300, "totalDiscountAmount" : 300, "totalTaxAmount" : 0, "totalNetAmount" : 0, "totalRoundoffAmount" : 0, "items" : [ { "serialNumber" : 1, "patientAmount" : 0, "payer1Amount" : 0, "_id" : ObjectId("670676ecb18a402d2aa8ad6b"), "chargeId" : "CONSFEE", "chargeName" : "EYE CONSULTATION", "chargeType" : "CHARGE", "chargeGroup" : { "code" : "G-38073", "name" : "GO_CONSULTATION" }, "chargeSubgroup" : { "code" : "G-38078", "name" : "EYE CONSULTATION" }, "statutoryAccountId" : "9993_0%", "batchNumber" : "", "batchNumberId" : "", "quantity" : 1, "mrp" : 0, "rate" : 300, "grossAmount" : 300, "discountPercentage" : 100, "discountAmount" : 300, "taxPercentage" : 0, "taxAmount" : 0, "netAmount" : 0 } ], "createdDateTime" : ISODate("2024-10-09T12:28:28.105Z"), "__v" : 0, "txMessage" : "Successfully posted", "patientBillExternalId" : "33358578" }
I want to get all records whose totalPatientAmount > 0
- Assistant
To retrieve records where the
totalPatientAmountis greater than 0, you need to modify the MongoDB query to include that condition. You can do this by adding a query parameter fortotalPatientAmount. Here's how you can write the query:db.getCollection('bills').find({ 'customer.code': '7898019', 'txStatus': 'PROCESSED', 'totalPatientAmount': { $gt: 0 } })This query will filter the documents in the
billscollection to return only those records where:- The
customer.codeis '7898019'. - The
txStatusis 'PROCESSED'. - The
totalPatientAmountis greater than 0.
Make sure you run this query in an environment that has access to your MongoDB database.
- The