Skip to Content
0
Jun 18, 2020 at 09:33 PM

Binding Path for nested array in SAPUI5 Table

1350 Views Last edit Jun 18, 2020 at 09:35 PM 2 rev

I am trying to bind a nested array to the SAPUI5 table.

Json Model:
{
"Departments": [
    {
        "ID": "1",
        "Name": "Oil and Gas",
        "Employees": [
            {
                "ID": "12345",
                "LastName": "Tom"
            },
            {
                "ID": "678",
                "LastName": "Jerry",
            }
        ]
    },
    {
        "ID": "2",
        "Name": "Gasoline",
        "Employees": [
            {
                "ID": "21",
                "LastName": "Donald"
            },
            {
                "ID": "22",
                "LastName": "duck"
            }
        ]
    }
]
}

I am using SAPUI5 table:

 <Table 
    items="{path:'oDataItem>/Departments/Employees'}"                                       
    width="auto"
    fixedLayout="false" 
    mode="MultiSelect" >
    <columns>
        <Column width="auto">
            <Text text="LastName of Employee" />
        </Column>
     </columns>
         <items>
             <ColumnListItem>
                 <cells>
                      <Input editable="true" textAlign="Left" type="Text" change="onNameTextChange" width="15em" value="{path:'oDataItem>LastName'}" />
                 </cells>
            </ColumnListItem>
         </items>           
 </Table>

Above databinding path is not returning any data. 
Can i fetch lastName by XML databinding? If yes, than how i fetch last name?

Thanks