<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE qml SYSTEM "/wt/query/qml/qml.dtd">
<qml bypassAccessControl="true">
	<parameter name="User Name" type="java.lang.String">
		<parameterDefault isMacro="false">
			mlockwood
		</parameterDefault>
	</parameter>
	<statement>
		<query>
			<select distinct="true" group="false">
				<column alias="User" heading="Subscription Recipient Username" isExternal="false" propertyName="name" selectOnly="false" type="java.lang.String">
					name
				</column>
				<object alias="User" heading="Recipient Full Name" propertyName="fullName">
					<property name="fullName"/>
				</object>
				<object alias="wt.notify.NotificationSubscription" heading="Notification Subscription" propertyName=""/>
				<object alias="wt.notify.NotificationSubscription" heading="Subscription Owner" propertyName="ownership.owner.fullName">
					<property name="ownership">
						<property name="owner">
							<property name="fullName"/>
						</property>
					</property>
				</object>
				<column alias="wt.notify.NotificationSubscription" heading="Subscribed On" isExternal="false" propertyName="createTimestamp" selectOnly="false" type="java.sql.Timestamp">
					thePersistInfo.createStamp
				</column>
			</select>
			<from>
				<table alias="User" isExternal="false">
					wt.org.WTUser
				</table>
				<table alias="wt.notify.NotifySubscriptionRecipient" isExternal="false">
					wt.notify.NotifySubscriptionRecipient
				</table>
				<table alias="wt.notify.NotificationSubscription" isExternal="false">
					wt.notify.NotificationSubscription
				</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="equal"/>
						<operand>
							<parameterTarget name="User Name"/>
						</operand>
					</condition>
				</compositeCondition>
			</where>
			<referenceJoin>
				<join name="subscriberRef">
					<aliasTarget alias="wt.notify.NotifySubscriptionRecipient"/>
					<aliasTarget alias="User"/>
				</join>
				<join name="subscriptionReference">
					<aliasTarget alias="wt.notify.NotifySubscriptionRecipient"/>
					<aliasTarget alias="wt.notify.NotificationSubscription"/>
				</join>
			</referenceJoin>
		</query>
	</statement>
</qml>
