report to show the historical field level changes
One answer
https://jazz.net/forum/questions/140492/capture-the-timestamp-for-the-history-of-customized-attributes-in-rrdi
Comments
Thanks Brian. So, I will need to have RRDI setup to access RequestArea and other sources. Does the RequestArea tables show the custom workitem contents as well? Issue work item is the custom WI that I have created.
Yes, there are tables that store custom attributes. Which table depends on the type of your attribute. For example, there is a REQUEST_STRING_EXT table (and corresponding REQUEST_HISTORY_STRING_EXT table) to store custom small string attributes. All tables that store custom attributes follow the same pattern "REQUEST_type_EXT"
I have an attribute called issue status of type Issue (Enumeration) in my custom Issue WI. I am not able to see it anywhere in the Request History or anywhere in the Request_type_Ext tables. Any idea. Thanks.
Enumerations are a bit of a special case. The REQUEST_ENUMERATION table contains the mapping between enumeration literal id and enumeration literal value. The enumeration literal value is what you see in the RTC UI, while the enumeration literal id is what would be stored in the Request_type_ext table (likely REQUEST_STRING_EXT in your case).