Obtaining DataCompositionSchema Result

Common questions about 1C:Query language, Query builder tool and Data composition schema

#1
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

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

Edited: Murat Yazlıyev - May 22, 2013 06:42 AM
 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

If I understood you correctly, you need to execute your queries separately for debug, right?

 
#3
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

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 DataCompositionResultSpreadsheetDocumentOutputProc­essor; 
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.

 
#4
People who like this:0Yes/0No
Interested
Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

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()

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.