Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K 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)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 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
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
ADF Table : After sorting by a column, selected editable row does not honour the sort order

I have an adf table with 30 rows with the below properties :
scrollPolicy="page", rowSelection="multiple", editingMode="clickToEdit", fetchSize="5".
VO tuning parameters are as follows :
"All rows" in batches of "10", "As needed". AccessMode is set to "Scrollable" with Range size "10".
Steps to replicate issue :
- Select a row (row becomes editable because of the editingMode property)
- Sort by column (i.e. deptNumber)
- Paginate to the next page, observe that the selected row from the first page shows at the top(first row of the 2nd page).
NOTE : his issue does not appear in the below cases :
- If VO's tuning parameter has AccessMode set to "RANGE_PAGING".
- If VO's tuning parameter has "All at once" instead of "As needed".
Ask : Need to find out how the selected row is getting set at the first position of the next page.
Answers
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,434 Red Diamond
User, tell us your exact JDev version, please!
I guess that's because when you make the row editable it gets selected and it keeps selected in your case. why it works in the other cases I don't know.
What do you try to archive?
That the selected row get deselected when you navigate to another page?
Can you provide a reproducible test case?
Timo
-
Hi Timo,
Thanks for your response.
Jdev version : Studio Edition Version 20.0.0.1.0
When we navigate to other pages, it is expected to have the row selected (But, as per the sorted order, that is not happening with these specific VO tuning parameters).
Reproducible test case steps :
- create a view with department table(HR schema) having the mentioned parameters in the problem statement.
- create a jsff with and drag the created VO showing data as an ADF table with sort enabled.
- Select a row (row becomes editable because of the editingMode property)
- Sort by column (i.e. deptNumber)
- Paginate to the next page, observe that the selected row from the first page shows at the top(first row of the 2nd page) OR any other page where the selected row is supposed to be, notice that the selected row is not in it's correct position after sort.
~~~
We observed the below :
Example,
total number of rows in table : 30
each pages shows : 5 rows (total 6 pages to navigate)
when we sort a column in DESC order, it executes the query and fetches first 5 rows in an arrayList. Now, when we navigate to page 2, it fetches the next set of rows. It fetches the selected row first, then moves on to fetch the other 4 rows. Hence, we see the selected row on the first position of the 2nd page.
Thanks.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,434 Red Diamond
User, the version you are using is not available to the public. We can't help with this version.
You should ask this question using an internal channel.
If you can reproduce this in 12.2.1.4 you should provide a reproducible test case built on the HR DB schema that we can use to look into this issue.
Timo