cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Binding Path for nested array in SAPUI5 Table

0 Likes
4,388

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 
View Entire Topic
boghyon
Product and Topic Expert
Product and Topic Expert
0 Likes

> /Departments/Employees

Which list of employees should the table pick from the departments list? The table cannot know.

The users, however, know which employees from which departments they want to see. Let them decide by allowing them to pick a department first, and then you can bind the corresponding employee list to the table.

I.e. either a tree-like control or a set of two list controls (one for departments, one for the employee list) is needed in your case. Here is an example: https://embed.plnkr.co/fVCzodmvWzieh2LH