#database

We are using Bonita 7.6.1 with MySQL, and recently realised that the date fields/data are stored as character string/varchar inside the business database? How do we do date-based queries on the business database now?

Anyone has faced/solved this issue please reply.

Hello everyone, how to upload excel file format (xls or csv) to database in bonita?

Hello Everyone,

Currently im having an issue with my table row. almost all of my table row filled with null. Does anybody here ever experienced this problem? what are the solution to overcome this? and what makes the row filled with null by itself? Here I give you screenshot of my table.
https://www.dropbox.com/s/27cvjfaiky1667i/row%20terisi%20null.PNG?dl=0

Hi,

we are using bonita bpm community edition 7.7.4 with an oracle 12c enterprise database.
We started with a fresh user schema, but after a few weeks of usage the error occured the first time.

Right now bonita tries to extend the lobsegment area by ~ 5GB of data... which is (even with the autoextend options) not possible...

We have removed all active process instances, but the problem still comes up...

Anyone has or had the same problem or can anyone tell me where to find the data, which our bonita node tries to write into the database?

My customer security requirements wont allow their data to be hosted off site.
Can the application and data be deployed/hoted locally?

I want to get data from the database and display it on the WEB screen table.

However, although it seems to use DB connector for the entrance connector, I do not know what to do in "definition of output operation".

Can you tell me what to do?

I'm using Bonita 7.6.1 with Mysql 5.7.

How to avoid usage of XA data source/connector when both Bonita and business databases in the same host. I've seen the non-XA datasources defined somewhere in the configuration, but I couldn't find where to specify it, so that Bonita will use the non-XA data sources.

In the documentation you have given quite difficult approach to connect to any database. Please provide some easy way to do the same thing.

I have five filter fields in my application home page (dashboard -> where I am showing all the records from h2 DB) now I want to filter the records on these fields basis.
It may require 31 (2^5 -1) queries, some are already provided as default queries.

Isn't there a way to write a dynamic query in "custom queries" or somewhere to get the desired result at UI?

Dear All
Hi
I want to retrieve the passwords that saved in "user" table in Bonita database. By the way, i think it has saved by hash algorithm. for example for default password (bpm) the "LcTkpvvquKf4KO+prsfXrQ==" value saved in database. My question is how can i retrieve the passwords?

Thanks in advance
REZA