How to manupulate JSON data for a List of a List in Jquery

Question

I have a JSON data object which I am retrieving from mongoDB. It has the following format:

var billData = [{
    "_id": "PT155/454",
    "_class": "com.aventyn.hms.domain.OPDBill",
    "billingDate": "2017-11-20",
    "patientId": "PT155",
    "transactions": [{
        "txnId": "PT155/454/1",
        "toBePaid": "0",
        "txnAmount": "0",
        "due": "0",
        "selfPay": true
    }, {
        "txnId": "PT155/454/2",
        "toBePaid": "450",
        "txnAmount": "350",
        "due": "100",
        "selfPay": false
    }]
}, {
    "_id": "PT156/455",
    "_class": "com.aventyn.hms.domain.OPDBill",
    "billingDate": "2017-11-20",
    "patientId": "PT156",
    "transactions": [{
        "txnId": "PT156/455/1",
        "toBePaid": "300",
        "txnAmount": "200",
        "due": "100",
        "selfPay": true
    }, {
        "txnId": "PT156/455/2",
        "toBePaid": "100",
        "txnAmount": "50",
        "due": "50",
        "selfPay": true
    }]
}];

My problem is I want to remove those transactions which have property of selfPay: false for this I am doing the following but It is not working:

$.each(billData, function (k, v) {
    $.each(v.transactions, function (tK, tV) {
        if (tV.selfPay == true) {
            billData[k].transactions = tV;
        }
    });
});

But the data which I get is same as what I am getting from the database.

Any idea how can I achieve this?

Thanks for your Help.

Link for jsfiddle is: https://jsfiddle.net/0uy38pLf/

yes it is v.transactions, it was just a typing mistake while typing for this question. — Vipul Singh
– Vipul Singh, Commented Nov 20, 2017 at 8:12

31piy · Accepted Answer · 2017-11-20 08:12:14Z

3

You can use a combination of Array#map and Array#filter to achieve the desired results (without even using any method of jQuery):

var billData = [{
    "_id": "PT155/454",
    "_class": "com.aventyn.hms.domain.OPDBill",
    "billingDate": "2017-11-20",
    "patientId": "PT155",
    "transactions": [{
        "txnId": "PT155/454/1",
        "toBePaid": "0",
        "txnAmount": "0",
        "due": "0",
        "selfPay": true
      },
      {
        "txnId": "PT155/454/2",
        "toBePaid": "450",
        "txnAmount": "350",
        "due": "100",
        "selfPay": false
      }
    ]

  },
  {
    "_id": "PT156/455",
    "_class": "com.aventyn.hms.domain.OPDBill",
    "billingDate": "2017-11-20",
    "patientId": "PT156",
    "transactions": [{
        "txnId": "PT156/455/1",
        "toBePaid": "300",
        "txnAmount": "200",
        "due": "100",
        "selfPay": true
      },
      {
        "txnId": "PT156/455/2",
        "toBePaid": "100",
        "txnAmount": "50",
        "due": "50",
        "selfPay": true
      }

    ]
  }
];

var result = billData.map(bill => {
  bill.transactions = bill.transactions.filter(tran => tran.selfPay);
  return bill;
});

console.log(result);

answered Nov 20, 2017 at 8:12

31piy

23.9k6 gold badges51 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vipul Singh Over a year ago

thank you this one helps a lot.. can you tell if I have to check 2 condition then how to write like in if we use && or || operator to check different condition, can we do this here also

31piy Over a year ago

@VipulSingh -- yes you can. .filter()'s callback should return a boolean expression to include item in the result.

r3dst0rm · Accepted Answer · 2017-11-20 08:13:03Z

1

As far as I can see, it could be better, you negate the if clause. So that you check against selfPay === false.

console.log(billData);
$.each(billData,function(k,v){
    $.each(v.transactions,function(tK,tV){
        if(tV.selfPay === false ){
            billData[k].transactions.splice(tK, 1);
        }
    });
});
console.log(billData)

Also I guess you want to remove just that single item. To remove a single item use the splice function which takes the index of the item you want to remove in this case tK.

Hope it helps!

answered Nov 20, 2017 at 8:13

r3dst0rm

1,94615 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to manupulate JSON data for a List of a List in Jquery

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related