How can I pass the value in Project.Variables.lastAfscId to bus_uid = as show below the SQL Query Text in the keyword test.
select subscription_uid from bus_subscription where bus_uid = Project.Variables.lastAfscId
The query works with hard coded bus_uid. I don't know how to pass the variable to the query.
Okay, I just wanted to make sure that we know the query is good. Something similar to the code in your first post should work. What happens when you try the variable?
When setting up an SQL query for a data driven loop in Keyword test, you can't use variables within the query currently. What I usually end up doing is using script code, create the loop there (where I can then define the query with a variable) and then call a keyword test from within that script loop, passing in any parmaetres that may be needed.
I try different way but does not work. what is the syntax for the variable in query?
Select Subscription_UID from Bus_Subscription where bus_uid = Project.Variables.lastAfscId;
Select Subscription_UID from Bus_Subscription where bus_uid = "Project.Variables.lastAfscId";
Select Subscription_UID from Bus_Subscription where bus_uid = "'Project.Variables.lastAfscId'";
That is what I end up doing. Thought if there is a way to pass variable to query in keyword will be much simpler. thanks for the response.