<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE qml SYSTEM "/wt/query/qml/qml.dtd">
<qml bypassAccessControl="true">
	<statement>
		<query>
			<select distinct="false" group="false">
				<column alias="WTChangeRequest2" heading="ECR No." isExternal="false" propertyName="number" selectOnly="false" type="java.lang.String">
					number
				</column>
				<object alias="WTChangeRequest2" heading="Creator" propertyName="creatorName">
					<property name="creatorName"/>
				</object>
				<object alias="WTChangeRequest2" heading="Context" propertyName="container.name">
					<property name="container">
						<property name="name"/>
					</property>
				</object>
				<function heading="ECR Cycle Time" name="TIME_DIFFERENCE_IN_DAY" type="java.math.BigDecimal">
					<column alias="WTChangeRequest2" heading="WTChangeRequest2 Resolution Date" isExternal="false" propertyName="resolutionDate" selectOnly="false" type="java.sql.Timestamp">
						resolutionDate
					</column>
					<column alias="WTChangeRequest2" heading="WTChangeRequest2 Created" isExternal="false" propertyName="createTimestamp" selectOnly="false" type="java.sql.Timestamp">
						thePersistInfo.createStamp
					</column>
				</function>
				<column alias="WTChangeRequest2" heading="Track" isExternal="false" propertyName="complexity" selectOnly="false" type="wt.change2.Complexity">
					theComplexity
				</column>
				<column alias="Change Order (wt.change2.WTChangeOrder2)" heading="ECO No." isExternal="false" propertyName="number" selectOnly="false" type="java.lang.String">
					number
				</column>
				<function heading="ECR to ECO" name="TIME_DIFFERENCE_IN_DAY" type="java.math.BigDecimal">
					<column alias="Change Order (wt.change2.WTChangeOrder2)" heading="Created" isExternal="false" propertyName="createTimestamp" selectOnly="false" type="java.sql.Timestamp">
						thePersistInfo.createStamp
					</column>
					<column alias="WTChangeRequest2" heading="Created" isExternal="false" propertyName="createTimestamp" selectOnly="false" type="java.sql.Timestamp">
						thePersistInfo.createStamp
					</column>
				</function>
				<object alias="Changeable" heading="Identity" propertyName="identity">
					<property name="identity"/>
				</object>
			</select>
			<from>
				<table alias="WTChangeRequest2" isExternal="false">
					wt.change2.WTChangeRequest2
				</table>
				<table alias="Change Order (wt.change2.WTChangeOrder2)" isExternal="false">
					wt.change2.WTChangeOrder2
				</table>
				<table alias="Change Activity2" isExternal="false">
					wt.change2.ChangeActivity2
				</table>
				<table alias="Changeable" isExternal="false">
					wt.change2.Changeable2
				</table>
			</from>
			<where>
				<compositeCondition type="and">
					<condition>
						<operand>
							<column alias="WTChangeRequest2" heading="Number" isExternal="false" propertyName="number" selectOnly="false" type="java.lang.String">
								number
							</column>
						</operand>
						<operator type="notLike"/>
						<operand>
							<constant heading="GAGE*" isMacro="false" type="java.lang.Object">
								GAGE*
							</constant>
						</operand>
					</condition>
					<condition>
						<operand>
							<column alias="WTChangeRequest2" heading="Number" isExternal="false" propertyName="number" selectOnly="false" type="java.lang.String">
								number
							</column>
						</operand>
						<operator type="like"/>
						<operand>
							<constant heading="ECR-*" isMacro="false" type="java.lang.Object">
								ECR-*
							</constant>
						</operand>
					</condition>
					<condition>
						<operand>
							<column alias="WTChangeRequest2" heading="State" isExternal="false" propertyName="lifeCycleState" selectOnly="false" type="wt.lifecycle.State">
								state.state
							</column>
						</operand>
						<operator type="notLike"/>
						<operand>
							<constant heading="CANCELLED" isMacro="false" type="wt.lifecycle.State">
								CANCELLED
							</constant>
						</operand>
					</condition>
				</compositeCondition>
			</where>
			<orderBy>
				<orderByItem type="asc">
					<columnTarget heading="ECO No."/>
				</orderByItem>
			</orderBy>
			<linkJoin>
				<join name="wt.change2.AddressedBy2">
					<aliasTarget alias="WTChangeRequest2"/>
					<aliasTarget alias="Change Order (wt.change2.WTChangeOrder2)"/>
				</join>
				<join name="wt.change2.IncludedIn2">
					<aliasTarget alias="Change Order (wt.change2.WTChangeOrder2)"/>
					<aliasTarget alias="Change Activity2"/>
				</join>
				<join name="wt.change2.AffectedActivityData">
					<aliasTarget alias="Changeable"/>
					<aliasTarget alias="Change Activity2"/>
				</join>
			</linkJoin>
		</query>
	</statement>
</qml>
