how to query builder in json data? i'm using guzzle , all i want how to query like searching data where amount is NOT NULL?
json data results :
{
"amount": [
{
"member_id": "SSD",
"sum4": null,
"sum5": null,
"sum6": null
},
{
"member_id": "OGG",
"sum4": 122,
"sum5": 242,
"sum6": 123
},
{
"member_id": "PUCAN",
"sum4": 123,
"sum5": 443,
"sum6": 222
},
{
"member_id": "SS3TG",
"sum4": null,
"sum5": null,
"sum6": null
}
]
}
ALL I WANT HOW TO GET sum4,sum6,sum6 WHERE NOT NULL IN JSON RESULT, can u guys help me..