Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: adepreter on July 03, 2019, 01:47:20 am

Title: Global replace SQL queries content stored in list views and charts
Post by: adepreter on July 03, 2019, 01:47:20 am

Is there a way to automatically replace sql select content stored in list views and charts?

Title: Re: Global replace SQL queries content stored in list views and charts
Post by: Geert Bellekens on July 03, 2019, 02:53:37 am

Probably. I haven't really looked for it but I guess the queries are stored somewhere in on of the database fields of either t_object or in t_document.
I'm guessing they are pretty easily replaceable with an update query on the database.

Geert

Title: Re: Global replace SQL queries content stored in list views and charts
Post by: qwerty on July 03, 2019, 07:15:41 am

My guess would rather be the registry :-)

q.

Title: Re: Global replace SQL queries content stored in list views and charts
Post by: adepreter on August 25, 2019, 10:50:27 pm

The alternative is to delete the list view and regenerate it.