When results are returned from a query, and a user sorts those results, we don't want to have results with null data points to appear at the top of an ascending sort.
So for example here (username: coder, password: coderpw):
[url removed, login to view]
if you do a search for 'FUND CATEGORY > LARGE CAP VALUE' you'll get a list of 1269 funds.
If you then sort those results by MAXrating Worst, you'll get several pages of MAXrating N/A at the top of the list.
In this case we'd like a sort of MAXrating Worst to have at the top of the list only results where MAXrating was not null, but we don't want those results excluded from the query (ideally the null results would be moved to the end of the sorted list).
This issue affects the following sorts:
EXPENSE RATIO LOWEST
PERF. WORST 5-YR
PERF. WORST 3-YR
PERF. WORST 1-YR
PERF. WORST YTD
I'll have the other project up shortly. Thanks.