Forum Discussion

arasi_m's avatar
arasi_m
Occasional Contributor
2 years ago

How to build SQL query using strings whose value should be retrieved from TestCase property

Suppose i have the following properties defined in the Test Case Properties FromTime = 2023-11-15 23:00:00 ToTime = 2023-11-16 23:00:00   I want to replace the time given in the below query...
Configuration
Data-Driven Testing
REST
Scripting
mrdwprice's avatar
mrdwprice
Contributor
2 years ago

Perhaps you are missing the single quotation marks?

SELECT * FROM Table1 where TagId = 4314 and Time > '${#Scope#Property-Name}' and Time < '${#Scope#Property-Name}'