Composer Online offers the capability to retrieve data from a data source and optimize the composition and generation of reports. This is achieved through the use of specialized elements that establish a connection between Composer Online and the data source.
The central element in this process is the Collection Container
which serves two purposes:
- enables the retrieval of data from the source;
- allows for the configuration of the data retrieval process until all the desired values are displayed.
When dragging the Collection Container into the editor, the associated collection, from which the data will be retrieved, is identified in the Data tab.
This means that all data placed within the current collection container will be retrieved from the specified entity. The root collection container added in the editor corresponds to the entity selected during template creation.
Dynamic elements cannot be placed independently in the template body. Instead, they must be placed into the Collection Container or within other container-like elements such as Current User Container, Table Container, or Aggregation. Once a dynamic element is placed inside a container, the field from which the data should be retrieved becomes available for configuration in the Data tab.
In cases where entities in the database are related, the collection container can be used to access these connected entities, even if they differ from the main template entity.
To reach the connected entity, the collection container should be nested inside the previously added collection container. In the Data tab, the desired related entity should be specified.
Afterward, any dynamic elements placed within the new collection container can be used to retrieve data from the newly selected entity.
If the relationship between entities is one-to-many, the collection container allows for the retrieval of multiple values. This feature, known as "a cycle," retrieves all available values within the chosen conditions until all the results are displayed. The retrieval of dynamic data may result in the creation of additional pages in the final document.
Filters can be applied to Collection Containers by selecting the container and setting the corresponding filter in the Data tab.
It is possible to configure which elements should be displayed using the collection container. There are two settings available:
- Selecting the starting element, determining the position of the element within the collection. This element will always appear first during the data retrieval process.
- Selecting the total quantity of elements to be displayed in the report.