Test Data Manager

Hi All,
Actually am trying to fetch details from database to generate report based on some condition using JDBC step available in Lisa.
I want to send the ResultSet as a report.
Am planning to run this testcase from CVS in future.
Could you please suggest me how to do this.

Thanks for the help in advance !

Regards,

Girija K.

You could save your results to a file, and then copy the file to a safe location - or you could use the Send Email step to transfer the data.

Hi Dave,

Thanks for your response. Yeah we can save it into a file. But i was unable find any option (Filters )where we can save. And as you suggested we can go with Email step as well but, we need to transfer that entire result set from JDBC step to Send Email step. Am not aware of how we can do this.

Could you please suggest me.

Thanks,

Girija K.

Hi

Would this work for you?

Add a Utility step of "Output Log Message". To this step add a "Read Rows from a JDBC Table" dataset, and populate accordingly. 

Set the Output to be that you need saving for each row of data,

To the same step, add a "Utility" filter of "Save Property Value to File" and use "Append Mode." Use the response property of the Output Log Message step as the "Filter In" value

Thus will let you capture your  results into a file and is a single test step. for an example, please see the JavaConfiguration step in the DevTest_config_info.tst in the supplied examples

After this step, you can use the "Send Email" step with the file as an attachment.

Hi Dave,

Thank you for the response.

It worked

Regards,

Girija K.