topic Re: i want to fetch data from mysql database in form fields and insert data in Alfresco Archive

topic Re: i want to fetch data from mysql database in form fields and insert data in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/i-want-to-fetch-data-from-mysql-database-in-form-fields-and/m-p/211859#M164989 <HTML><HEAD></HEAD><BODY><SPAN><code></SPAN><BR /><SPAN><?xml version="1.0" encoding="UTF-8"?></SPAN><BR /><SPAN><definitions xmlns="</SPAN><A href="http://www.omg.org/spec/BPMN/20100524/MODEL" rel="nofollow noopener noreferrer">http://www.omg.org/spec/BPMN/20100524/MODEL</A><SPAN>" xmlns:xsi="</SPAN><A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A><SPAN>" xmlns:xsd="</SPAN><A href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A><SPAN>" xmlns:activiti="</SPAN><A href="http://activiti.org/bpmn" rel="nofollow noopener noreferrer">http://activiti.org/bpmn</A><SPAN>" xmlns:bpmndi="</SPAN><A href="http://www.omg.org/spec/BPMN/20100524/DI" rel="nofollow noopener noreferrer">http://www.omg.org/spec/BPMN/20100524/DI</A><SPAN>" xmlns<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />mgdc="</SPAN><A href="http://www.omg.org/spec/DD/20100524/DC" rel="nofollow noopener noreferrer">http://www.omg.org/spec/DD/20100524/DC</A><SPAN>" xmlns<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />mgdi="</SPAN><A href="http://www.omg.org/spec/DD/20100524/DI" rel="nofollow noopener noreferrer">http://www.omg.org/spec/DD/20100524/DI</A><SPAN>" typeLanguage="</SPAN><A href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A><SPAN>" expressionLanguage="</SPAN><A href="http://www.w3.org/1999/XPath" rel="nofollow noopener noreferrer">http://www.w3.org/1999/XPath</A><SPAN>" targetNamespace="</SPAN><A href="http://www.activiti.org/test" rel="nofollow noopener noreferrer">http://www.activiti.org/test</A><SPAN>"></SPAN><BR /><SPAN>  <process id="myProcess1" name="My process" isExecutable="true"></SPAN><BR /><SPAN>    <endEvent id="endevent1" name="End"></endEvent></SPAN><BR /><SPAN>    <startEvent id="startevent2" name="Start"></SPAN><BR /><SPAN>      <extensionElements></SPAN><BR /><SPAN>        <activiti:formProperty id="name" name="Name" type="string" default="sql_ui: SELECT `FIRST_` FROM `act_id_user` WHERE `ID_`='heba'" required="true"></activiti:formProperty></SPAN><BR /><SPAN>      </extensionElements></SPAN><BR /><SPAN>    </startEvent></SPAN><BR /><SPAN>    <userTask id="usertask1" name="User Task" activiti:candidateGroups="admin"></SPAN><BR /><SPAN>      <documentation>${name}</documentation></SPAN><BR /><SPAN>      <extensionElements></SPAN><BR /><SPAN>        <activiti:formProperty id="name1" name="Name" type="string" default="SELECT `FIRST_` FROM `act_id_user` WHERE `ID_`='heba'"></activiti:formProperty></SPAN><BR /><SPAN>        <activiti:taskListener event="create" expression="sql:INSERT INTO `order`(`layerId`, `orderNo`, `userId`) VALUES (2,6,'${name}');"></activiti:taskListener></SPAN><BR /><SPAN>      </extensionElements></SPAN><BR /><SPAN>    </userTask></SPAN><BR /><SPAN>    <sequenceFlow id="flow5" sourceRef="usertask1" targetRef="endevent1"></sequenceFlow></SPAN><BR /><SPAN>  </process></SPAN><BR /><SPAN></code></SPAN></BODY></HTML> Wed, 18 Nov 2015 10:51:15 GMT heba 2015-11-18T10:51:15Z i want to fetch data from mysql database in form fields and insert data https://connect.hyland.com/t5/alfresco-archive/i-want-to-fetch-data-from-mysql-database-in-form-fields-and/m-p/211857#M164987 i made a simple example to fetch and insert data in database but there is no results and this is my workflow xml  ———————-<?xml version="1.0" encoding="UTF-8"?><definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="h Wed, 18 Nov 2015 10:31:24 GMT https://connect.hyland.com/t5/alfresco-archive/i-want-to-fetch-data-from-mysql-database-in-form-fields-and/m-p/211857#M164987 heba 2015-11-18T10:31:24Z Re: i want to fetch data from mysql database in form fields and insert data https://connect.hyland.com/t5/alfresco-archive/i-want-to-fetch-data-from-mysql-database-in-form-fields-and/m-p/211858#M164988 <HTML><HEAD></HEAD><BODY><SPAN>this is my workflow xml what can i do to run ?</SPAN></BODY></HTML> Wed, 18 Nov 2015 10:33:56 GMT https://connect.hyland.com/t5/alfresco-archive/i-want-to-fetch-data-from-mysql-database-in-form-fields-and/m-p/211858#M164988 heba 2015-11-18T10:33:56Z Re: i want to fetch data from mysql database in form fields and insert data https://connect.hyland.com/t5/alfresco-archive/i-want-to-fetch-data-from-mysql-database-in-form-fields-and/m-p/211859#M164989 <HTML><HEAD></HEAD><BODY><SPAN><code></SPAN><BR /><SPAN><?xml version="1.0" encoding="UTF-8"?></SPAN><BR /><SPAN><definitions xmlns="</SPAN><A href="http://www.omg.org/spec/BPMN/20100524/MODEL" rel="nofollow noopener noreferrer">http://www.omg.org/spec/BPMN/20100524/MODEL</A><SPAN>" xmlns:xsi="</SPAN><A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A><SPAN>" xmlns:xsd="</SPAN><A href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A><SPAN>" xmlns:activiti="</SPAN><A href="http://activiti.org/bpmn" rel="nofollow noopener noreferrer">http://activiti.org/bpmn</A><SPAN>" xmlns:bpmndi="</SPAN><A href="http://www.omg.org/spec/BPMN/20100524/DI" rel="nofollow noopener noreferrer">http://www.omg.org/spec/BPMN/20100524/DI</A><SPAN>" xmlns<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />mgdc="</SPAN><A href="http://www.omg.org/spec/DD/20100524/DC" rel="nofollow noopener noreferrer">http://www.omg.org/spec/DD/20100524/DC</A><SPAN>" xmlns<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />mgdi="</SPAN><A href="http://www.omg.org/spec/DD/20100524/DI" rel="nofollow noopener noreferrer">http://www.omg.org/spec/DD/20100524/DI</A><SPAN>" typeLanguage="</SPAN><A href="http://www.w3.org/2001/XMLSchema" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema</A><SPAN>" expressionLanguage="</SPAN><A href="http://www.w3.org/1999/XPath" rel="nofollow noopener noreferrer">http://www.w3.org/1999/XPath</A><SPAN>" targetNamespace="</SPAN><A href="http://www.activiti.org/test" rel="nofollow noopener noreferrer">http://www.activiti.org/test</A><SPAN>"></SPAN><BR /><SPAN>  <process id="myProcess1" name="My process" isExecutable="true"></SPAN><BR /><SPAN>    <endEvent id="endevent1" name="End"></endEvent></SPAN><BR /><SPAN>    <startEvent id="startevent2" name="Start"></SPAN><BR /><SPAN>      <extensionElements></SPAN><BR /><SPAN>        <activiti:formProperty id="name" name="Name" type="string" default="sql_ui: SELECT `FIRST_` FROM `act_id_user` WHERE `ID_`='heba'" required="true"></activiti:formProperty></SPAN><BR /><SPAN>      </extensionElements></SPAN><BR /><SPAN>    </startEvent></SPAN><BR /><SPAN>    <userTask id="usertask1" name="User Task" activiti:candidateGroups="admin"></SPAN><BR /><SPAN>      <documentation>${name}</documentation></SPAN><BR /><SPAN>      <extensionElements></SPAN><BR /><SPAN>        <activiti:formProperty id="name1" name="Name" type="string" default="SELECT `FIRST_` FROM `act_id_user` WHERE `ID_`='heba'"></activiti:formProperty></SPAN><BR /><SPAN>        <activiti:taskListener event="create" expression="sql:INSERT INTO `order`(`layerId`, `orderNo`, `userId`) VALUES (2,6,'${name}');"></activiti:taskListener></SPAN><BR /><SPAN>      </extensionElements></SPAN><BR /><SPAN>    </userTask></SPAN><BR /><SPAN>    <sequenceFlow id="flow5" sourceRef="usertask1" targetRef="endevent1"></sequenceFlow></SPAN><BR /><SPAN>  </process></SPAN><BR /><SPAN></code></SPAN></BODY></HTML> Wed, 18 Nov 2015 10:51:15 GMT https://connect.hyland.com/t5/alfresco-archive/i-want-to-fetch-data-from-mysql-database-in-form-fields-and/m-p/211859#M164989 heba 2015-11-18T10:51:15Z