<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE qml SYSTEM "/wt/query/qml/qml.dtd">
<qml bypassAccessControl="true">
	<parameter name="Context Name" type="java.lang.String"/>
	<statement>
		<query>
			<select distinct="true" group="true">
				<column alias="Administrative Domain" heading="csvdomain" isExternal="false" propertyName="name" selectOnly="false" type="java.lang.String">
					name
				</column>
				<object alias="Organization (wt.inf.container.OrgContainer)" heading="OrgContainer" propertyName="organizationName">
					<property name="organizationName"/>
				</object>
				<object alias="Administrative Domain" heading="Context" propertyName="containerName">
					<property name="containerName"/>
				</object>
				<column alias="Access Policy Rule" heading="csvtypeId" isExternal="false" propertyName="selector.typeId" selectOnly="false" type="java.lang.String">
					selector.typeId
				</column>
				<column alias="WTAcl Entry" heading="csvpermission" isExternal="false" propertyName="negative" selectOnly="false" type="boolean">
					negative
				</column>
				<object alias="WTAcl Entry" heading="csvprincipal" propertyName="principalReference.name">
					<property name="principalReference">
						<property name="name"/>
					</property>
				</object>
				<object alias="WTAcl Entry" heading="csvpermissionList" propertyName="permissions">
					<property name="permissions"/>
				</object>
				<column alias="Access Policy Rule" heading="csvstate" isExternal="false" propertyName="selector.stateName" selectOnly="false" type="java.lang.String">
					selector.stateName
				</column>
			</select>
			<from>
				<table alias="Access Policy Rule" isExternal="false">
					wt.access.AccessPolicyRule
				</table>
				<table alias="Administrative Domain" isExternal="false">
					wt.admin.AdministrativeDomain
				</table>
				<table alias="WTAcl Entry" isExternal="false">
					wt.access.WTAclEntry
				</table>
				<table alias="Context" isExternal="false">
					wt.inf.container.WTContainer
				</table>
				<table alias="Organization (wt.inf.container.OrgContainer)" isExternal="false">
					wt.inf.container.OrgContainer
				</table>
			</from>
			<where>
				<compositeCondition type="and">
					<condition>
						<operand>
							<column alias="Context" heading="Context Name" isExternal="false" propertyName="name" selectOnly="false" type="java.lang.String">
								containerInfo.name
							</column>
						</operand>
						<operator type="like"/>
						<operand>
							<parameterTarget name="Context Name"/>
						</operand>
					</condition>
				</compositeCondition>
			</where>
			<orderBy>
				<orderByItem type="asc">
					<columnTarget heading="csvdomain"/>
				</orderByItem>
				<orderByItem type="asc">
					<columnTarget heading="OrgContainer"/>
				</orderByItem>
				<orderByItem type="asc">
					<columnTarget heading="Context"/>
				</orderByItem>
				<orderByItem type="asc">
					<columnTarget heading="csvtypeId"/>
				</orderByItem>
				<orderByItem type="asc">
					<columnTarget heading="csvprincipal"/>
				</orderByItem>
			</orderBy>
			<linkJoin>
				<join name="wt.access.AclEntryLink">
					<aliasTarget alias="Access Policy Rule"/>
					<aliasTarget alias="WTAcl Entry"/>
				</join>
			</linkJoin>
			<referenceJoin>
				<join name="domainRef">
					<aliasTarget alias="Access Policy Rule"/>
					<aliasTarget alias="Administrative Domain"/>
				</join>
				<join name="containerReference">
					<aliasTarget alias="Administrative Domain"/>
					<aliasTarget alias="Context"/>
				</join>
			</referenceJoin>
		</query>
	</statement>
</qml>
