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

Drop down list datasource

The file facilitating the definition of drop-down lists is called ComboDefinition. Its main goal is to define sets of values for drop-down lists and make them reusable.

Location in the system

Its physical location is in the ComboDefinitions folder. The ComboDefinition always occurs as a reference, it cannot be used in itself. Its location within the system is shown in the following figure:

ComboBox relationships

Available features

  • Datasource definition
  • Definition of values and display fields

Datasource definition

Example:

<ComboDefinition xmlns="http://effector.hu/schema/ns/ComboDefinition">
    <SourceType>Database</SourceType>
    <Source>
        <Database>
            <SelectionString><![CDATA[
                SELECT [PeopleID], [Name] 
                FROM [People] WITH(NOLOCK)
                WHERE [Deleted] = 0 
                    AND [IsGroup] = 0
                    AND 1=1
                ORDER BY [Name] ASC
            ]]></SelectionString>
            <KeyColumn>PeopleID</KeyColumn>
            <ValueColumn>Name</ValueColumn>
        </Database>
    </Source>
</ComboDefinition>

<ComboDefinition xmlns="http://effector.hu/schema/ns/ComboDefinition">
    <SourceType>XML</SourceType>
    <Source>
        <FixedValues>
            <Value key="1">alma</Value>
            <Value key="2">korte</Value>
        </FixedValues>
    </Source>
</ComboDefinition>

For the datasource definition two nodes can be used, one of them defines the type of the relationship, while the other specifies the SELECT statement.

  • SourceType: The type of the relationship maybe Database or XML.
  • Source: in case of a SourceType=Database a SELECT statement runs a query on the list of values. In the WHERE clause, it is advisable to sort the data and insert the 1=1 expression for a later filtering. The system will replace this 1=1 condition with the appropriate filter expression. The SELECT statement must have at least two fields.

Definition of value and display fields

One of the two fields queried by a select statement represents the value of the ComboBox, while the other signifies the description to be displayed. In the ComboBox, a list of key-value pairs is displayed.

Available nodes:

  • KeyColumn: A value (key) representing one row of the ComboBox.
  • ValueColumn: A displayable field related to the key.

  • Last update: 46 weeks 5 days ago
  • Effector