can't get data from mysql

Submitted by afefmdimagh on Wed, 11/08/2017 - 23:43
1
+1
-1

hello , i m using bonitasoft 6.5.1 community and Phpmyadmin

I want to Search the Database based on Values provided in the Search form created in Bonita.
My query to search based on the variable value is
select * from clients where 'id_client' = '${variable}'

this request is feasible in phpmyadmin and the searched data is displayed according to the value provided in the Search query but using the connector in bonita it does not work .

thanks

mysql select
2 answers

Submitted by gpscruise on Thu, 11/09/2017 - 15:55
1
+1
-1
This one is the BEST answer!

I got it working once and made a video. Its not perfect...

link

Submitted by vitiellom on Thu, 11/09/2017 - 11:02
1
0
-1

Hi,

how does the script in your connector looks like? You would probably need something like

def script = "select * from clients where id_client = " + xyz;

where xyz is the name of the variable from the UI (should be available in the top-right dropdown list in the script window).

Best

Notifications