Query After Sorting Does Not Work In A List Mask As Expected
Last updated on JANUARY 31, 2018
Applies to:Oracle Agile Engineering Data Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
On Oracle Agile e18.104.22.168
Find that if in list masks a user clicks into a field title to sort the mask according to this field and then enters a new query and fetches new records from the database, the arrow in that field remains and it appears as if the mask was still sorted according to that field. However, the mask comes up sorted according to the mask definition when new records are fetched from the database.
Either the mask should be sorted according to the clicked field (preferred) or the little arrow in the field title should disappear again.
The issue can be reproduced at will with the following steps:
1. Open a list mask (for example EDB-ART-SLI)
2. Enter a query condition and fetch the records from the database.
3. Resort the mask by clicking on a field title (for example of field "Name")
4. Change the query condition (for example by searching only the records that have a value in field PART_NAME, "Name")
5. Refetch the records from the database
=> The records appear unsorted in the mask (as there is no sort order in the mask definition in the standard) but the arrow in the "Name" field is still there indicating the result is sorted according to that field still.
If the mask definition of EDB-ART-SLI is updated and a sorting condition is entered (for example for field T_DOC_DAT.PART_ID, "Item Number") and then the steps above are processed, the records appear sorted according to field T_DOC_DAT.PART_ID after step 5.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms