Version: Windchill 13.0
Use Case: For a change status monitoring system based on SQL reports against the oracle source tables, we want to accommodate a specific department's practice of tracking in-progress efforts by saving and updating comments on open tasks.
Description:
As https://www.ptc.com/en/support/article/CS153902 makes clear, WFVOTINGEVENTAUDIT stores user comments for completed workitems, but it is not populated before they're complete. However, users can enter comments on a task and save it without completing it, and there is no alternate source mentioned in this article for comments on running tasks.
I have a complete change task tracking setup already built, and pulling comments on completed tasks is no problem. I just can't figure out where the comments are if they're saved on a task with no entry in the voting event audit table. My efforts to trace known comment strings in the source tables have come up empty, but our database has some grant issues that prevent my role from seeing tables added around Windchill 11.0, so either these are stored in a table I just can't see or I've been making some mistake in my broad search attempts. Any help or pointers would be appreciated.
