topic How to get the table fields? in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/how-to-get-the-table-fields/m-p/28081#M12018 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using activiti in my spring web application. I was created one listener with implements of TaskListener like as below.</P><P></P><P>public class MyEventListener implements TaskListener {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public void notify(DelegateTask delegateTask) {</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List list =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;delegateTask.getExecution().getEngineServices().getRuntimeService().createNativeExecutionQuery().sql("select * from act_custom_process").list();<BR />&nbsp; &nbsp; &nbsp; for (Object object : list) {<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; System.out.println("object: "+object);<BR />&nbsp; &nbsp; &nbsp; }<BR /> }</P><P></P><P>}</P><P>}</P><P></P><P>Here i would like to execute sql query. Now, how can i&nbsp;get the database table fields.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 28 Dec 2017 09:14:12 GMT vamsinipun 2017-12-28T09:14:12Z How to get the table fields? https://connect.hyland.com/t5/alfresco-forum/how-to-get-the-table-fields/m-p/28081#M12018 Hi,I am using activiti in my spring web application. I was created one listener with implements of TaskListener like as below.public class MyEventListener implements TaskListener {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public void notify(DelegateTask delegateTask) {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List list =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;delegateTask.getExecution().getEngineServ Thu, 28 Dec 2017 09:14:12 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-get-the-table-fields/m-p/28081#M12018 vamsinipun 2017-12-28T09:14:12Z Re: How to get the table fields? https://connect.hyland.com/t5/alfresco-forum/how-to-get-the-table-fields/m-p/28082#M12019 <HTML><HEAD></HEAD><BODY><P>If you are writing in Java, you can realize it in your preferred way without using Activiti's features in particular.</P><P></P><P>However, if you want to do with the function of Activiti, I think that the following will be helpful.</P><P><A class="jivelink10" href="http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/" title="http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/" rel="nofollow noopener noreferrer">http://www.jorambarrez.be/blog/2014/01/17/execute-custom-sql-in-activiti/</A></P></BODY></HTML> Thu, 28 Dec 2017 12:30:15 GMT https://connect.hyland.com/t5/alfresco-forum/how-to-get-the-table-fields/m-p/28082#M12019 Anonymous 2017-12-28T12:30:15Z