topic How do we set parameters value while querying Activiti database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-do-we-set-parameters-value-while-querying-activiti-database/m-p/209538#M162668 <HTML><HEAD></HEAD><BODY><SPAN>Hi Guys,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am new to Activiti Framework, need to know how do we set parameters value while querying Activiti database…..</SPAN><BR /><BR /><SPAN>Below are the select query which I am calling from my java program……</SPAN><BR /><BR /><SPAN>&lt;mapper resource="org/activiti/db/mapping/entity/HistoricActivityInstance.xml" /&gt;</SPAN><BR /><BR /><SPAN>&lt;!– HISTORIC ACTIVITY INSTANCE SELECT –&gt;</SPAN><BR /><SPAN>&nbsp; </SPAN><BR /><SPAN>&nbsp; &lt;select id="selectHistoricActivityInstance" resultMap="historicActivityInstanceResultMap"&gt;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp; select * from ${prefix}ACT_HI_ACTINST where ACT_ID_ = #{activityId} and PROC_INST_ID_ = #{processInstanceId}</SPAN><BR /><SPAN>&nbsp; &lt;/select&gt;</SPAN><BR /><BR /><SPAN>&lt;!—–Java Program to call the above select query —–&gt;</SPAN><BR /><BR /><SPAN>List&lt;HistoricActivityInstanceEntity&gt; historicActivityInstanceList = getManagementServiceInstance().executeCommand(new Command&lt;List&lt;HistoricActivityInstanceEntity&gt;&gt;() {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; @SuppressWarnings("unchecked")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public List&lt;HistoricActivityInstanceEntity&gt; execute(CommandContext commandContext) {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return (List&lt;HistoricActivityInstanceEntity&gt;) commandContext.getDbSqlSession().selectList("selectHistoricActivityInstance");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; });</SPAN><BR /><BR /><SPAN>Now question is how do we pass value for #{activityId} and #{processInstanceId} from java program ??</SPAN><BR /><BR /><SPAN>please advise as soon as possible.</SPAN><BR /><SPAN>please do let me know if any clarification required.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Rajiv.</SPAN></BODY></HTML> Tue, 01 Sep 2015 13:20:43 GMT rajiv_cusat 2015-09-01T13:20:43Z How do we set parameters value while querying Activiti database https://connect.hyland.com/t5/alfresco-archive/how-do-we-set-parameters-value-while-querying-activiti-database/m-p/209538#M162668 Hi Guys,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am new to Activiti Framework, need to know how do we set parameters value while querying Activiti database…..Below are the select query which I am calling from my java program……&lt;mapper resource="org/activiti/db/mapping/entity/HistoricActivityInstance.xml" /&gt;&lt;!– HIS Tue, 01 Sep 2015 13:20:43 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-we-set-parameters-value-while-querying-activiti-database/m-p/209538#M162668 rajiv_cusat 2015-09-01T13:20:43Z Re: How do we set parameters value while querying Activiti database https://connect.hyland.com/t5/alfresco-archive/how-do-we-set-parameters-value-while-querying-activiti-database/m-p/209539#M162669 <HTML><HEAD></HEAD><BODY><SPAN>Why are you not using the HistoryService and query api to query the database?</SPAN><BR /><BR /><SPAN>Best regards,</SPAN></BODY></HTML> Thu, 03 Sep 2015 07:00:30 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-we-set-parameters-value-while-querying-activiti-database/m-p/209539#M162669 trademak 2015-09-03T07:00:30Z Re: How do we set parameters value while querying Activiti database https://connect.hyland.com/t5/alfresco-archive/how-do-we-set-parameters-value-while-querying-activiti-database/m-p/209540#M162670 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for your input…Using HistoryService, I am able to get desired result in the simplest manner.</SPAN><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Rajiv Ranjan.</SPAN></BODY></HTML> Mon, 14 Sep 2015 09:34:40 GMT https://connect.hyland.com/t5/alfresco-archive/how-do-we-set-parameters-value-while-querying-activiti-database/m-p/209540#M162670 rajiv_cusat 2015-09-14T09:34:40Z