Effector 6.3 developer manual

XML reference 6.3

Effector Studio 6.3 summary

Effector Studio 6.3 manual

Effector 6.2 developer manual

XML reference 6.0

Effector Studio 3.2 summary

Effector Studio 3.2 manual

ComboDefinition

XML containing the definition of a drop-down list.

/ComboDefinition

/ComboDefinition/SourceType

The type of the data source. Its possible values:

  • Database: uploads the key-value pairs from a database
  • XML: the key-value parts must be given here

/ComboDefinition/Source

The key-value pairs` source must be given here.

/ComboDefinition/Source/Database

If the value of SourceType is Database, it's a mandatory node.

/ComboDefinition/Source/Database/SelectionString

SQL command, that makes an inquiry for the value list in the form of a key/value pair. It makes sense to write “1=1” in the WHERE condition, so that afterwards we can further filter the value list. Further information about this matter can be found in the Edit screen chapter.

/ComboDefinition/Source/Database/KeyColumn

A value representing a row of the ComboBox. Specifying it is mandatory in case of a Database source type.

/ComboDefinition/Source/Database/KeyColumnDefinition

SQL definition of a value representing a row of the ComboBox without alias. Specifying it is possible in case of a Database source type.

/ComboDefinition/Source/Database/ValueColumn

Field applicable for the display belonging to the key. Specifying it is mandatory in case of a Database source type.

The KeyColumn and ValueColumn values need to be present in the SelectionString (in the field listing).

/ComboDefinition/Source/Database/CssClassColumn

The field containing the name of custom CSS class of the list item. Specifying it is possible in case of a Database source type.

You can set the CSS class for each element in the drop-down list, so you can color the elements. The CSS classes must be defined in the delivery/gfx/style.css file.

/ComboDefinition/Source/FixedValues

Collection used for the definition of an XML type ComboDefinition. The definition of the set of values is in the form of key/value pairs.

/ComboDefinition/Source/FixedValues/Value

An element of the set of values. The definition of at least one node is mandatory.

Attributes:

  • key: Mandatory. The key part of the key/value pair.
  • cssClass: Optional. Custom CSS class of the list item.

Example

Example

<?xml version="1.0" encoding="utf-8"?> <ComboDefinition xmlns="http://effector.hu/schema/ns/combodefinition"> <SourceType>Database / XML</SourceType> <Source> <Database> <SelectionString> <![CDATA[ SELECT LookupListID AS [ID], LookupValue, TechnicalName FROM dbo.FSYS_LookupList WITH(NOLOCK) WHERE GroupNum = '[##Filter.GroupNum##]' AND 1=1 ORDER BY LookupValue ]]> </SelectionString> <KeyColumn>ID</KeyColumn> <KeyColumnDefinition>LookupListID</KeyColumnDefinition> <ValueColumn>LookupValue</ValueColumn> <CssClassColumn>TechnicalName</CssClassColumn> </Database> <FixedValues> <Value key="1" cssClass="red_class">alma</Value> <Value key="2" cssClass="yellow_class">körte</Value> </FixedValues> </Source> </ComboDefinition>

  • Last update: 2 weeks 5 days ago
  • Effector