Update only subsequence Result to MySQL Database in TestStand

[Vipin@AMP]

Hello Folks,

I am required to update only subsequence results (Testcase as subsequence) to the MySQL Database. I'm able to connect and configure the database in TestStand using the result processing option. I have the following table in my Database, data is to be updated as per this.

Can you help me with this requirement, Here I would like to use the result processing option instead of using the Database Step type in the TestStand sequence.

Date and Time	Version	Test Case 1	Test Case 2	Test Case 3	Test Case 4	Test Case 5	Test Case 6	Test Case 7	Test Case 8
06/15/2023 8:00AM	1.0.0	Pass	Pass	Pass	Fail	Fail	Fail	Fail	Fail
06/16/2023 8:00AM	1.0.1	Pass	Pass	Pass	Pass	Fail	Fail	Fail	Fail
06/17/2023 8:00AM	1.0.2	Pass	Pass	Pass	Pass	Pass	Fail	Fail	Fail
06/18/2023 8:00AM	1.0.3	Pass	Pass	Pass	Pass	Pass	Pass	Fail	Fail
06/19/2023 8:00AM	1.0.4	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Fail
06/20/2023 8:00AM	1.0.5	Pass	Pass	Pass	Pass	Pass	Pass	Pass	Pass

Thanks in advance

Vipin

[RaviShrigiri]

Hi,

If you go to the properties of each step there is a option of results logging.

You can enable the logging only for the required steps.Disable others.

Then only the desired steps will be logged ( be it in report or database).

Ravi

[Vipin@AMP]

Hi,

Thanks for the reply.

I need other information in the ATML Report. So, I won't be able to disable the result recording options in each steps.

-Vipin

[Shrigiri]

Hi Vipin,

I dont think you cannot selectively log for DB and different for the report.

1) For the DB you can use the DB step types and update the required data to the database. Refer DB examples.

2) Let the DB log everything.Write a SQL query to fetch only what is required.

3) Collect all dat a and send to a VI to log to database.

Ravi

[Vipin@AMP]

Hi,

I'm using the second option. I just want to know, if is it possible to use a customized Database model Plugin.