Dialoga pro výběr sloupců pro export

Pokud chceme v rámci dialogu vybrat sloupce pro export je toto možné zajistit pomocí parametru IsExportSetting v rámci definice sekce. Následně je potřeba vydefinovat u takových sklopců parametr IsOptional = true a do dotazu přidat attribut a #ADDCOLUMN#

<Section xsi:type="ExportSection" Ident="BasicExportSection"  Title="Export + Acton" IsExportSetting="true" >

          <Settings>

            <dvs:Setting xsi:type="dvs:DetailExportSetting" ExportType="CSV" IsHeader="false" EncodingType="Windows1250" ></dvs:Setting>

            <dvs:Setting xsi:type="dvs:DetailExportSetting" ExportType="TXT" IsHeader="false" Separator="    " ></dvs:Setting>

          </Settings>

          <DataSource>

            <Columns>

              <Column Ident="Ident" Title="Ident" Width="20" ></Column>

              <Column Ident="ID" Title="ID" IsPrimaryKey="true" Width="25"></Column>

              <Column Ident="Email" Title="Email" Width="25"></Column>

              <Column Ident="CreateDate" Title="CreateDate" IsOptional="true" Width="25">

                <SQL>

                  CreateDate

                </SQL>

              </Column>

            </Columns>

            <SQL>

              SELECT TOP 20 ID, Ident, Email #ADDCOLUMN#  FROM usr.PriorityType WHERE [State] in (2,3,4) AND CategoryIdent like ISNULL(@CategoryIdent, CategoryIdent) AND #PERMISSION[PriorityType]# #FILTER#

            </SQL>

            <Parameters>

              <dsp:Parameter xsi:type="dsp:VariableParameter" Ident="CategoryIdent" ConstantType="MenuFolderTreeIdent" DataType="VarChar"MaxLength="900" LikeType="Right" ></dsp:Parameter>

            </Parameters>

          </DataSource>

        </Section>