Passing 'text' variables values in SQL queries

Q&A
1

Hello,
I am trying to pass some variables in my SQL Server queries in the database connector.

I have two cases

  1. SELECT * FROM DOCUMENT WHERE DOC_ID IN(${documentidnumber}) – This works fine.
  2. SELECT * FROM DOCUMENT_CODE WHERE CODE_ID IN(${doccode}) — I have issues here.

This is the error - Declared return type class java.lang.Integer is not compatible with evaluated type class java.lang.String for expression doccode"

The variable ‘doccode’ contains comma separated (integer) values, ex. 6783, 3590, 5312. The data type of this column is text.

Is there a different way to pass text variables values in SQL Server?

I am on v7.2.3.

Thanks.

2

I use Bonita 7.5.4 and I have the same problem in one Query!

 

For my case, it worked by adding after the variable the function .toString ();

Some like this:SELECT * FROM DOCUMENT_CODE WHERE CODE_ID IN(${doccode.toString()})

 

I hope it works for you or you have already solved it!

3

Hi Isha

this is how i execute a SQl Query.
getWBSTypes = SELECT WBSTYPE FROM IRCNETWORKWBS where PROJECTCATEGORY = :projectCategory group by WBSTYPE

The projectCategory is a parameter which i pass from the Page in the API call.