Sorting Table by Descending Time In XML View

[#1]

Hi experts,

I believe I must be missing something quite simple. I am trying to sort my table by time in descending order. My data is bound to my table from a SAP gateway oData service. The time is in EDM.string format therefore PT00HH00MM00S. Bindings are working fine and sorting by ascending works as well. I am currently trying to sort by descending using the following parameters:

<Table class="someClass" headerText="Change History"
			   items="{
					path : 'model>entity',
					parameters:{expand : 'entity'},
					 sorter : 
					  { 
					  path : 'model>time',
					  descending : 'true'
					  }
					  
				}">
				<headerToolbar>
...

However, the table is still sorted in ascending order. Please see screenshot of this column below:

Any hints are appreciated. Or am I mistaken and the only way to do this is with a custom comparator?

Thank you.

[former_member340030]

Can you check the networks tab and see how the odata sorting call is made to this entity

Thanks

Viplove

[Former Member]

Thank you for your response Viplove.

I tried to isolate this call in the network tab but was unable to. For some context, I have this oData model two-way bound to the element on the parent controller. eg

this.getView().bindElement({
					path:  "/pathToData('"+parameter+"')",
				    model: "model",
				    parameters: {
				      expand: "entitySet1,entitySet2,entitySet3"
				    }
			}

So I can only see one batch call in my network tab, screenshot:

Is there another way to view the separate call in debugger? Thanks for your help.

[former_member340030]

Yeah you can see the individual batch request for debugging purposes later on just remove this command again .. Just put this line of code in the component.js file ..

this.getModel().setUseBatch(false);

Actually putting this will make multiple calls to the server which will reduce the performance but for debugging we can see separate odata calls to server

thanks

Viplove

[Former Member]

Sorry about the extremely long response time, I got busy with more important parts of the project, the request is GET MainSet('123456789')/HistorySet?$skip=0&$top=10&$orderby=Utime%20desc&$expand=HistorySet

[Former Member]

We decided to do our sorting on the backend for this table, we currently don't need any customisable sorting or filtering for this table.

[junwu]

does your odata service support sort?