Question Re: Grouping data in Smart Table in Technology Q&A

Grouping data in Smart Table

nikeshtt — Thu, 29 Nov 2018 06:26:50 GMT

Hey can anyone tell me how to group data in sap.ui.comp.smarttable ?

<smarttable:SmartTable id="fileTableId" header="{i18n>tableTitle}" useTablePersonalisation="true" entitySet="SourceData"
            enableAutoBinding="false" beforeRebindTable="onRebindSourceTable" tableType="ResponsiveTable" showRowCount="true" demandPopin="false"
            class="sapUiSmallMarginBeginEnd" ignoreFromPersonalisation="BusinessUnit"
            customData:p13nDialogSettings="{group:{visible:false},filter:{visible:false}}"
            requestAtLeastFields="Id,Name,Address "
            initiallyVisibleFields=" Id,Name,Address " useExportToExcel="false">
            <smarttable:customToolbar>
                <OverflowToolbar design="Transparent">
                    <ToolbarSpacer/>
                    <Button id="idDownloadTemp" text="{i18n>downloadBut}" tooltip="{i18n>downloadBut}" press="handleDownloadPress"/>
                    <Button id="idUploadExcel" text="{i18n>uploadExcelBut}" tooltip="{i18n>uploadExcelBut}" press="onUploadOpen"/>
                    <Button id="idDeleteFile" icon="sap-icon://delete" tooltip="{i18n>deleteFile}" press="onDeleteFile" enabled="false"/>
                    <Button id="idRefresh" tooltip="{i18n>refresh}" press="onReload" icon="sap-icon://refresh"/>
                </OverflowToolbar>
            </smarttable:customToolbar>
            <Table id="table" growing="true" growingScrollToLoad="true" updateFinished="onUpdateFinished" mode="MultiSelect"
                selectionChange="onTableSelectionChange">

Re: Grouping data in Smart Table

maheshpalavalli — Thu, 29 Nov 2018 07:26:19 GMT

Hi Nikesh T T

You have to create an annotation file and provide sort and groupby annotations to your entityset. For more info, check this blog:

https://blogs.sap.com/2018/01/11/fiori-elements-list-report-sorting-grouping-and-table-types/

BR,

Mahesh

Re: Grouping data in Smart Table

former_member602655 — Sat, 10 Apr 2021 10:52:01 GMT

Hi nikeshtt thank you for very good Blog. Unfortunately still it is not working for me after adding GroupBy to Annotations.

 <Annotation Term="UI.PresentationVariant">
                    <Record Type="UI.PresentationVariantType">
                        <PropertyValue Property="GroupBy">
                            <Collection>
                                <PropertyPath>Category</PropertyPath>
                            </Collection>
                        </PropertyValue>

Re: Grouping data in Smart Table

ibibhu — Mon, 26 Apr 2021 12:49:48 GMT

Hi Nikesh T T,

In this scenario as you have your own table and I guess you might have defined the columns as well. "mergeDuplicates="true"

<smarttable:SmartTable><Tableid="table" growing="true" growingScrollToLoad="true" updateFinished="onUpdateFinished" mode="MultiSelect"selectionChange="onTableSelectionChange"><columns> <Column mergeDuplicates="true">
  <Label design="Bold" text="Item"/>
 </Column></columns>
<item><ColumnListItem vAlign="Middle"> <cells>
  <Text text="{Details}"/> </cells></ColumnListItem>										</items>
<Table></smarttable:SmartTable

Thanks and Regards,
Bibhu

Re: Grouping data in Smart Table

ibibhu — Mon, 26 Apr 2021 12:50:35 GMT

GroupBy is only evaluated for the AnalyticalTable control.

UI5 Reference

Re: Grouping data in Smart Table

yogeshgalphadelti2 — Wed, 29 Oct 2025 14:47:32 GMT

Hello nikeshtt, did you get solution? Please share the details.