Model data


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 

1 comment

  • Avatar
    Parker Selman Official comment

    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:




    This will only return results for the node that contains the id equal to 1. 

    Hope this helps! 


Please sign in to leave a comment.