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

#1
People who like this: 0 Yes / 0 No
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: 0 Yes / 0 No
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: 0 Yes / 0 No
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.

/* --- ФИКС ЗАГОЛОВКОВ ДОКУМЕНТАЦИИ (BRUTE FORCE) --- */ /* Цепляемся за все возможные контейнеры Битрикса */ .content h1, #content h1, .workarea h1, .content h2, #content h2, .workarea h2, .content h3, #content h3, .workarea h3, .content h4, #content h4, .workarea h4, .content h5, #content h5, .workarea h5, .content h6, #content h6, .workarea h6 { display: block !important; font-weight: 700 !important; color: #222 !important; text-transform: none !important; margin-top: 1.5em !important; margin-bottom: 0.5em !important; line-height: 1.2 !important; } /* Явно задаем размеры, чтобы перекрыть "font-size: 100%" */ .content h1, #content h1 { font-size: 28px !important; } .content h2, #content h2 { font-size: 24px !important; } .content h3, #content h3 { font-size: 22px !important; } .content h4, #content h4 { font-size: 20px !important; } .content h5, #content h5 { font-size: 18px !important; } /* Ваш случай (5 решеток) */ .content h6, #content h6 { font-size: 16px !important; } /* Если Битрикс или редактор засунули внутрь h5 тег span или font */ .content h5 *, #content h5 *, .workarea h5 * { font-size: inherit !important; color: inherit !important; font-weight: inherit !important; } /* --- СТИЛИЗАЦИЯ ТЕКСТА (Markdown Style) --- */ /* Ссылки в тексте делаем более заметными */ .content a:not([class]) { color: #005aa0; text-decoration: none; border-bottom: 1px solid rgba(0, 90, 160, 0.2); } .content a:not([class]):hover { border-bottom-color: #005aa0; } /* Списки (чтобы не прилипали) */ .content ul, .content ol { margin-bottom: 15px !important; padding-left: 20px !important; } .content li { margin-bottom: 5px !important; }