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:
- A query in the external datasource, the output is a result set
- 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
- By default, a 5-minute cache for the datasource exists. Cache is configurable at datasource level and field level. 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