Logging individual sequence result?

[goel]

Hello All

I have a requirement where i need to get results of sequence execution into the my custom database. My sequences are designed in such a way that high level sequence [Say Seq_1] has only "SequenceCall" steps which are further calling other sequences.

Ex:Sequence levels are as below:

            Seq_1

                   Seq_1.1

                           Seq_1.1.1

                           Seq_1.1.2  

                   Seq_1.2  

                           Seq_1.2.1                   

                           Seq_1.2.2

Problem:

I need to get result of sequence execution of each level into my DB seperately in a new row.

Please find below columns in DB schema

Ex:

TestID    UUT_NUMBER      UUT_STATUS   Report_FILEPATH

1             1.0                         Passed               "......"     

1.1          1.0                         Passed               "......"      

1.1.1       1.0                         Passed               "......"      

1.1.2       1.0                         Passed               "......"       

I am able to get the TestID and but not sure how do i retrieve the UUT_STATUS or Sequence execution status for each level into  my database.

Please respond asap, as this is little urgent for me.

Regards

NG   

[goel]

Can someone give suggestions on this, its really critical for me.

Regards

Goel

[Dennis_Knutson]

It's StepResult.TS.SequenceCall. You could have looked at the default schema and found this. If you had used the default scehma, all you would have had to do is a query to generate the report. You still seem to think that the design of the database has to be identical to a report. Have you consulted with a db administrator?

[goel]

Thanks for reply Dennis

Actually, i forgot to mention about that i need to confiure Logging in such a way that if i run Individual lower level sequence[Seq_1.1.1] or run a higher level sequence[Seq_1], in both the cases results should get logged to DB.

[Dennis_Knutson]

As long as you use the same process model, what difference does it make?