- Register a SQL Query, then execute if via a REST CALL (useful in a Form or a Page) - no development
- Handle multiple data sources
- Check performance on execution
- Configure access on each SQL request, one by one
- Simulation mode: if you don't have access to the database on your development platform, use the simulation method
For each query, define an ID, a SQL request, an explanation, a datasource. A Delay can be include in the request, to verify how your form will handle a slow query.
Query can contains parameters : just reference it using the format " :" like select username from user_ where country = :countrycode
Then, give the parameters value in the REST CALL: queryid=12&countrycode=FR
Repository URL : https://github.com/Bonitasoft-Community/page_gasolinetruck