Question Re: Sorting Table by Descending Time In XML View in Technology Q&A

Sorting Table by Descending Time In XML View

Former Member — Mon, 30 Apr 2018 06:05:03 GMT

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.

Re: Sorting Table by Descending Time In XML View

former_member340030 — Mon, 30 Apr 2018 06:58:30 GMT

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

Thanks

Viplove

Re: Sorting Table by Descending Time In XML View

Former Member — Tue, 01 May 2018 03:18:26 GMT

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.

Re: Sorting Table by Descending Time In XML View

former_member340030 — Tue, 01 May 2018 06:18:29 GMT

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

Re: Sorting Table by Descending Time In XML View

Former Member — Sun, 27 May 2018 22:43:04 GMT

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

Re: Sorting Table by Descending Time In XML View

junwu — Mon, 28 May 2018 03:00:02 GMT

does your odata service support sort?

Re: Sorting Table by Descending Time In XML View

Former Member — Mon, 04 Jun 2018 00:58:53 GMT

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.