Sorting of a Column in Finder Resuls only Sorts one Page of Results When Using Custom SQL Saved Query (Doc ID 1474027.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 5.5 and later
Information in this document applies to any platform.

Symptoms

A Saved Query is created using custom SQL. When this Saved Query is used on a Finder and the results are sorted manually by a column (by clicking on the column header), only the results on that single page are sorted, and do not include all data in the other pages. When using a Saved Query defined with "Use in Finder", all data is used in the sorting.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms