topic Re: LAST_INSERT_ID() sql statement activiti in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/last-insert-id-sql-statement-activiti/m-p/147912#M103249 <HTML><HEAD></HEAD><BODY><SPAN>You have a service task with an SQL expression? Or how must I see that? How do you fetch this data?</SPAN><BR /><BR /><SPAN>I don't see why executing custom SQL shouldn't work from within Activiti … it's all jdbc in the end.</SPAN></BODY></HTML> Thu, 23 May 2013 14:57:34 GMT jbarrez 2013-05-23T14:57:34Z LAST_INSERT_ID() sql statement activiti https://connect.hyland.com/t5/alfresco-archive/last-insert-id-sql-statement-activiti/m-p/147911#M103248 Using LAST_INSERT_ID() does not result in the correct value. Is this function not supported in activiti?I am using the following queries<IMG id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />ervice task with an end listener with the expression:sql:INSERT INTO `requisitions` ( `itemID`, `quantity`, `rejected`) VALUES ( ${itemID}, ${quantity}, "no" ); S Thu, 23 May 2013 08:37:54 GMT https://connect.hyland.com/t5/alfresco-archive/last-insert-id-sql-statement-activiti/m-p/147911#M103248 zilarion 2013-05-23T08:37:54Z Re: LAST_INSERT_ID() sql statement activiti https://connect.hyland.com/t5/alfresco-archive/last-insert-id-sql-statement-activiti/m-p/147912#M103249 <HTML><HEAD></HEAD><BODY><SPAN>You have a service task with an SQL expression? Or how must I see that? How do you fetch this data?</SPAN><BR /><BR /><SPAN>I don't see why executing custom SQL shouldn't work from within Activiti … it's all jdbc in the end.</SPAN></BODY></HTML> Thu, 23 May 2013 14:57:34 GMT https://connect.hyland.com/t5/alfresco-archive/last-insert-id-sql-statement-activiti/m-p/147912#M103249 jbarrez 2013-05-23T14:57:34Z