Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 473 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
SetCurrentRowWithKey breaks table sort order

The problem occurs when a new task flow is opened and default activity is SetCurrentRowWithKeyValue. If the row is found within the N first rows (where N is range size of iterator) and the table is working with pagination then it works okay. But if the row is not found within the first N rows, then the row can be found on the second page (i.e. at N+1 position) and has been moved from its position after default sorting. The thing is that the record will always be placed in the N+1 position but never in its sorting position.
For instance if we show the table with two rows and if the key to search is "2", the row order would be alright: (note : underscore means next page)
Id | Name
______________
1 | name_1
2 | name_2
______________
3 | name_3
4 | name_4
______________
5 | name_5
6 | name_6
But if search for the key "5" then the table would look like this:
Id | Name
______________
1 | name_1
2 | name_2
______________
5 | name_5
3 | name_3
______________
4 | name_4
6 | name_6
it looks like the "problem" occurs when ADF is fetching data and appends the searched row after the initially fetch ones. This means (and we tested it) that if range size of iterator is set to -1, then all rows would be fetched and the searched row would be found in fetched rows not losing its position in the sorting order.
Our question is how to accomplish behavior like when the range size of iterator is set to -1 (i.e. setting current row without breaking sort order) but with normal value for range size (i.e. 10)
JDev 12.2.1.2.0
Thank you