BDM

How to compare two business variables?

I'm selecting a record from an external PostgreSQL Database, and saving the information in my BDM, however I want the BDM records not to be duplicate, I currently have two business variables, one that gets the information from my BDM and another Which receives the records from my external database, I need to compare those variables to add in my BDM only record that are not already contained in it.

How could I do that?

I have the link to my .BOS file if you can help me, I thank you.

How to display BDM in table

I need to display the records that are in my BDM in UI Designer, so far I have only been able to display what is in my process variable, through the following code:
../API/bpm/caseVariable/{{task.caseId}}/listaTransportadoras

However I need to display my BDM records in a table in the UI Designer, how can I do this?

I tried to create an API like this:

../{{context.transportadoras_ref.link}}

And I called the attributes of my BDM like this:

retorno.status

How to display BDM records in UI Designer?

I need to display the records that are in my BDM in UI Designer, so far I have only been able to display what is in my process variable, through the following code:

../API/bpm/caseVariable/{{task.caseId}}/listaTransportadoras

However I need to display my BDM records in a table in the UI Designer, how can I do this?

I tried to create an API like this:

../{{context.transportadoras_ref.link}}

And I called the attributes of my BDM like this:

retorno.status

Is it possible to have two business variables in one just process?

I have two BDMs, each to receive the respective records from different tables, I generated a script that worked perfectly to add the records in a BDM, however if I try to add two Business Variables to my process, I can not save the records in the second BDM , My question at the end is, I can have two business variables in a single pool?

My log Error:

Failed to get information in bdm and used it in operations.

Hi,

I am getting the max value of a certain column in bdm table using custom query with parameter. Then I call the query using DAO and used it in the operations once the manager have approved the task. But when i run the task it always fails. I set the petCashNo to store a new series of pet cash no. Just want to create a petcash series number

This is my custom query

SELECT MAX(p.petCashNo)
FROM PettyCashHeader p
WHERE p.branch = :branch

Return of custom query is single

This is how i call my query in operations

Pass information from a process variable to the attributes of my BDM

I need to save the contents of my process variable to the attributes I created in my BDM, how can I do this?

Link para o arquivo .bos: https://drive.google.com/file/d/0B8aMiLwwVY0nNGtHcXVRVDdaQ0U/view?usp=sh...

How to convert code and id in forms bonita?

Hi,

I need to convert the id and code to name. I save the id and code in my main table instead of the name. But when I display the content of table it shows the id and code. I have tables that handle the equivalent of the code and id. How can i convert it in my UI Designer. Please help. Thanks

Dropdown not showing data from BDM

Hello,

I want to create a Dropdown, that Displays all the data from a Business Data ModelTable called "Customer".
I created a custom querry to get all the IDs (called getAllIDs):
SELECT persistenceId
FROM Customer

On my form I created a variable with the following external API:
../API/bdm/businessData/de.test.model.Customer?q=getAllIDs

In the Dropdown I selected then uses this vaiable in the "Available values" field and I enterd PERSISTENCEID as the "Displayed key".

But I'm still not getting any values!?

How to find the max string length for a BDM class field?

If I have BDM class "com.company.model.MyBDM" with a string field "field1", declared to have a max size of 80 in the business data definition of the studio, how can I determine this max size in groovy connector scripts (or other script types).

In particular: I'd like to be able to add contract constraints to police the max lengths allowed without having to hard-code the length in the BDM definition and all related scripts, constraints and expressions.

I'm pretty sure it has something to do with annotations, but I cant work out the correct syntax.

Many thanks

User Task Not Found Exception using BDM in Bonita ui

I have developed test application using BDM and Bonita ui designer in Bonita BPM Community Edition Version : 7.3.1. I have business object named "BusinessObject1" with one string type name and "namebd" as Business Variables of "BusinessObject1".
In Step1 i created one Input:

formInput | {"nameInput" : {"name" : ""}} | JSON
in step1 operations i added:
namebd steName nameInput.name

Testing
Notifications