infowindow create a wrong column class for EntityType column
Description
redo: create infowindow for AD_Process, just add EntityType column when query, bellow exception is throw because it said EntityType is int
SEVERE: SELECT a.AD_Process_ID, a.EntityType AS EntityType FROM AD_Process a WHERE a.IsActive='Y' AND a.AD_Client_ID=0 AND a.AD_Org_ID=0 AND (a.AD_Process_ID IS NULL OR a.AD_Process_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 284 AND AD_User_ID <> 100 AND IsActive = 'Y' )) NATIVE_PostgreSQL_KEYWORKLIMIT 126 NATIVE_PostgreSQL_KEYWORKOFFSET 0 org.postgresql.util.PSQLException: Bad value for type int : D
Environment
None
Attachments
1
Activity
Show:
Carlos Ruiz February 12, 2020 at 8:15 PM
I was not able to reproduce it with current 7.1
Test case - created an info window for AD_Element with the column EntityType as displayed and search criteria. Worked fine - the column is created with type Table.
RedhuanO November 3, 2016 at 11:35 AM
Edited
Hiep, i will try to study the class later but i found a work-around as attached. I not sure what is your InfoWindow structure and dataype reference for your EntityType element. I set to Table with Reference _EntityTypeNew_T and it does not display. When i set to TableDirect it hits Null pointer. But setting to List seems tolerable.
Major
redo: create infowindow for AD_Process, just add EntityType column
when query, bellow exception is throw because it said EntityType is int
SEVERE: SELECT a.AD_Process_ID, a.EntityType AS EntityType FROM AD_Process a WHERE a.IsActive='Y' AND a.AD_Client_ID=0 AND a.AD_Org_ID=0 AND (a.AD_Process_ID IS NULL OR a.AD_Process_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 284 AND AD_User_ID <> 100 AND IsActive = 'Y' )) NATIVE_PostgreSQL_KEYWORKLIMIT 126 NATIVE_PostgreSQL_KEYWORKOFFSET 0
org.postgresql.util.PSQLException: Bad value for type int : D