database query

[LuisMontoya]

Hello.

I need to get the test resultd from data base of TestStand, but I have no esperience using SQL querys,

do any body has a query to do that?

I just need basic informations as:

Model, serialNumber, Test name, SpecMin, SpecMax, result, pass/fail, etc.

Thank you

[~jiggawax~]

Here is a great website to learn SQL: http://www.w3schools.com/sql/default.asp

I highly recommend going through it.

This will give you the high level information:

SELECT *
FROM UUT_RESULT

The problem is you need to do a bunch of Join stuff to get exactly what you want.  Because you did an etc... though I'm not sure exactly what you are looking for.  The other problem is you may have stored step information in a certain place.  I would need to know what the name of your step is before I could give you all the info you needed.

Regards,

[LuisMontoya]

Done!

http://forums.ni.com/t5/NI-TestStand/TestStand-DataBase-Query/m-p/2866064