AnsweredAssumed Answered

How to print 'n' no. of records in a single run, when the condition of an sql query is parameterized ?

Question asked by PreethiManoj on Jun 19, 2017
Latest reply on Jun 23, 2017 by Joel NeSmith

I want to print the DB Records with certain limited no. of Records.


select * from <tablename> where column_name = {{col_value}}.


I have done parameterization via Data Set in excel for that column_name. In Excel sheet , say 10 rows are there. My query here is, I want to print all the 10  rows in a single run of the sql query. Is that possible. If yes, please guide me.


Currently, Via Data set -> the sql query will pickup the first value in excel and print the output for that particular value and again second value,... it goes on till 10th value in excel.