Many questions
Hello everyone,
I'm New to bonita and would know if some actions are possible within community edition.
1. Get an autocomplete in a form, from a sql connector.
2. Some input are linked to child tables based on first autocomplete but needs some sql calls
3. IS it possible to make multiple calls on connector directly from the form?
Thanks
Hi Jeremy,
Get an autocomplete in a form, from a sql connector.
Database connector (and connector in general) are designed to do backend interactions. If you need to expose data in your frontend (UI Designer page or other), you can:
- Plug an existing external service that returns your data if it exists
- Use a database connector in a process and copy the data to Bonita using the BDM, once stored in the BDM you'll have access to data through generic (REST endpoints)[https://api-documentation.bonitasoft.com/latest/#tag/BusinessDataQuery/o...
- Implement a custom REST API Extension that queries your database and return a json response (An old demo project)
Then UID has a simple autocomplete widget out of the box (client side only, it won't make a request at each stroke). But you can implement your own custom widget in the UID using AngularJS.
Is it possible to make multiple calls on connector directly from the form?
No, connectors cannot be executed from an API call in the frontend. They must be executed by a process. The frontend can interact with processes starting new cases or executing tasks. Then the execution in the backend is asynchronous.
HTH
Romain