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 with the above test case property variables. How to do that in ReadyAPI JDBC datasource ?
SELECT * FROM Table1 where TagId = 4314 and Time > '2023-11-15 23:00:00' and Time < '2023-11-16 23:00:00'
I am able to retrieve integer values like TagId and use it by adding 'Prepared Properties' within the JDBC datasource window. But if i add the string and use it inside the query, data is not fetched as the string is not interpreted properly.