1
0
-1
1 answer
- 210
You won't find the exact query since it's probably a query displayed after going thru hibernate. The clue that I can see is that it's from a formOptionsBinder. So it's in a form with an element with lots of options i.e select box, checkbox, radio. Have you checked the APM error tab? Click on the red dot in the error tab to display more info. You might be able to trace it from there.
Another way like you mentioned, go to C:\Joget-DX7-Enterprise\wflow\app_src\appName\appName_versionNumber\forms\findtheform.json
and look for the "ORDER BY" query. Chances are it's typed into Default Form Options binder > Extra Filter Condition field property.- ayohmang
thanks for help. managed to find the error.
Add your comment...
good day to all jogetians,
recently joget logs error keep recurring on this matter :
ERROR 22 Aug 2022 22:13:03 FormOptionsBinder - org.hibernate.QueryException: could not resolve property: daerah of: app_fd_daerah [SELECT e FROM app_fd_daerah e ORDER BY cast(e.daerah as string)]
org.hibernate.QueryException: could not resolve property: daerah of: app_fd_daerah [SELECT e FROM app_fd_daerah e ORDER BY cast(e.daerah as string)]
i have been searching part of error string in app_form,app_datalist,app_userview (json column), but cant find sql usage in the json column.
is there any files such hibernate mapping xml to look for ?