it shows this error: Invalid Workflow ExecSql

Hi Murni

If there is a SQL error it will show in the log and it will point to what is wrong.

this is the error from SQL Log

Mar 11 2024 15:23:49.763	2160	8368	1	execsql,time,sql,errormsg	0	update Lead set Lead_AssignedUserID=#U where Lead_LeadID=2
	Invalid column name '#U'

And what happens when you use

update Lead set Lead_AssignedUserID=#User_userid# where Lead_LeadID=#Lead_LeadID#

I have this error when using update Lead set Lead_AssignedUserID=#User_userid# where Lead_LeadID=#Lead_LeadID#

Mar 11 2024 16:13:38.735	2160	8368	1	SQL Error : Incorrect syntax near the keyword 'where' (update Lead set Lead_AssignedUserID= where Lead_LeadID=8
)
Mar 11 2024 16:13:38.750	2160	8368	1	Invalid Workflow ExecSql : <BR>SQL Error
Mar 11 2024 16:13:38.750	2160	8368	1	Invalid Workflow ExecSql : <BR>SQL Error

based on this reference: https://help.sagecrm.com/on_premise/en/2021R2/Administration/Content/Administrator/VC_UniqueIdentifiers.htm

have to use #user_userid#

So the correct statement is update Lead set Lead_AssignedUserID=#user_userid# where Lead_LeadID=#Lead_LeadID#

Correct, CRM is always 'aware' of the Current user, so when executing a SQL statement you can use any of the user_xxx fields where needed. I think the shorthand (e.g. #U) is only for use within CRM where you see the SQL field (e.g. on tabs in order to suppress them)