topic Re: Enter a Testnumber value in the results in NI TestStand

Enter a Testnumber value in the results

Joe_H — Wed, 02 Oct 2024 21:25:08 GMT

Where and how would be the best way to enter a testnumber for each test I run so that the test would have a test number column in the database associated with it.

Re: Enter a Testnumber value in the results

Marinuss — Thu, 03 Oct 2024 08:16:37 GMT

I'm not an expert

maybe this give you an idea. See our test result -html and Test Sequence.

Marinus

Re: Enter a Testnumber value in the results

Oli_Wachno — Mon, 07 Oct 2024 04:39:25 GMT

You mean like assigning a (human readable) unique identifier to each test?

Re: Enter a Testnumber value in the results

Marinuss — Mon, 07 Oct 2024 06:17:05 GMT

I was thinking you can change the test names to 1, 2, 3 etc.

Marinus

Re: Enter a Testnumber value in the results

Joe_H — Mon, 07 Oct 2024 13:05:07 GMT

Thanks but I’d really rather not do it this way. I would rather have a number tied directly to the test itself that way I can create a master test table in the database that corresponds to the test numbers. Makes it easier to generate a test report from the database.

Re: Enter a Testnumber value in the results

Joe_H — Mon, 07 Oct 2024 15:29:29 GMT

Yes exactly. This would make it a little easier when creating a report from the database itself. Ultimately the goal is to have a master table in the database that has names associated with test numbers. I just need a way to put the testnumber in the test results or to be able to add it in the database somewhere that correlates to the actual test performed.

Re: Enter a Testnumber value in the results

Oli_Wachno — Tue, 08 Oct 2024 05:15:53 GMT

I'll start with some background before sketching a possible solution...

TestStands result collection basically works by harvesting the result containers from the steps in a sequence.

The data from the result containers are than written into the report or database by the result processing.

Consequently, the data you want to have in the report / database should go into the result container of the step.

To do so, there are several ways, each with some pros and cons (guess you'll find them out yourself)

1.) Use "Additional Results" Properties of step

2.) Create your own StepType based on the NI StepTypes, modify the result structure and provide some code to enable better UX. (https://www.ni.com/de/support/documentation/supplemental/08/teststand-custom-step-type-development-best-practices.html?srsltid=AfmBOoobTMJ8LZvPRPDZ47KLrUJvyHFDpUWFiN2_ekmqaRv9i95Ks-f2 )

These are the most straight-forward options I am aware of.

We have opted for the second way, since there is a lot of additional functionality in our steps.

Re: Enter a Testnumber value in the results

Joe_H — Tue, 08 Oct 2024 12:53:16 GMT

Thank you. This is what I was looking for. I was leaning towards a custom type before posting this but I wanted to make sure that there was not something easier. I will look more into custom types.

Re: Enter a Testnumber value in the results

ee-jallen — Tue, 08 Oct 2024 17:53:24 GMT

@Joe_H wrote:

Where and how would be the best way to enter a testnumber for each test I run so that the test would have a test number column in the database associated with it.

Go to Configure > Result Processing
Insert a Database report by clicking the add button
Click Options
Go to Schemas tab
Copy the Generic Recordset
Checkbox the new copy Recordset. Expand the Generic Recordset, then expand STEP_RESULT. Right-click any child and add a New child
I named it UID and set it to a 32 byte string
Set the Value to Log option to: PropertyExists("Logging.StepResult.UID") ? Logging.StepResult.UID : ""
Click OK on Database Options to save and close Options
Click OK on Result Processing dialog to save and close
Click on any test step in your sequence, where you want a Unique ID.
In the step's Pre-Expression add this: Step.AsPropertyObject().SetValString("Result.UID", PropOption_InsertElement, "12345")
This adds a UID of 12345 to the Step.Result
Run the test sequence
After the sequence is complete, go back to Database Options in Result Processing and click View Data
Use this sql query to see the Step Name, UID and UUT Status

SELECT UUT_RESULT.UUT_SERIAL_NUMBER, UUT_RESULT.START_DATE_TIME, STEP_RESULT.ORDER_NUMBER AS STEP_ORDER, STEP_RESULT.STEP_NAME, STEP_RESULT.UID, STEP_RESULT.STATUS
FROM UUT_RESULT LEFT JOIN STEP_RESULT ON UUT_RESULT.ID = STEP_RESULT.UUT_RESULT
ORDER BY UUT_RESULT.UUT_SERIAL_NUMBER, UUT_RESULT.START_DATE_TIME, STEP_RESULT.ORDER_NUMBER

A table will be created which includes the UID column

Re: Enter a Testnumber value in the results

Joe_H — Wed, 09 Oct 2024 00:25:30 GMT

This seems like a very viable option. I will try it out and let you know.

Re: Enter a Testnumber value in the results

ee-jallen — Wed, 09 Oct 2024 21:23:01 GMT

17. In the step's Pre-Expression add this: Step.AsPropertyObject().SetValString("Result.UID", PropOption_InsertElement, "12345")

I had a typo in Step 17, it should be:

17. In the step's Pre-Expression add this: Step.AsPropertyObject().SetValString("Result.UID", PropOption_InsertIfMissing, "12345")

PropOption_InsertIfMissing instead of PropOption_InsertElement. Funny thing is, those options have the same constant value of 1, which is why when I tested, I didn't get any errors.