How to filter field return

I have a data structure by product, in which it has an array with multiple positions, but I need to limit, returning only those that match the search conditions.

{
"idproduto": 11512,
"idgradex": 3,
"idmarca": 3,

                "precosaldo": [
                    {
                        "saldo_receber": 0,
                        "saldo_liquido": 35,
                        "idgrupopreco": 58,
                        "gradey": "110 VOLTS",
                        "idfilial": 10001,
                        "idfilialsaldo": 10001,
                        "idgradey": 1,
                        "precovenda": 2441.9
                    },
                    {
                        "saldo_receber": 0,
                        "saldo_liquido": 35,
                        "idgrupopreco": 61,
                        "gradey": "110 VOLTS",
                        "idfilial": 10001,
                        "idfilialsaldo": 10001,
                        "idgradey": 1,
                        "precovenda": 2639.9
                    },
                    {
                        "saldo_receber": 0,
                        "saldo_liquido": 35,
                        "idgrupopreco": 63,
                        "gradey": "110 VOLTS",
                        "idfilial": 10001,
                        "idfilialsaldo": 10001,
                        "idgradey": 1,
                        "precovenda": 2639.9
                    },
                    {
                        "saldo_receber": 0,
                        "saldo_liquido": 35,
                        "idgrupopreco": 65,
                        "gradey": "110 VOLTS",
                        "idfilial": 10001,
                        "idfilialsaldo": 10001,
                        "idgradey": 1,
                        "precovenda": 2441.9
                    },
                    {
                        "saldo_receber": 7,
                        "saldo_liquido": 5,
                        "idgrupopreco": 258,
                        "gradey": "220 VOLTS",
                        "idfilial": 140001,
                        "idfilialsaldo": 140001,
                        "idgradey": 2,
                        "precovenda": 2659.9
                    }
					]
					}

I need it to return from the precosaldo only what corresponds with the terms of my research.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.