This control allows you to query your emakin based relational databases and map them with your form data.
Here are samples;
Simple sample 1:
<Query Name="" Start="0" MaxLength="-1">
<Parameters>
<TargetSchema Type="System.String, mscorlib"><![CDATA[Masraf]]></TargetSchema>
<TargetTable Type="System.String, mscorlib"><![CDATA[MasrafTipiGrubu]]></TargetTable>
</Parameters>
<Columns>
<Column Name="Kod" Formula="None">
</Column>
<Column Name="Text" Formula="None">
</Column>
</Columns>
<Where Condition="And"/>
<Order>
<Order Name="Text" Type="Ascending"/></Order>
<SubQueries/>
</Query>
Simple sample 2:
<Query Name="" Start="0" MaxLength="-1">
<Parameters>
<TargetSchema Type="System.String, mscorlib"><![CDATA[Masraf]]></TargetSchema>
<TargetTable Type="System.String, mscorlib"><![CDATA[MasrafTipi]]></TargetTable>
</Parameters>
<Columns>
<Column Name="Kod" Formula="None">
</Column>
<Column Name="Text" Formula="None">
</Column>
</Columns>
<Where Condition="And">
<Criteria>
<Criteria Name="GrupKodu" Comparison="Equals" Condition="And" Formula="None">
<Value Type="System.String, mscorlib"><![CDATA[{{MasrafTipiGrubu}}]]></Value>
</Criteria>
</Criteria>
</Where>
<Order>
<Order Name="Text" Type="Ascending"/></Order>
<SubQueries/>
</Query>
Advance sample:
<Query Name="" Start="0" MaxLength="-1">
<Parameters>
<TargetSchema Type="System.String, mscorlib"><![CDATA[HR]]></TargetSchema>
<TargetTable Type="System.String, mscorlib"><![CDATA[Ucretler]]></TargetTable>
</Parameters>
<Columns>
<Column Name="Person.Id">
<Properties>
<XPath Type="System.String, mscorlib"><![CDATA[Person/PersonId]]></XPath>
</Properties>
</Column>
<Column Name="Person.DisplayName">
<Properties>
<Caption Type="System.String, mscorlib"><![CDATA[Ad Soyad]]></Caption>
<XPath Type="System.String, mscorlib"><![CDATA[Person/AdSoyad]]></XPath>
</Properties>
</Column>
<Column Name="Durum.Tip">
<Properties>
<XPath Type="System.String, mscorlib"><![CDATA[Durum/Tip]]></XPath>
</Properties>
</Column>
<Column Name="Durum.Ad">
<Properties>
<XPath Type="System.String, mscorlib"><![CDATA[Durum/Ad]]></XPath>
</Properties>
</Column>
<Column Name="ProjePersonel.HizmetTipi.AltProje.Proje.Bolge">
<Properties>
<Caption Type="System.String, mscorlib"><![CDATA[Bölge]]></Caption>
</Properties>
</Column>
<Column Name="ProjePersonel.HizmetTipi.AltProje.Proje.Ad">
<Properties>
<Caption Type="System.String, mscorlib"><![CDATA[Proje]]></Caption>
<XPath Type="System.String, mscorlib"><![CDATA[Person/Proje]]></XPath>
</Properties>
</Column>
<Column Name="ProjePersonel.HizmetTipi.AltProje.Ad">
<Properties>
<Caption Type="System.String, mscorlib"><![CDATA[Alt Proje]]></Caption>
<XPath Type="System.String, mscorlib"><![CDATA[Person/AltProje]]></XPath>
</Properties>
</Column>
<Column Name="ProjePersonel.HizmetTipi.Ad">
<Properties>
<Caption Type="System.String, mscorlib"><![CDATA[Hizmet Tipi]]></Caption>
<XPath Type="System.String, mscorlib"><![CDATA[Person/HizmetTipi]]></XPath>
</Properties>
</Column>
<Column Name="Employee.Organization.Code">
<Properties>
<XPath Type="System.String, mscorlib"><![CDATA[Person/SirketKod]]></XPath>
</Properties>
</Column>
</Columns>
<Where Condition="And">
<Blocks>
<Block Condition="And">
<Criteria>
<Criteria Name="Parent.Durum" Comparison="Equals" Condition="Or">
<Value Type="System.String, mscorlib"><![CDATA[2]]></Value>
</Criteria>
<Criteria Name="Parent.Durum" Comparison="Equals" Condition="Or">
<Value Type="System.String, mscorlib"><![CDATA[]]></Value>
</Criteria>
</Criteria>
</Block>
<Block Condition="And">
<Criteria>
<Criteria Name="Durum" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[1]]></Value>
</Criteria>
<Criteria Name="Brut" Comparison="GreaterThanOrEqualTo" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{Ucret/UcretKucuk}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[0]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="Brut" Comparison="LessThanOrEqualTo" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{Ucret/UcretBuyuk}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[99999]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="OdemeTipi" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{OdemeTipi}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="HesaplamaTipi" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{HesaplamaTipi}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="Employee.Positions.OrganizationUnitPosition.Position.Id" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{Pozisyon}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="ProjePersonel.HizmetTipi.AltProje.Proje.Sirket" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{Sirket/Kod}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="ProjePersonel.HizmetTipi.AltProje.Proje.Id" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{Proje/Id}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="ProjePersonel.HizmetTipi.AltProje.Id" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{AltProje/Id}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="ProjePersonel.HizmetTipi.Id" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{HizmetTipi/Id}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
<Criteria Name="Employee.RegistryNumber" Comparison="Equals" Condition="And">
<Value Type="System.String, mscorlib"><![CDATA[{{SicilNo}}]]></Value>
<Properties>
<IgnoreIfEquals Type="System.String, mscorlib"><![CDATA[]]></IgnoreIfEquals>
</Properties>
</Criteria>
</Criteria>
</Block>
</Blocks>
</Where>
<Order>
<Order Name="Person.DisplayName" Type="Ascending"/></Order>
<SubQueries/>
</Query>