We have a business process that has been running for many years. As our business has evolved over time, our Segment, Business Unit, Division names have changed as well. This has caused the summary reports generated from this process to lose their effectiveness because they are incomplete. It would be great if there was a way to clean up historical Forms data and make these reports accurate and meaningful to the process participants without having to purchase, integrate and maintain an additional 3rd party reporting tool. The recent addition of the "Edit Variables" feature in Forms 11 has been extremely useful for in-process instances and this added functionality would allow this feature to be extended to completed processes as well.
If there is no plan to implement this feature in the short-term, would it be possible to provide a SQL query that would allow the correct database fields to be updated in the interim? Thanks!