Enter a Testnumber value in the results

[Joe_H]

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.

[Marinuss]

I'm not an expert

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

Marinus

[Oli_Wachno]

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

[Marinuss]

Hi

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

Marinus

[Joe_H]

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. 

[Joe_H]

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. 

[Oli_Wachno]

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-b... )

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.

[Joe_H]

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. 

[ee-jallen · Accepted solution]

---

@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.

---

1. Go to Configure > Result Processing
2. Insert a Database report by clicking the add button
3. 
4. Click Options 
5. 
6. Go to Schemas tab
7. Copy the Generic Recordset
8. 
9. Checkbox the new copy Recordset.  Expand the Generic Recordset, then expand STEP_RESULT.  Right-click any child and add a New child
10. 
11. I named it UID and set it to a 32 byte string
12. 
13. Set the Value to Log option to: PropertyExists("Logging.StepResult.UID") ? Logging.StepResult.UID : ""
14. Click OK on Database Options to save and close Options
15. Click OK on Result Processing dialog to save and close
16. Click on any test step in your sequence, where you want a Unique ID.
17. In the step's Pre-Expression add this: Step.AsPropertyObject().SetValString("Result.UID", PropOption_InsertElement, "12345")
18. This adds a UID of 12345 to the Step.Result
19. Run the test sequence
20. After the sequence is complete, go back to Database Options in Result Processing and click View Data
21. 
22. 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

[Joe_H]

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