<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE qml SYSTEM "/wt/query/qml/qml.dtd">
<qml bypassAccessControl="false">
	<parameter name="username" type="java.lang.Object"/>
	<statement>
		<query>
			<select distinct="false" group="false">
				<object alias="User" heading="Full Name" propertyName="fullName">
					<property name="fullName"/>
				</object>
				<object alias="User" heading="EMail" propertyName="EMail">
					<property name="EMail"/>
				</object>
				<object alias="EPMWorkspace" heading="EPMWorkspace" propertyName=""/>
				<column alias="User" heading="User ID" isExternal="false" propertyName="persistInfo.objectIdentifier.id" selectOnly="false" type="long">
					thePersistInfo.theObjectIdentifier.id
				</column>
			</select>
			<from>
				<table alias="EPMWorkspace" isExternal="false">
					wt.epm.workspaces.EPMWorkspace
				</table>
				<table alias="User" isExternal="false">
					wt.org.WTUser
				</table>
			</from>
			<where>
				<compositeCondition type="and">
					<condition>
						<operand>
							<column alias="User" heading="Name" isExternal="false" propertyName="name" selectOnly="false" type="java.lang.String">
								name
							</column>
						</operand>
						<operator type="like"/>
						<operand>
							<parameterTarget name="username"/>
						</operand>
					</condition>
				</compositeCondition>
			</where>
			<orderBy>
				<orderByItem type="asc">
					<columnTarget heading="User ID"/>
				</orderByItem>
			</orderBy>
			<referenceJoin>
				<join name="principalReference">
					<aliasTarget alias="EPMWorkspace"/>
					<aliasTarget alias="User"/>
				</join>
			</referenceJoin>
		</query>
	</statement>
</qml>
