Db logging passed/failed as a 1/0

[zero2rule]

Hello!

I am currently working with TestStand 4.1 and I am trying to get my database logging to run.

I am using the Chema templates provided by TS. I have modified them for my use but one thing is making my life hard - UUT_STATUS (Exp : Logging.UUTResult.Status)

TS gives it "Passed" or "Failed" string but I need it to be "1" for Passed and "0" for Failed or atleast TS has to write 1/0 to my database, not Passed/Failed.

How would be the easiest way to accomplish this?

PS. I am very new to NI Teststand!

Sorry for my bad english, its not my native language.

[Rodéric]

Hello,

the easiest way (from my point of view) would be to duplicate the schema you are using, then modify this new schema by changing the UUT_STATUS column Type to numeric then modify the expression field to convert the True/False string to 1 or 0.

Regards,

[zero2rule]

---

@Rodéric wrote:

...then modify the expression field to convert the True/False string to 1 or 0.

Regards,

---

I would be great if You could give me an example! I am a n00b!

[zero2rule · Accepted solution]

Got it working!

StrComp

( Logging.UUTResult.Status,"Failed",1,4)