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. 

Outcomes