Hi, We have a case where there are 5K-6K completed instances of one of our process. There was an important piece of information which users were entering in the comments before the final step submission. We require this information to be a part of our custome report so that users may perform search on it. This information should supposed to be entered in one of the field but unfortunately that wasn't taken care of while designing the process.

As the comments cannot be added custom reports column, so the only option we are seeing is to somehow write a query to get all completed instances final submission comments and update one of the existing field with comments. So that the field can be added in a custom report.

I would really appreciate if someone can assist in writing such query on Forms database. For the future instances, we can hide the comments and make other field mandatory, so user won't miss it.