You rocked again !!

Chuck, can you let me know how to get the transaction activity count for all the change request logged.

thanks

HI Hari,

I'm glad you got your original question answered. If you wouldn't mind, please mark it Correct so others with the same question can find it easily.

That being said, can you elaborate on what are looking for in the transaction activity? I'm not exactly sure what you are referring to. Screenshots would help.

If this isn't related to the email question originally posed, I suggest starting a new thread to increase visibility (get more people than just me looking at it) plus make it easier for others to find in the future.

sure will make the correct answer, what i required was   -

To get a report to find out the no of transaction activity count for all change raised.

Transition history is kept in the table wf_transition_history. Start by going here:

From there, click any column heading and make a simple report:

Now set up your report type and filter to get the records you want. This may be done either via selecting specific contexts (where the transition came from) or by dot-walking to related records. You may need to do a bit of digging around.