SAP ui5 sap.ui.table column sorting not working after table refresh

[vinodkumar_thangavel]

Hi Experts,

I have a UI table and the data is getting refreshed every 10 seconds which is mapped to a JSON model and when I try to sort my column either ascending or descending and during the data refresh the sorting is not working, So how do I keep the column sorting active all the time?

Thanks & Regards,

Vinodkumar.

[junwu]

how you refresh? how do you know the sorting is messed up by the refreshing?

[vinodkumar_thangavel]

Hi Jun Wu,

The below code is how I am binding my data to the table and this model gets refreshed every 10 seconds,

and after refresh the data in the table column is getting updated and not sorted.

not-sorted.png

Thanks & Regards,

Vinodkumar.

[junwu · Accepted solution]

don't create jsonmodel every time when you get new data.

you should use

yourexistingjsonmodel.setData(newData)

what does the onDataReceived do?

[vinodkumar_thangavel · Accepted solution]

Thank You Jun Wu creating the jsonmodel all time was the issue for sorting.

[yogananda]

<Table
    id="idProductsTable"
    items="{
        path: '/data',
        sorter: {
            path: 'name',
            descending: true
        }
    }"
>
    <columns>
        <Column
            sortProperty="name"
            width="13rem">
            <Text text="Name"/>
        </Column>
        <Column
            sortProperty="category"
            width="13rem">
            <Text text="Category"/>
        </Column>
    </columns>
    <items>
        <ColumnListItem>
            <cells>
                <Text text="{name}"/>
                <Text text="{category}"/>
            </cells>
        </ColumnListItem>
    <

Just give you an sample or hint to include sorting in your data refresh logic itself.. instead of you sorting it during event refresh.

[vinodkumar_thangavel]

Hi Yogananda,

Thanks for your valuable input.

But in my scenario the sorting made by the user at the UI level needs to remain the same even after the refresh of the data. Can you please let me know if that is possible?