Where to get Sequence name for logging into Database?

[goel]

Hello

I need to create a custom schema for database logging which consists of a table to log Sequence name and its Execution status(Pass|Failed),
this will include the name of sequence along with the sub sequences executed from sequence file.
Please let me know from where i can get a property to access the sequence and sub sequence name.

Regards
Nitin Goel

[kbsave]

Hi Nitin,

Go to expression browser in any expression, select Operators/Functions tab. Here select property in the Functions category and select NameOf() function. This function can return name of any property.
e.g. NameOf(Step), NameOf(Sequence),etc..

Regards,
Kaustubh

[goel]

Thanks for information i hope this will be helpfull but before that i need to know that how do i add a new Column in the statement "SEQUENCE_SEQCALL" which is also present in the Generic Recorset Schema. I tried to make a new schema and copied "SEQUENCE_SEQCALL" statement and then added a new column "Status" with expression "NameOf( RunState.Sequence)" and saved the changes.
On executing the sequence with database logging enabled i get an error, see attached image for the error.

[kbsave]

Hi Nitin,

Don't use RunState.Sequence, instead just write NameOf(Sequence). That error might be for RunState.Sequence.

Regards,
Kaustubh

[kbsave]

Sorry....... Wrong guess. TestStand can automatically convert Sequence to RunState.Sequence

[J_Stape]

Hi Nitin,

This functionality is already built into a schema provided with the TestStand Sequence Editor.  Navigate to Configure » Database Options in the Sequence Editor, and select the Generic Recordset (NI) under the Schema tab and then select STEP_SEQCALL in the Statements tab.  You will then be able to see that this is already done in STEP_SEQUENCE_NAME column.  You can use the value passed in the Expression field in your custom schema to achieve the same results.  The expression used is Logging.StepResult.TS.SequenceCall.Sequence.