Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 401 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
How to build server side sorting for ojtable component?
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
Answers
-
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.
-
@John , I know that JET collection fetch requests will append paging parameters to the URL. Are there sort parameters as well?
-
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.
-
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.
-
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.
-
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.
-
the $parent also return the same result as $root I don't know why but that is my test result.
