My Oracle Support Banner

Query After Sorting Does Not Work In A List Mask As Expected (Doc ID 1955748.1)

Last updated on FEBRUARY 23, 2019

Applies to:

Oracle Agile Engineering Data Management - Version and later
Information in this document applies to any platform.


On Oracle Agile e6.1.2.2
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.

Expected Behavior:
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.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.