Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

This control allows you to query your emakin based relational databases and map them with your form data.

Here is a quick 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>

  • No labels