Thanks for the great video, it really helps with the learning process! I have an issue where I have spend a few hours looking around and trying different things but still can't get it to work and I'd appreciate some input. I have a form with 2 fields, an editable numeric field (customer_id) and a read-only text field (customer_name). What I need is that when the numeric field is edited (debounced), I need to fetch the customer details from an external database (a CRM) by using the customer_id value as the filter on the select query. In your video you are fetching all cases and while this would work, I want it to fetch only the requested customer so I'm not affected by the increasing number of customers in the database. Do note I'm talking about an SQL database (I'm guessing a REST API would not be much different). Is this possible? Or maybe make a custom widget which will use the Bonita REST API to execute the query (by running it as a service activity)? Is my thinking flawed and I have to keep an up-to-date copy of all customers in Bonita BDM and fetch it from there? Kinda lost here... update: Playing around with REST API extensions now and making some progress. Will update again. ref: documentation.bonitasoft.com/bonita/latest/api/rest-api-extensions update2: Yup, REST API extensions is the way to go, as pointed out by Alejandro. Works like a charm and the debounce property allows you to set the delay for querying the remote database, so you don't storm it with requests while the user is typing the ID.
Hello! Indeed, I was going to suggest using a API Extension to handle the SQL Query, you can use this example in the Community for inspiration: community.bonitasoft.com/t/data-source-rest-api-extension/26157 Then with that, you just need to use the customer_id parameter in a API. With the UID, all API calls are executed when the context change, so you'll automatically have the result of the requested ID. Hope it helps, and let me know if you found any more issues
@@AlejandroRondon-Bonitasoft Hey, I managed to get it working with a REST API Extension and works fine. Appreciate for replying and providing the community example!
Hello! As answered in another comment, I'll also reply to this one. The purpose of these videos is not to provide a comprehensive tutorial on how to develop each type of application. Rather, they are intended to inspire and showcase various use cases that can be achieved with Bonita. If you're looking to create a Bonita application from scratch, I recommend checking out this additional video ruclips.net/video/K5wrh7C_-Ko/видео.html , which provides a deeper understanding of the development process in Bonita. For further learning, I also suggest exploring the following training opportunities: Bonita Camp - www.bonitasoft.com/news/bonita-camp-available-on-demand Bonita Certification (available to Bonitasoft customers) - www.bonitasoft.com/bonitasoft-trainings-and-certifications I hope this information proves helpful!
@@AlejandroRondon-Bonitasoft Thank you Sir for your response but I rely interested to deeply understand /learn bonita so Could you help me any tutorial documents you have and can I get any opportunity to learn bonita
@@AlejandroRondon-Bonitasoft when I saw video tutorial for your bonita connect to external postgre database and still I try to connect but still now does not connected for me .please help me how to connect from the beginning . Thank you!!!
Dear sir firstly thank you to support your video tutorial but for me I need The full tutorial of this video from the beginning Thank you @Alejandro Rondon
Hello! Thank you for the question! The purpose of these videos is not to provide a comprehensive tutorial on how to develop each type of application. Rather, they are intended to inspire and showcase various use cases that can be achieved with Bonita. If you're looking to create a Bonita application from scratch, I recommend checking out this additional video ruclips.net/video/K5wrh7C_-Ko/видео.html , which provides a deeper understanding of the development process in Bonita. For further learning, I also suggest exploring the following training opportunities: Bonita Camp - www.bonitasoft.com/news/bonita-camp-available-on-demand Bonita Certification (available to Bonitasoft customers) - www.bonitasoft.com/bonitasoft-trainings-and-certifications I hope this information proves helpful!
Thanks for the great video, it really helps with the learning process! I have an issue where I have spend a few hours looking around and trying different things but still can't get it to work and I'd appreciate some input.
I have a form with 2 fields, an editable numeric field (customer_id) and a read-only text field (customer_name).
What I need is that when the numeric field is edited (debounced), I need to fetch the customer details from an external database (a CRM) by using the customer_id value as the filter on the select query. In your video you are fetching all cases and while this would work, I want it to fetch only the requested customer so I'm not affected by the increasing number of customers in the database. Do note I'm talking about an SQL database (I'm guessing a REST API would not be much different).
Is this possible? Or maybe make a custom widget which will use the Bonita REST API to execute the query (by running it as a service activity)? Is my thinking flawed and I have to keep an up-to-date copy of all customers in Bonita BDM and fetch it from there? Kinda lost here...
update: Playing around with REST API extensions now and making some progress. Will update again. ref: documentation.bonitasoft.com/bonita/latest/api/rest-api-extensions
update2: Yup, REST API extensions is the way to go, as pointed out by Alejandro. Works like a charm and the debounce property allows you to set the delay for querying the remote database, so you don't storm it with requests while the user is typing the ID.
Hello!
Indeed, I was going to suggest using a API Extension to handle the SQL Query, you can use this example in the Community for inspiration: community.bonitasoft.com/t/data-source-rest-api-extension/26157
Then with that, you just need to use the customer_id parameter in a API. With the UID, all API calls are executed when the context change, so you'll automatically have the result of the requested ID.
Hope it helps, and let me know if you found any more issues
@@AlejandroRondon-Bonitasoft Hey, I managed to get it working with a REST API Extension and works fine. Appreciate for replying and providing the community example!
how to create bonita app from the beginning and how to connect external database step by step
Hello!
As answered in another comment, I'll also reply to this one.
The purpose of these videos is not to provide a comprehensive tutorial on how to develop each type of application. Rather, they are intended to inspire and showcase various use cases that can be achieved with Bonita.
If you're looking to create a Bonita application from scratch, I recommend checking out this additional video ruclips.net/video/K5wrh7C_-Ko/видео.html , which provides a deeper understanding of the development process in Bonita.
For further learning, I also suggest exploring the following training opportunities:
Bonita Camp - www.bonitasoft.com/news/bonita-camp-available-on-demand
Bonita Certification (available to Bonitasoft customers) - www.bonitasoft.com/bonitasoft-trainings-and-certifications
I hope this information proves helpful!
@@AlejandroRondon-Bonitasoft Thank you Sir for your response but I rely interested to deeply understand /learn bonita so Could you help me any tutorial documents you have and can I get any opportunity to learn bonita
@@AlejandroRondon-Bonitasoft when I saw video tutorial for your bonita connect to external postgre database and still I try to connect but still now does not connected for me .please help me how to connect from the beginning . Thank you!!!
Dear sir firstly thank you to support your video tutorial but for me I need The full tutorial of this video from the beginning Thank you @Alejandro Rondon
Hello!
Thank you for the question!
The purpose of these videos is not to provide a comprehensive tutorial on how to develop each type of application. Rather, they are intended to inspire and showcase various use cases that can be achieved with Bonita.
If you're looking to create a Bonita application from scratch, I recommend checking out this additional video ruclips.net/video/K5wrh7C_-Ko/видео.html , which provides a deeper understanding of the development process in Bonita.
For further learning, I also suggest exploring the following training opportunities:
Bonita Camp - www.bonitasoft.com/news/bonita-camp-available-on-demand
Bonita Certification (available to Bonitasoft customers) - www.bonitasoft.com/bonitasoft-trainings-and-certifications
I hope this information proves helpful!