How to pass persistent variable to SQL Query in Keyword Test Data-Driven Loop

Question

How can I&nbsp; pass the value in&nbsp;Project.Variables.lastAfscId to bus_uid = as show below the SQL Query Text in the keyword test.
&nbsp;
select subscription_uid from bus_subscription where bus_uid =&nbsp;Project.Variables.lastAfscId
&nbsp;
&nbsp;

tristaanogre · Accepted Answer

lingling_chiang&nbsp;wrote:
We have been using the scripts to handle this but just wonder if there is a way to do using the keyword test to specify the variable in the database query.&nbsp; All the solutions&nbsp;seem&nbsp;pointing to&nbsp;scripting. I guess there seem&nbsp;there is no way to&nbsp;pass the variable to the query text in keyword test.&nbsp; Am I right to conclude that?

You are correct.&nbsp; At this time, you will need to use scripting to run the query.

lingling_chiang · Answer

That is what&nbsp;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.

tristaanogre · Answer

When setting up an SQL query for a data driven loop in Keyword test, you can't use variables within the query currently.&nbsp; 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.

marsha_r · Answer

Does that query work for you if you hard code a value for bus_uid instead?

lingling_chiang · Answer

The query works with hard coded bus_uid.&nbsp;I don't know how to pass&nbsp;the variable to the query.

marsha_r · Answer

Okay, I just wanted to make sure that we know the query is good.&nbsp; Something similar to the code in your first post should work.&nbsp; What happens when you try the variable?

Forum Discussion

How to pass persistent variable to SQL Query in Keyword Test Data-Driven Loop

11 Replies

Related Content

Difference between Persistent and Temporary variable

Persistent ProjectSuite variables??

Persistent Variable Values not persisting in CI/CD environment

Data Driven Tests with variable Assertion

Persistent Variables Default Value Programmatic Update

Recent Discussions

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout

testcomplete feature Intelligent Quality Add Ons