Sorting issue - Data is not sorted in Hybrid Web conctainer (HWC) SUP app .

[Former Member]

Sorting issue - Data is not sorted in Hybrid Web conctainer (HWC) app .

Requirement  : Need to display table data in a particular sort order on HWC Mobile SUP app .

Data source for the MBO is an RFC from SAP system : At RFC (ABAP) level :The data is fetched from database table  and the internal table is sorted on required key field .  But somehow when it is displayed on mobile screen ,it is not in the required sort order .

e.g

RFC/ABAP : The records are sorted on WBZEND ( SORT li_tab BY wbzend ASCENDING. )

  The RFC returns below internal table: 

But somehow the data is displayed as below ( it is in asscending order of TPLNR )

Screenshot of the app

Quick reply is appricated !

Thanks,

Shri Kendre

[midhun_vp]

A quick workaround is here, mark the field as primary key in MBO to be sorted.

- Midhun VP

[Jitendra_Kansal]

can you check data sorting in SUP cache database? how exactly it is coming there.

How to access SUP CDB (Cache Database) ? 

[Former Member]

Hello,

If you have fetched cached data, then you should change your findAll( or similar ) query.

select .* from <table> order by tplnr asc.

Cached items were not written into database in the same order in rfc. Therefore when you retrieve data from cache you should add your order case at the end of your autogenerated querys.