Skip to main content
Skip table of contents

Query and template configuration

This page explains the operating principle and the configuration of Connected items.

Principle

As explained before, the values of a Connected item are generated in 2 steps:

  1. A query in the external datasource, the output is a result set
  2. A template is applied on each row of the result set, the output is
    • a list of options - in case of a Connected item of type "Text - Select list"
    • a text string - in case of a Connected item of type "Text - Read only"

Performance

  • For performance purposes, Elements Connect will only read the first 1,000 rows of a result set. To access the subsequent row, use the userInput parameter
  • A 5-minute, non-configurable, cache for the datasource exists. Identical queries will fetch the Connected item values directly in the cache

Datasource type

The query and template item configuration is different if a SQL or REST API datasource is used

What's next

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.