Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Query language and DCS > Necessary to set "Array" in ExtDimensions parameters of Virtual Table Parameters property

Forum

Search UsersRules
Necessary to set "Array" in ExtDimensions parameters of Virtual Table Parameters property
#1
Interested
Points:: 0
Joined:: Apr 5, 2012

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.

Profile
#2
Active user
Points:: 0
Joined:: Mar 20, 2012

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"));

Profile
#3
Guest
Points::
Joined::

I have registered your feature request. Thank you.

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.