Report Mass Update

[David Yearsley]

A couple of fields in our system were not labeled correctly and many reports were created using the wrong fields. This has been corrected, but now there are a more that 100 reports with issues. I know that the conditions and fields on the report are stored somewhere and if I could find the tables/forms that a mass update could be done to use the new field.

Does anyone know where these values are stored?

Is there an easy way to mass update a set of report and report filter conditions?

Thanks for any help or ideas.

[Michael Ritchie · Accepted solution]

Reports are stored in the Report (sys_report) table.   The Filter (filter) attribute contains the filters for the report and the Select field for list (field_list) contains the columns in the report.

Navigate to Reports\Administration\All and click the Show\Hide filter and search for reports on the table you changed the column label.   The Select Field for List column doesn't allow a "contains" search via condition builder, BUT you can add that column to your list view and perform a *OLD-FIELD-NAME and it will show you all the reports that have the old field name in it.   This will provide you a list of all the reports with the affected field.   Then you can update them with the proper field.

[antin_s]

Hi David,

If you have just changed Label and not the actual column name, you dont have to make any changes to the report filters as the filters work based on the column name only. But if you have changed the column names also, then please follow what Michael have described.

Hope this helps. Mark the answer as correct/helpful based on impact.

Thanks

Antin