can't get data from mysql

Q&A
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

1 Like
2

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

3

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

link