Open issues

No access to Business model variable in PostgreSQL connector for SQL

Description

Seems any instance of a pool level business model is not accessible via Groovy in the PostgreSQL connector. BPM diagram attached.

NOTE: I use with PostgreSQL +9.2 +*JDBC 4 database query connector definition with the PostgreSQL-9.4*-1200.jdbc41.jar as active.

Environment

PostgreSQL-9.4-1200.jdbc41.jar
Windows 8.1 Aspire V17 Nitro laptop. BPM 7.0.0 community edition.

Steps to reproduce

Create new process. Create a BDM called MyBDM with one text field called myField. Create pool business variable of type myBDM valled varBDM. Set default value of varBDM (or set value in step1 operation). In step1, create connector out of type PostgreSQL connector with SQL. In the SQL data entry screen hit Ctrl+Space and varBDM does not appear in the list. If you create an insert SQL command with an input value of '${varBDM.myField}', the value entered into the database will not be the value of the myField. It will be the literal "${varBDM.myField}".

Workaround

Switch the query editor to script mode and build your query like this:
return "INSERT INTO 'Property' ('PropertyType', 'PropertyName') VALUES ('d', '"+ boCommunity.getName() +"');";

External Link

None

Status

Assignee

Unassigned

Reporter

Scott Peal

Reference

BS-13852

Components

Affects versions

7.0.0
Configure