Production Variant production Product configurator Cross references - robinfeng/beashelp GitHub Wiki

亀叉参考

Navigation: Production > Variant production > Product configurator: help-zahnradCross-references No contents entries on this page Contents As described in the properties of objects, you can assign selection options to a parameter using a cross-reference. This way of defining selection options is particularly useful if you want to access the same selection options in the configurators of multiple items. For example, there could be several sofa types for which the same fabric types can be selected. In order not to have to store the different material types in each configuration structure of each sofa, you can enter these once within a cross-reference. If you then allocate this cross-reference to a parameter, the selection options stored there are available for this parameter.

Cross-reference could be use in the product configurator dropdown- or radiobutton-lists.

A cross-reference is organized as a table with the columns Item, Name and Value. You can also add an image. If an existing reference is selected or a new one is created, a new screen opens.

Reference tab Field Description Reference Reference name Designation Description of Reference Select Enter a data base query (Select-Statement)

Values tab (Only visible if no data base query was defined) Field Description Pos Position-nr. Designation Designation of value Content Value Image Assigned image for current position (Selection screen via right click)

The following is an example for a cross-reference for selecting material for a sofa.

Reference: Fabric type Name: Selection of fabric type

Item Description Contents 10 Blue material MatBlue 20 Red material MatRed

If the configuration structure contains a Material parameter to which the reference Fabric type is allocated, the configurator contains the selections Blue material and Red material . If Blue Material is selected, the value MatBlue would be assigned to the parameter. The Item no. sets the default order for the values.

You can also generate a cross-reference table from an SQL statement. For example, only material types could be displayed that correspond to a specific material group selected in the configurator ( Group parameter from variant).

Generally defined parameters and set-objects can be used. Therefor, however, is to ensure that at the time of use in the product configurator, the values are already assigned.

select itemcode, itemname,'' from oitm where u_gruppe = '[group]'

The Select instruction must return 3 values of type String

  1. Return value (itemcode)
  2. Display name (itemname)
  3. Bitmap incl. directory (not selected)

help-hinweisNote:
When using dropdown lists, it may possibly be useful to suppress the return value from the displayed list. This could be realized via the output formatting of the return value (see beas-Script manual).

select itemcode as itemcode__1, itemname,'' from oitm where u_gruppe = '[Gruppe]'