Hi,
I have array/json like this. And now i want try model data structure table.
Rows: ID, Name, Total
How do i SELECT name and total where ID is equal first row ID?
"items" => [
[
"id" => 1,
"name" => Test1,
"total" => 150.00
],
[
"id" => 2,
"name" => Test2,
"total" => 178
]
]
Hi Olavi,
Thanks for the post!
You can add a condition in your formula to only return data for the rows where id=1. This would look like:
/items[id='1']/name
or
/items[id='1']/total
This will only return results for the node that contains the id equal to 1.
Hope this helps!
Parker
