While using a lookup based on a query that has the ROW_NUMBER function in Microsoft SQL Server, ordering by the column in the Modern User Experience (UX does not work and makes all the results disappear.
Steps to Reproduce:
Expected Results: It correctly does ascending/descending sort.
Actual Results: All rows for this custom object disappear. A "No Rows To Show" message is displayed.
This issue has been reported to Engineering as DE60703.
Release : 15.9.1 and 15.9.2 using Microsoft SQL Server
Component : CLARITY STUDIO
This has been fixed in Clarity 15.9.3, as well as included in 15.9.2 patch #1.