1
0
-1
1 answer
- 10-1
Ensure the Primary Key property field is correctly filled, for your example, it should be "A.id". See JDBC Datalist Database Binder#ConfigureJDBCDatalistBinder Check the joget.log for more information of the error.
Add your comment...
I want to read records from 2 tables in a list.
this is my query,
Select A.id
,A.dateCreated
,A.dateModified
,A.createdBy
,A.createdByName
,A.modifiedBy
,A.modifiedByName
,A.c_cc
,A.c_spr_name
,A.c_gl
,A.c_date_action
,A.c_date_created
,A.c_sbu
,A.c_tms_id
,A.c_description
,A.c_section
,A.c_remark
,A.c_allstaffid
,A.c_date_of_misconduct
,A.c_attachment
,A.c_name
,A.c_spr_id
,A.c_action
,A.c_designation
,A.c_date_of_misconduct_to
,A.c_department
,A.c_staffid
,A.c_doj
,A.c_reference_no
,A.c_misconduct_no
,A.c_yc_points
,B.c_content
,B.c_letter_title
,B.c_letter_no
,B.c_reference_no
,B.c_attachment
,B.c_date_letter
from app_fd_hr_sd_details as A
left join app_fd_hr_sd_details_print as B
on A.c_staffid = B.c_staffid
I have got an error of fail to retrieve column list. May I know why this happened?