Forum

Obtaining DataCompositionSchema Result

Murat Yazlıyev	#1 May 22, 2013 06:41 AM
Interested Points:: 0 Joined:: Apr 5, 2012	Hi How can I obtain the result of data composition schema in script? In data composition schema there is many data sets, so to create independent query, execute and get the data variant is falling off. Or any exaples for obtaining the result
	Profile

Timofey Bugaevsky	#2 May 22, 2013 07:26 AM
Guest Points:: Joined::	If I understood you correctly, you need to execute your queries separately for debug, right?
	Profile

Murat Yazlıyev

May 22, 2013 10:03 AM

Interested

Points:: 0
Joined:: Apr 5, 2012

No, I think I could not explain what I want to do indeed.

For example:

Code

DataCompositionSchema = Reports.MalzemeSatışları.GetTemplate("MainDataCompositionSchema"); 
Ayarlar = DataCompositionSchema.DefaultSettings; 

Ayarlar = SettingsComposer.Settings; 
DetailsData = New DataCompositionDetailsData; 
ŞablonOluşturucu = New DataCompositionTemplateComposer; 
VİŞŞablonu = ŞablonOluşturucu.Execute(DataCompositionSchema, Ayarlar, DetailsData); 
VİŞİşlemcisi = New DataCompositionProcessor; 
VİŞİşlemcisi.Initialize(VİŞŞablonu,, DetailsData); 
Controls.Result.Clear(); 
SonuçTablosu = Controls.Result; 
SonuçGörüntülemeİşlemcisi = New DataCompositionResultSpreadsheetDocumentOutputProcessor; 
SonuçGörüntülemeİşlemcisi.SetDocument(SonuçTablosu); 
SonuçGörüntülemeİşlemcisi.Output(VİŞİşlemcisi);

In this example the result of data composition schema is outputed in SpreadSheetDocument. But I want to get the result in ValueTable. You may say: "take the query of data composition schema and get the result of the query in ValueTable by using the method "Unload()". This variant not for my situation, because in my data composition schema I have much data sets that related with each other in data set links. So I need to get the result in ValueTable by using data composition schema.

Profile

Murat Yazlıyev

May 22, 2013 01:58 PM

Interested

Points:: 0
Joined:: Apr 5, 2012

Timofey I've solved what I wanted to do. By using DCS, in the end I took ValueTable.

Thanks for everything.

Example code for it, is here:

Code

&AtServer
Procedure VeriGüncelle_AtServer()
   
   // PREPARE SCHEMES OF DATA COMPOSITION AND DCS SETTINGS COMPOSER
   
   // Composition scheme.
   DataCompositionSchema = DataProcessors.HızlıZimmetleme_Dg.GetTemplate("BarkodVerileriŞablonu");
   
   // Prepare composer of data composition template.
   Composer = New DataCompositionSettingsComposer;
   Composer.Initialize(New DataCompositionAvailableSettingsSource(DataCompositionSchema));
   Composer.LoadSettings(DataCompositionSchema.DefaultSettings);
   
   // Compose data composition template.
   DetailsData = New DataCompositionDetailsData; 
   TemplateComposer = New DataCompositionTemplateComposer;
   DataCompositionTemplate = TemplateComposer.Execute(DataCompositionSchema, Composer.Settings,,,Type("DataCompositionValueCollectionTemplateGenerator"));

   VİŞİşlemcisi = New DataCompositionProcessor; 
   VİŞİşlemcisi.Initialize(DataCompositionTemplate,, DetailsData);
   
   SonuçTablosu = New ValueTable; 
   Sonuçİşlemcisi = New DataCompositionResultValueCollectionOutputProcessor;
   Sonuçİşlemcisi.ShowOutputPercent = True;
   Sonuçİşlemcisi.SetObject(SonuçTablosu); 
   Sonuçİşlemcisi.Output(VİŞİşlemcisi, True);
   
EndProcedure // VeriGüncelle_AtServer()

Profile