How to display BDM in table

Dibyajit.Roy · 20 February 2017 13:49

Hi
I use the version 7.3.1 at work hence I am not able to open your BOS file.
I could take a look only after i go back home. Hence it will take some time.

Did you see my above comment. Could try that and see if it helps.

romualdo.s.rs · 20 February 2017 13:56

Yes I saw the previous comment, but as I said I am new in BonitaSoft and I do not have much knowledge in javascript, so I even suggested that you should see this as my file so that you could edit what I think necessary

romualdo.s.rs · 20 February 2017 17:19

I made a script that checks if the information being selected in PostgreSQL is the same as that already in the BDM, but is the reference of the records of my BDM for me in my Log file is appearing and not the information that is what I really need Compare, could you help me with this script?

Log File:

2017-02-20 11:59:43.479 -0300 INFORMAÇÕES: org.bonitasoft Registros BDM: 4
2017-02-20 11:59:43.481 -0300 INFORMAÇÕES: org.bonitasoft Registros Banco de Dados PostgreSQL: 3
2017-02-20 11:59:43.487 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@1c2fa22
2017-02-20 11:59:43.487 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.487 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.487 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@1c2fa22
2017-02-20 11:59:43.487 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.492 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.492 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@1c2fa22
2017-02-20 11:59:43.492 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.492 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.492 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@1c2fa22
2017-02-20 11:59:43.492 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.492 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@1c2fa22
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@1c2fa22
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft IGUAIS
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.493 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.494 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft IGUAIS
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@5bd5369
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.495 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft DIFERENTES
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@d7e68ae8
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO BDM: com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft POSSICAO POSTGRESQL: com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft IGUAIS
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft com.hss.model.TransportadoraPostgreSQL@12d614f6
2017-02-20 11:59:43.496 -0300 INFORMAÇÕES: org.bonitasoft

Script Groovy:
`
import java.util.logging.Logger;
Logger logger= Logger.getLogger(“org.bonitasoft”);

def i = 0;
def x = 0;
def z = transportadorasBanco.size();
def y = listaTransportadoras.size();
logger.info("Registros BDM: "+ z)
logger.info("Registros Banco de Dados PostgreSQL: "+ y)

while (x <= (z - 1)){
while (i <= (y - 1)){
if (transportadorasBanco.get(x).toString().equals(listaTransportadoras.get(i).toString())){
logger.info(“POSSICAO BDM: " +x)
logger.info(“POSSICAO POSTGRESQL: " +i)
logger.info(“IGUAIS”)
logger.info(transportadorasBanco.get(x).toString())
logger.info(listaTransportadoras.get(i).toString())
logger.info(””)
}
else {
logger.info(“POSSICAO BDM: " +x)
logger.info(“POSSICAO POSTGRESQL: " +i)
logger.info(“DIFERENTES”)
logger.info(transportadorasBanco.get(x).toString())
logger.info(listaTransportadoras.get(i).toString())
logger.info(””)
}
i++;
}
x++;
i = 0;
}`

I know that comparing the references of these records will not advance me because whenever the process starts the references both the pull of PostgreSQL and what I just added in BDM will be the same, so I need to be able to compare the code of the carrier for example.

If you can help me with that, I thank you very much.

regards

Romualdo Santos

Dibyajit.Roy · 20 February 2017 18:33

Hi
Its late here. I am not able to go through the .BOS file that you uploaded.
I have not worked with different databases . I mostly use same database but different tables.
I am sure you can figure out a way to fetch data from PostgreSQL into your form/Page.
If you can do that then you might just compare the values from 2 different records .
I believe that all API rest calls retrieve JSON data.
You seem to fetch the data from PostgreSQL inside a pool variable.
There was a tutorial on how to display records from Pool variables inside a designer page.
I believe it was something like myVariable.value(). ( Pls double check on that).
Well here is a sample script that I had used to compare 2 different sets of JSON records.

if ($data.result && $data.result.length)
{
var arr = ;

var j=0;

for (var i = 0; i < $data.result.length; i++) 
{
    var projCat = $data.result[i];
      
    if(projCat.projectCategory == $data.formInput.category &&  projCat.wbsType == $data.formInput.wbsType1)
    {
        arr[j++] = projCat.investArea;
    }
    
    //var uniqueSet = new Set(arr); // {"a", "b"}
    //var uniqueArr = Array.from(uniqueSet); // ["a", "b"]
}

var uniqueSet = new Set(arr); // {"a", "b"}
var uniqueArr = Array.from(uniqueSet); // ["a", "b"]

return uniqueArr;

}

Sean_McP · 20 February 2017 21:24

for all:

A Tip on displaying CODE/LOGS correctly in Posts:

Do not use the Supplied Buttons above, for some reason they refuse to work correctly, and despite bringing it to Bonitasofts attention, it’s low priority.

To Show Code/Logs correctly use

< code >
your code/log
< /code >

removing the spaces to allow the showing of code/logs correctly as here:


your code/log

Thanks and regards
Seán

Dibyajit.Roy · 21 February 2017 07:31

Hi
I went through your .BOS file. I think you have done a great job. It was working fine for me.
I have made a small minor adjustments

In the automatic task - Conexão . Keep the connector to postgreSQL but I have to remove all the Operations . The Task was failing because of the Operations.
In the Manual task, I get to see the values from the BDM table - TransportadoraPostgreSQL inside a UI designer table. Here I added a new variable inside the page.
processVariableData - …/API/bpm/caseVariable/{{task.caseId}}/listaTransportadora
this brings the value of the Pool variable.
Inside the page, you could add a text field => make it empty and add {{ processVariableData }} to see the value inside the form (when you run the process).
I found the structure of the processVariableData is different than the BDM API.
Hence we might need o write a special Javascript to compare the values.
If you need, I could share the BOS file

Topic		Replies	Views
How to display BDM records in UI Designer? Q&A	9	3	9 February 2017
Mostrar datos de una variable de procesos de tipo List en una tabla en el UI Designer Q&A	4	10	9 May 2019
Como llamar a una query en el bdm desde UI Designer Bonita BPM 7.1.3 Q&A	5	16	15 March 2018
How to take a table widget and display values in UI designer in bonita bpm 7.0.3? Q&A	10	36	6 October 2016
More general use REST API BDM search Q&A	1	13	15 May 2019

How to display BDM in table

Related topics