Operations Orchestration Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Flow not working when I used variables in the SQL query

Highlighted
Frequent Advisor

Flow not working when I used variables in the SQL query

Hi,

 

I am trying to get the data from DB using select query... But when I used variables like ${username} or some variables in the query, the flow is not working....

 

This is the query I used:

 

 

Select status from software where username=${username} and applicationname =${appname} and machinename = ${machinename}

 

When I used like this,

Select status from software where username=vinay and applicationname =adobe and machinename = testmachine..

It is working...

 

 

 

 

1 REPLIES
Frequent Advisor

Re: Flow not working when I used variables in the SQL query

Surround your variables with single quotes

 

Select status from software where username='${username}' and applicationname ='${appname}' and machinename = '${machinename}'

 

 

//Actively seeking HPOO opportunities