How to enable SAPUI5 Table Sorting with non case sensitive?

[Jayakrishnan]

Hi All,

I am working in custom sapui5 application development. In my application i am using sap.ui.table to display the collection data from the OData Service.

I have one column called description in my sap.ui.table. I enabled the sorting feature for that particular column by adding the sortProperty ={description} .

The OData Service implementation is implemented in a direct binding approach(with CDS). SO no manual implementation added in the gate way method level.

When we are checking the sorting functionality it is perfectly worked , if all the description values are created either small letters or capital letters.

Example:

But if user created the description in mixed characters (camel case), the sorting works in a different way. First it sort all the capital letters and then it does for the small letters.

when i tested the same in the Gateway Client, there also i am getting the response like this only for the camel letters.

/sap/opu/odata/sap/ZTEST_SRV/GroupSet?$orderby=Description desc

As an additional check we created new property in the OData Model level (Not in DDIC Table) and converted it to lower cases before sending into Get EntitySet. then we tried the same OrderBy query for the new property also. it also not working.

Is this the standard way of sorting the OrderBy query in the Gateway? Or should we mention anything additionally in the backend or frontend? Pleas help me to sort it out.

Thanks ,

Regards,

Jayakrishnan

[sergei-u-niq]

Dear Jayakrishnan, your analysis has led you in the right direction: if you need a different kind of sorting, you need to get the odata service to do just that.

That being said, I am not sure whether there is a specific annotation that will allow case insensitive order-by. Depending on the amounts of data that you have, you may want to take a different route. be aware that combinations of top and orderby need to be carried out in the correct order: say you want top10 (first page) and you sort by a computed field, you will need to retrieve every single row first (even if you have millions), compute that field, sort, then take top 10. much too expensive.

you may also want to think in other directions: if your values are really months, you may want to store them as numbers rather than strings (this will also easily enable you to display month names in different languages)

[Jayakrishnan]

Thanks sergei.haller.u-niq for your response. i just gave an example with months, but actually it is a user input field. So user can enter the description in any combinations. it will be added as part of the sap.ui.table row.

However i am not able to get your views on the top and order by approaches. so do you mean to say that Order By query options will work with case sensitive only?

Thanks,

Reagrds,

Jayakrishnan.

[farzeen_sayyed]

screenshot-203.png

Hello Jayakrishnan,

My doubt is also same as yours. While sorting Last_Name first Uppercase character is sorting then Lowercase.

[former_member814031]

To enable SAPUI5 table sorting with non-case sensitive, you can follow these steps:

In the table definition, set the "sortProperty" property of the relevant column to the corresponding non-case sensitive property (e.g., "CompanyNameLowerCase" instead of "CompanyName").

Set the "sortOrder" property of the table to "Ascending" or "Descending".

Implement the sorting logic in the table event handler method.

Convert all the values in the sorting column to lowercase or uppercase before sorting, using the "toLowerCase()" or "toUpperCase()" JavaScript functions.

Here's an example code snippet to demonstrate this:

javascript

Copy code

onInit: function() {

var oTable = this.getView().byId("myTable");

oTable.sort(this._sortTable.bind(this));

},

_sortTable: function(oEvent) {

var sSortKey = oEvent.getParameter("column").getSortProperty();

var bSortOrderDescending = oEvent.getParameter("sortDescending");

var oBinding = this.getView().byId("myTable").getBinding("items");

var aSorters = [];

aSorters.push(new sap.ui.model.Sorter(sSortKey, bSortOrderDescending));

oBinding.sort(aSorters, false, true);

var aItems = oBinding.getContexts(0, oBinding.getLength());

oBinding.filter(aItems);

}

In this example, the "sSortKey" value is converted to lowercase using the "toLowerCase()" function before sorting. This ensures that the table sorting is non-case sensitive.

Note that the exact implementation may vary depending on the specific requirements of your SAPUI5 table.

Regards,

Rachel Gomez

[ThorstenHoefer]

Hi,

please consider to sort by an additional column by converting the column to lower or upper case.

Example:

select lower(month) as sort_month
from ...

Regards

Thorsten