<?xml version="1.0" encoding="UTF-8"?>

<CDADescriptor>
  <DataSources>
    <Connection id="1" type="metadata.metadata">
      <XmiFile>metadata.xmi</XmiFile>
      <DomainId>steel-wheels</DomainId>
    </Connection>
  </DataSources>
  <DataAccess id="BC_CUSTOMER_W_TER_.BC_CUSTOMER_W_TER_CUSTOMERNAME" connection="1" type="mql" access="public">
    <Name>BC_CUSTOMER_W_TER_.BC_CUSTOMER_W_TER_CUSTOMERNAME</Name>
    <Query><![CDATA[<?xml version="1.0" encoding="UTF-8"?>

<mql>
  <domain_id>steel-wheels/metadata.xmi</domain_id>
  <model_id>BV_ORDERS</model_id>
  <options>
    <disable_distinct>false</disable_distinct>
    <limit>-1</limit>
  </options>
  <selections>
    <selection>
      <view>BC_CUSTOMER_W_TER_</view>
      <column>BC_CUSTOMER_W_TER_CUSTOMERNAME</column>
      <aggregation>NONE</aggregation>
    </selection>
  </selections>
  <constraints/>
  <orders/>
</mql>
]]></Query>
  </DataAccess>
  <DataAccess id="0D66FB5B-A3BC-B4B1-87F9-BB537C7A43C3" connection="1" type="mql" access="public">
    <Name>0D66FB5B-A3BC-B4B1-87F9-BB537C7A43C3</Name>
    <Query><![CDATA[<?xml version="1.0" encoding="UTF-8"?>

<mql>
  <domain_id>steel-wheels/metadata.xmi</domain_id>
  <model_id>BV_ORDERS</model_id>
  <options>
    <disable_distinct>false</disable_distinct>
    <limit>100</limit>
  </options>
  <parameters>
    <parameter defaultValue="" name="F_CAT_ORDERS_BC_ORDERS_ORDERDATE_FROM" type="DATE"/>
    <parameter defaultValue="" name="F_CAT_ORDERS_BC_ORDERS_ORDERDATE_TO" type="DATE"/>
    <parameter defaultValue="" name="F_BC_CUSTOMER_W_TER__BC_CUSTOMER_W_TER_CUSTOMERNAME" type="STRING"/>
  </parameters>
  <selections>
    <selection>
      <view>BC_CUSTOMER_W_TER_</view>
      <column>BC_CUSTOMER_W_TER_TERRITORY</column>
      <aggregation>NONE</aggregation>
    </selection>
    <selection>
      <view>BC_CUSTOMER_W_TER_</view>
      <column>BC_CUSTOMER_W_TER_CREDITLIMIT</column>
      <aggregation>NONE</aggregation>
    </selection>
    <selection>
      <view>BC_CUSTOMER_W_TER_</view>
      <column>BC_CUSTOMER_W_TER_CITY</column>
      <aggregation>NONE</aggregation>
    </selection>
  </selections>
  <constraints>
    <constraint>
      <operator>AND</operator>
      <condition>[CAT_ORDERS.BC_ORDERS_ORDERDATE] > [param:F_CAT_ORDERS_BC_ORDERS_ORDERDATE_FROM]</condition>
    </constraint>
    <constraint>
      <operator>AND</operator>
      <condition>[CAT_ORDERS.BC_ORDERS_ORDERDATE] < [param:F_CAT_ORDERS_BC_ORDERS_ORDERDATE_TO]</condition>
    </constraint>
    <constraint>
      <operator>AND</operator>
      <condition>OR(IN([BC_CUSTOMER_W_TER_.BC_CUSTOMER_W_TER_CUSTOMERNAME]; [param:F_BC_CUSTOMER_W_TER__BC_CUSTOMER_W_TER_CUSTOMERNAME]);EQUALS(""; [param:F_BC_CUSTOMER_W_TER__BC_CUSTOMER_W_TER_CUSTOMERNAME]))</condition>
    </constraint>
  </constraints>
  <orders/>
</mql>
]]></Query>
    <Columns>
      <Column idx="0">
        <Name>Territory</Name>
      </Column>
      <Column idx="1">
        <Name>Credit Limit</Name>
      </Column>
      <Column idx="2">
        <Name>City</Name>
      </Column>
    </Columns>
    <Parameters>
      <Parameter name="F_CAT_ORDERS_BC_ORDERS_ORDERDATE_FROM" type="Date" pattern="dd.mm.yyyy" default=""/>
      <Parameter name="F_CAT_ORDERS_BC_ORDERS_ORDERDATE_TO" type="Date" pattern="dd.mm.yyyy" default=""/>
      <Parameter name="F_BC_CUSTOMER_W_TER__BC_CUSTOMER_W_TER_CUSTOMERNAME" type="StringArray" pattern="" default=""/>
    </Parameters>
  </DataAccess>
</CDADescriptor>