Binding expanded entityset result to smart table

Kishoregokara — Thu, 07 Jan 2021 08:35:26 GMT

Hello,

I am trying to bind an expanded entity set result to a smart table. Followed the below steps.

I tried giving the navigation property name in tableBindingPath property (as mentioned at link). But that's not working. So I defined custom columns(as mentioned at here and here) and tried binding the navigation property fields names. Also in beforeRebindTable I have mentioned the expand parameter as below

mBindingParams.parameters["expand"] = "HeaderToItemNav";

The second approach works and expanded entity call happens and pulls the data. But only the header set data is binding and not the dependent entity set details.

Please throw some light on how to achieve this.

<smartFilterBar:SmartFilterBar id="smartFilterBar" entitySet="HeaderSet">
                            <smartFilterBar:controlConfiguration>
                                <smartFilterBar:ControlConfiguration key="Id" visibleInAdvancedArea="true" preventInitialDataFetchInValueHelpDialog="false">
                                </smartFilterBar:ControlConfiguration>
                            </smartFilterBar:controlConfiguration>
                        </smartFilterBar:SmartFilterBar>

                        <smartTable:SmartTable id="smartIdid" 
                                               entitySet="HeaderSet" 
                                               tableType="ResponsiveTable" 
                                               useExportToExcel="true" 
                                               useTablePersonalisation="true" 
                                               showRowCount="true" 
                                               showFullScreenButton="false" 
                                               enableAutoBinding="true" 
                                               showVariantManagement="true" 
                                               width="100%" header="Stocks" 
                                               beforeRebindTable="onBeforeRebind">
                            <Table id="dataTable">
                                <columns>
                                    <Column>
                                        <customData>
                                            <core:CustomData key="p13nData" 
                                                             value='{"columnKey": "Sdept","leadingProperty": "HeaderToItemNav/Sdept"}'/>
                                        </customData>
                                        <Text text="Department"/>
                                    </Column>
                                    <Column>
                                        <customData>
                                            <core:CustomData key="p13nData" 
                                                             value='{"columnKey": "Stock","leadingProperty": "HeaderToItemNav/Stock"}'/>
                                        </customData>
                                        <Text text="Stock"/>
                                    </Column>
                                </columns>
                                <items>
                                    <ColumnListItem>
                                        <cells >
                                            <Text text="{HeaderToItemNav/Sdept}"/>
                                        </cells>
                                        <cells >
                                            <Text text="{HeaderToItemNav/Stock}"/>
                                        </cells>
                                    </ColumnListItem>
                                </items>
                            </Table>
                        </smartTable:SmartTable>

Controller:

            onBeforeRebind: function (oEvent) {
                var mBindingParams = oEvent.getParameter("bindingParams");
                mBindingParams.parameters["expand"] = "HeaderToItemNav";
            },

result-set.txt

Re: Binding expanded entityset result to smart table

GeethaRanjani — Fri, 05 Jan 2024 07:51:46 GMT

Did you get a solution to this?

Question Re: Binding expanded entityset result to smart table in Technology Q&A

Binding expanded entityset result to smart table

Re: Binding expanded entityset result to smart table