M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 22
Registered: ‎03-16-2020

can't get form field to be used it entity after save trigger (inside sql insert statement)

[ Edited ]

can't get form field to be used it entity after save trigger (inside sql insert statement)

I cannot get value of form id (PointForm) wich stored in table (points) column (id) and store it into another table (work_logs) column (change_id) by SQL statement because in my status I used SQL trigger 


and that is my code which I used context.getValue('column name') but it's not working

 

<Entity.Triggers>
	<SqlTrigger  Method="AfterSave,AfterUpdate" Sql="INSERT INTO  work_logs (app_name,user_name,start_time,sec,gov,change_id) VALUES ('تطبيق الموبايل بالمركز',@{System.UserName},NOW(), 'مركز المنيا' , 'محافظة المنيا' ,context.getValue('id') )" />
</Entity.Triggers>	

please check the attached zip file

am I miss something??