Configure a combo box

Configure a combo box

Configure a combo box to get data from a project node or a database.
  1. In
    Project view
    , in
    UI
    , right-click a container and then select
    New
    Data controls
    Combo box
    .
  2. In
    Properties
    , either:
    • Create a dynamic link between the
      Model
       property and a project node. This obtains values of attributes or properties of all direct child nodes.
      For example, select the
      Model
       folder with objects that contain data. For more information, see Project nodes.
    • Create a dynamic link between the
      Model
       property and a database object. This obtains data contained in database tables.
      For example, select an Embedded, ODBC, or InfluxDB database object. For more information, see Database.
    For more information about dynamic links, see Create dynamic links.
  3. (optional) Specify the kind of items to display in the object by setting
    ItemKind
    .
    TIP:
    The
    ItemKind
     property is automatically set with the object or variable type recognized among the child nodes.
    For example, if the model is based on a folder node that contains several instances of a
    Motor
     object type,
    ItemKind
     is automatically set with the reference to the
    Motor
     type. In this case, the values that display are the attributes or properties of different instances (
    Motor1
    ,
    Motor2
    ,
    Motor3
    , and so on).
  4. (optional) In
    Query
    , enter a standard SQL query to filter items obtained from a database or project nodes as specified in
    Model
    .
    For more information, see SQL queries.
    For example: 
    SELECT * FROM Model WHERE SPEED > 40
    SELECT * FROM "DataLogger1" WHERE Speed > 40
  5. (optional) From
    Mode
    , select the combo box variant:
    • Normal
      . Select existing items.
    • Normal with text search
      . Select existing items or enter complete names of existing items.
    • Editable
      . Select existing items or enter complete names of existing items. To create new items, enter new item names.
  6. (optional) Create a dynamic link between
    Selected item
     and the item to be selected by default.
    For more information about dynamic links, see Create dynamic links.
  7. (optional) Set
    Allow deselection
     to
    True
     to enable clearing of selected items in the object.
  8. (optional) In
    Events
    , associate
    Selection changed
     with the
    Refresh
     method.
    The items contained in the object refresh each time you interact with the object.
  9. (optional) Sort items by setting
    Sort order
     and
    Order by
     values.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.