101260d97b3ff9f7fa4fe69ec97e0ca38ebcac6a.svn-base 1.14 KB
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
<DBXML type="inqreport" distinct="step_incident.wf_seq_no">

	<TABLE name="Stepincident" status="" central="true" out="inquiry" rname="step_incident">
		<FIELD>WF_ID</FIELD>
		<FIELD>WF_VER</FIELD>
		<FIELD>WF_SEQ_NO</FIELD>
		<FIELD>STEP_ID</FIELD>
		<FIELD>STEP_SEQ_NO</FIELD>
		<FIELD>START_TIME</FIELD>
		<FIELD>END_TIME</FIELD>
		<ORDER>
		</ORDER>
	</TABLE>

	<TABLE name="Transfer" status="" central="false" out="inquiry" join_type="simple">
		<FIELD>WF_ID</FIELD>
		<FIELD>WF_VER</FIELD>
		<FIELD>WF_SEQ_NO</FIELD>
		<FIELD>STEP_ID</FIELD>
		<FIELD>STEP_SEQ_NO</FIELD>
		<FIELD>TRANSFER_CODE</FIELD>
		<FIELD>TRANSFER_ID</FIELD>
		<FIELD>TFR_ACTOR_ID</FIELD>
		<FIELD>OWNER_ACTOR_ID</FIELD>
		<FIELD>STATUS</FIELD>
		<ORDER />
	</TABLE>

	<TABLE name="Actor_incident" status="" central="false" out="inquiry" join_type="simple">
		<FIELD>WF_ID</FIELD>
		<FIELD>WF_VER</FIELD>
		<FIELD>WF_SEQ_NO</FIELD>
		<FIELD>STEP_ID</FIELD>
		<FIELD>STEP_SEQ_NO</FIELD>
		<FIELD>ACTOR_ID</FIELD>
		<FIELD>ACTOR_SEQ_NO</FIELD>
		<FIELD>STATUS</FIELD>
		<ORDER>
		</ORDER>
	</TABLE>

	<SIM />

	<GROUPBY having="">
		<FIELD>step_incident.wf_id</FIELD>
	</GROUPBY>
</DBXML>