How to filter field return

Elastic Stack Elasticsearch
1

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.

2

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