select filed from table where=?

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

2

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.

3

Thank you a lot!!!:))

It helps me a lot!!!It runs :wink:
Hioupi!!! :smiley: :smiley: