Thu, 24 Sep 2026
Login

Unable to find/debug specific error in form/datalist/userview

Confluence User - 23 Aug, 2022

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 ? 

forms

2

Confluence User •
23 Aug, 2022 •
confluenceUser •
1 •
confluenceUser •

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.

Confluence User •
23 Aug, 2022 •
confluenceUser •
•
confluenceUser •

thanks for help. managed to find the error.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print