How to build server side sorting for ojtable component?

3182533

I can see we can customize the sorting for the ojtable client side, but what is about the server side if the sorting is done there for the whole data in crud application

John 'JB' Brock-Oracle

You would need to have a REST call that returns the data in the sorted order that you want.  JET has no control or ability to control the server side of the application.

Jim.Marion-Oracle

@John , I know that JET collection fetch requests will append paging parameters to the URL. Are there sort parameters as well?

John 'JB' Brock-Oracle

Yes, there is a sort option for the Collection object, but it is a client-side sort after the data is fetched.  It's not going to do a sort on the server.

Jim.Marion-Oracle

Right, because JET is all on the client. I was just wondering if the collection adds a parameter when invoking the sort method. Sounds like it does not.

3182533

I tried a work around for that by using custom cell template like the following

<script type="text/html" id="sortDepartment">
     <th data-bind="click:orderDepartmentId">ID</th>
</script>

the problem is I can 't reach the orderDepartmentId in the viewmodel I have to use $root.orderDepartmentId but the root always return to the main view model in the main.js file.

Does anyone have a solution for that.

Jim.Marion-Oracle

It depends on the context. If it is at the root of the viewModel, then $component should work (although I'm not sure that works with ojModule). Alternatively, you can use one of the $parent or $parents scopes. If you are trying to reach one scope level above the data source, then $parent should work. See Knockout : Binding context for a complete listing of context variables.

3182533

the $parent also return the same result as $root I don't know why but that is my test result.