Workspace: FX_WS_2804
App: 493
Page: 3011
SELECT OID AS ID
, MGR_OID AS PID
, FIRST_NAME||' '||LAST_NAME AS TEXT
, NULL AS URL
, ROW_NUMBER() OVER (ORDER BY OID DESC) AS DISPLAY_SEQ
, NULL AS CSS_CLASS
, NULL AS INFO
, NULL AS CUSTOM
, POSTAL_CODE
, BIRTHDAY
, CASE GENDER
WHEN 'M' THEN '<i style="color: darkblue;" class="fa fa-male"></i>'
WHEN 'F' THEN '<i style="color: darkred;" class="fa fa-female"></i>'
ELSE '<i style="color: darkred;" class="fa fa-question-circle-o"></i>'
END AS GENDER_ICON
, GENDER
FROM FX_T_DEMO_EMPLOYEE
Tree Grid error when searching, when using row_number () over (order by x) in display_seq. How to sort the grid records by a field?
| 0.04252 | 0.00014 |
..Exception occured: ORA-30485: missing ORDER BY expression in the window specification
| 1 |
0%
|
| 0.04266 | 0.00112 |
..Exception Backtrace: ORA-06512: at "FOEX_040001.FX_P_TREE_GRID", line 2236
ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN_UTIL", line 2184
ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 408
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_050100", line 487
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1458
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_050100", line 476
ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1424
ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 408
ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN_UTIL", line 2103
ORA-06512: at "FOEX_040001.FX_P_TREE_GRID", line 1839
ORA-06512: at "FOEX_040001.FX_P_TREE_GRID", line 4579
| 1 |
3%
|
| 0.04378 | 0.00010 |
Stop APEX Engine detected
|
Test case: https://trial.tryfoexnow.com/ords/f?p=493:3011
