Getting error in query rule after updating CDT column

Question

Hi , 
 Getting following error after updating CDT with new column, updated DB and published data store as well without errors. 
 Expression evaluation error in rule 'ewr_getslparfbyslparfid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [EWREPMSLPARFDT4106], query: [EWR_getSLPARFbySLPARFID], order by: [[]], filters:[(EPMSLPARFID = TypedValue[it=1,v=480])]) 
 
 Thanks 
 Soujanya

Vinay Kumar Rai · Accepted Answer

Hi, 
Did you try to get the server logs, 
 
Can you directly add the column on the CDT, without altering the database table., so appian automatically add a new column on the database table, and check if its work

Vinay Kumar Rai · Answer

Please wrap the column in double quotes, 
 select * from tableName where "ColumnName" = 1111