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

<CDADescriptor>
  <DataSources>
    <Connection id="1" type="metadata.metadata">
      <XmiFile>metadata.xmi</XmiFile>
      <DomainId>test/metadata.xmi</DomainId>
    </Connection>
  </DataSources>
  <DataAccess id="0860D033-AA50-EA62-8297-3432D04F3B0F" connection="1" type="mql" access="public">
    <Name>0860D033-AA50-EA62-8297-3432D04F3B0F</Name>
    <Query><![CDATA[<?xml version="1.0" encoding="UTF-8"?>

<mql>
  <domain_id>test/metadata.xmi</domain_id>
  <model_id>BV_MODEL_1</model_id>
  <options>
    <disable_distinct>false</disable_distinct>
    <limit>-1</limit>
  </options>
  <parameters>
    <parameter defaultValue="" name="F_CT_CATEGORY1_BC_TEST_YEAR_ID" type="NUMERIC"/>
  </parameters>
  <selections>
    <selection>
      <view>CT_CATEGORY1</view>
      <column>BC_TEST_YEAR_ID</column>
      <aggregation>NONE</aggregation>
    </selection>
  </selections>
  <constraints>
    <constraint>
      <operator>AND</operator>
      <condition>OR(IN([CT_CATEGORY1.BC_TEST_YEAR_ID]; [param:F_CT_CATEGORY1_BC_TEST_YEAR_ID]);EQUALS(""; [param:F_CT_CATEGORY1_BC_TEST_YEAR_ID]))</condition>
    </constraint>
  </constraints>
  <orders/>
</mql>
]]></Query>
    <Columns>
      <Column idx="0">
        <Name>Year id</Name>
      </Column>
    </Columns>
    <Parameters>
      <Parameter name="F_CT_CATEGORY1_BC_TEST_YEAR_ID" type="NumericArray" pattern="" default=""/>
    </Parameters>
  </DataAccess>
  <DataAccess id="CT_CATEGORY1.BC_TEST_YEAR_ID" connection="1" type="mql" access="public" cache="true">
    <Name>CT_CATEGORY1.BC_TEST_YEAR_ID</Name>
    <Query><![CDATA[<?xml version="1.0" encoding="UTF-8"?>

<mql>
  <domain_id>test/metadata.xmi</domain_id>
  <model_id>BV_MODEL_1</model_id>
  <options>
    <disable_distinct>false</disable_distinct>
    <limit>-1</limit>
  </options>
  <selections>
    <selection>
      <view>CT_CATEGORY1</view>
      <column>BC_TEST_YEAR_ID</column>
      <aggregation>NONE</aggregation>
    </selection>
  </selections>
  <constraints/>
  <orders>
    <order>
      <direction>ASC</direction>
      <view_id>CT_CATEGORY1</view_id>
      <column_id>BC_TEST_YEAR_ID</column_id>
      <aggregation>NONE</aggregation>
    </order>
  </orders>
</mql>
]]></Query>
  </DataAccess>
</CDADescriptor>