Necessary to set "Array" in ExtDimensions parameters of Virtual Table Parameters property

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,

In query for virtual parameters for accounting register tables there is a parameter named "ExtDimensions".

Now this parameter can take only one value (for example, exactly one type of chartofcharacteristics). We need this parameter must take Array or ValueList. Because in Turkey Uniform Chart Of Accounts is containing 999 account.

The logic of using Extra Dimensions is perfect. For that we use extra dimension in many accounts. In this case some times we need to take general ledger. It will be optimal if "ExtDimensions" could take Array type or ValueList type.

 
#2
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Mar 20, 2012
Company: Abaco Soluciones S.A.

Hello. This parameter can take an array. If you need to use it in data composition scheme you can tick the flag "List of values is available" on the page "Parameters" of scheme.
In the code I use the function like this:

Code
Function GetExtDimensions(ExtDimDesctiption)
   Struct = New Structure(ExtDimDescription);
   Result = New Array;
   For Each Elem In Struct Do
      Result.Add(ChartsOfCharacteristicTypes.ExtDimensionsTypes[Elem.Key]);
   EndDo;
   Return Result;
EndFunction


You can use it like this:
Code
Query.SetParameter("ExtDim", GetExtDimensions("Stock,Nomenclatura"));

 
#3
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

I have registered your feature request. Thank you.

 
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.