update via sql dashboard name
We are beginning to institute some standards (naming conventions) for the many dashboards that we have in in existence. Across 3 different environments (DEV, QA, PROD), it would be quite a headache to rename them in one environment and then export them/then import them to each of the two new environments. Would would prefer to use SQL to update the metadata; and the SQL would be reusable across each DB. After spending a few minutes looking around, I am guessing the data we want to update is in the reportGroup table. Narrowing it down to only those records that are grouptypecode of 'SUBTAB' and statuscode seems to get me to close to want looking in the ShortDescription field, but appears to have duplicate rows and more rows than expected? Appears this list has dashboard subtabs also in it - how do i distinguish between dashboard and subtab? (we are 7.2 version build 20160524) . I would also like to know if the YF app servers will need to be restarted to pick up the changes; my memory is there is/can be some caching that wont allow these changes to be picked up without a restart.