...
PIPEFORCE comes with a reporting framework you can integrate into your applications or you can use them to build your own developer or admin reports.
Such reports can be used to give insights into your data for you and your users insights into your data.
Similar to the forms framework, reports can be created using the low code. This means no in-depth developer knowledge is required.
However, in order to create reports with this reporting framework, it is important that you're familiar with the concept of Command and Pipeline. If not, please follow the link to read more about it and then come back to this guide.
...
To visualize the data of a report, PIPEFORCE uses the library Chart.js. This library provides many different types of charts. You can find live examples on the Chart.js website: https://www.chartjs.org/docs/latest/samples.
Here are some example examples of such charts which that can be used inside PIPEFORCE:
...
As you can see, this pipeline simply returns the data part of the chart configuration also as static array. But since you're already familiar with the concept of commands and pipelines you can probably imagine the power of this: You can now call any appropriate command in order to load data from somewhere, for example from a SQL database, from a REST endpoint or any other data source, convert it into the data structure required by your chart and return it finally in the body.
Lets Let's save this pipeline under the app path where you have stored the reporting configuration before, for example: global/app/myapp/pipeline/piechartdata:
...
As you can see, the command cache.get at the beginning of the pipeline first looks - up an entry in the cache under key report:piechart. In case such an entry exists, the pipeline will be exited exit, and the cache entry will be returned immediately.
...