topic How to get the task variables data by using sql not url in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231514#M184644 <HTML><HEAD></HEAD><BODY><SPAN>Rest call&nbsp; GET runtime/tasks/{taskId}/variables will fetch you the task variables data.</SPAN><BR /><SPAN>And I have two table ACT_HI_VARINST and ACT_RU_VARIABLE. </SPAN><BR /><SPAN>Should I get the data from ACT_RU_VARIABLE by taskid?</SPAN><BR /><BR /><SPAN>But In ACT_RU_VARIABLE , the TASK_ID_ field is all NULL.</SPAN></BODY></HTML> Tue, 06 Sep 2016 11:22:37 GMT junkings 2016-09-06T11:22:37Z How to get the task variables data by using sql not url https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231514#M184644 Rest call&nbsp; GET runtime/tasks/{taskId}/variables will fetch you the task variables data.And I have two table ACT_HI_VARINST and ACT_RU_VARIABLE. Should I get the data from ACT_RU_VARIABLE by taskid?But In ACT_RU_VARIABLE , the TASK_ID_ field is all NULL. Tue, 06 Sep 2016 11:22:37 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231514#M184644 junkings 2016-09-06T11:22:37Z Re: How to get the task variables data by using sql not url https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231515#M184645 <HTML><HEAD></HEAD><BODY><SPAN>The TASK_ID_ field is, I believe, only set for task local variables.</SPAN></BODY></HTML> Tue, 06 Sep 2016 16:02:37 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231515#M184645 jim1 2016-09-06T16:02:37Z Re: How to get the task variables data by using sql not url https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231516#M184646 <HTML><HEAD></HEAD><BODY><SPAN>I use “SELECT *&nbsp; FROM ACT_RU_VARIABLE variable&nbsp; inner join ACT_RU_TASK task on variable.PROC_INST_ID_ = task.PROC_INST_ID_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where task.ID_ = taskId”&nbsp; to&nbsp; get it</SPAN></BODY></HTML> Tue, 06 Sep 2016 16:15:39 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231516#M184646 junkings 2016-09-06T16:15:39Z Re: How to get the task variables data by using sql not url https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231517#M184647 <HTML><HEAD></HEAD><BODY><SPAN>the task_id for variables will only be filled if the variables are set via the taskService or in a TaskListener.</SPAN><BR /><SPAN>The process instance id is a better way to fetch the variables, when setting through a task, the process instance id will also be set.</SPAN></BODY></HTML> Thu, 08 Sep 2016 09:40:11 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-get-the-task-variables-data-by-using-sql-not-url/m-p/231517#M184647 jbarrez 2016-09-08T09:40:11Z