Forum Discussion

joeybear's avatar
joeybear
Contributor
15 years ago

Using Testcase Variables in Datasource SQL Query - HOW??

Here's an extremely simplified example of what I'm talking about: Select name From auth_userprofile Where id = ${new_user_id}; I need to be able to use the variable from my testcase proper...
SmartBear_Suppo's avatar
SmartBear_Suppo
Icon for Alumni rankAlumni
15 years ago
Hi!

TestCase properties are expanded as follows:

SELECT name FROM auth_userprofile WHERE id = ${#TestCase#new_user_id};


To get this Property Expansion automatically generated for you, just right click in the SQL Query textarea and chose Get Data..., then click on your TestCase Property.

Read more about Property Expansion here.


Regards

/Henrik
eviware support