<process name="Test_ScheduledCheckLockMessage">
<!-- This business process lists the locked messages that came in the last 30 minutes-->
<sequence name="ListMessage">
<operation name="LWJDBC">
  <participant name="Test_LWJDBC"/>
	<output message="LightweightJDBCAdapterTypeInputMessage">
	  <assign to="result_name">result</assign>
    <assign to="sql">select MESSAGE_ID,MESSAGE_NAME 
					from MBX_MESSAGE where MESSAGE_ID IN (
														  select MESSAGE_ID from MBX_MESSAGE_HOLD MBXH
														  where WORKFLOW_ID= -1 AND MBXH.MESSAGE_ID IN ( SELECT MESSAGE_ID	FROM MBX_MESSAGE MBXM
																										 WHERE MBXH.MESSAGE_ID=MBXM.MESSAGE_ID AND 
																										 MBXM.CREATED_DATETIME > sysdate - (30/1440) ))</assign>        
    	<assign to="pool">oraclePool</assign>
        <assign to="row_name">row</assign>
        <assign to="query_type">SELECT</assign>
        <assign to="." from="*"></assign>
      </output>
      <input message="inmsg">
	     <assign to="msgIDs" from="DocToDOM(PrimaryDocument)/row" append="true"></assign>	
      </input>
    </operation>
</sequence>
</process>