select filed from table where=?

Submitted by Multix on Fri, 05/23/2014 - 13:55
1
0
-1

Hello, i execute this query: "SELECT field1,field2,field3 FROM table's_db WHERE username='katerina';" //INstead of 'katerina' ,is token a global variable from Bonita

IF i want to choose a username,dynamically when the process run.How can do it?? for example,one step,a human write a name and the next step, is executed query is based on usename,which is given. I hope somebody could help me... Thank in advance

1 answer

Submitted by yannick.lombardi on Fri, 05/23/2014 - 14:03
1
0
-1
This one is the BEST answer!

Hi. You need to use a groovy script instead of a SQL query. You can use something like that : return "SELECT field1,field2,field3 FROM table's_db WHERE username='"+globalVariableName+"';" where globalVariableName is the name that the user write in a field.

Comments

Submitted by Multix on Sat, 05/24/2014 - 01:54

Thank you a lot!!!:))

It helps me a lot!!!It runs ;) Hioupi!!!!! :D :D

Permalink
Notifications