Author Topic: Global replace SQL queries content stored in list views and charts  (Read 266 times)

adepreter

  • EA User
  • **
  • Posts: 128
  • Karma: +2/-2
    • View Profile
Is there a way to automatically replace sql select content stored in list views and charts?

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9479
  • Karma: +266/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Global replace SQL queries content stored in list views and charts
« Reply #1 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

qwerty

  • EA Guru
  • *****
  • Posts: 10582
  • Karma: +232/-192
  • I'm no guru at all
    • View Profile
Re: Global replace SQL queries content stored in list views and charts
« Reply #2 on: July 03, 2019, 07:15:41 am »
My guess would rather be the registry :-)

q.

adepreter

  • EA User
  • **
  • Posts: 128
  • Karma: +2/-2
    • View Profile
Re: Global replace SQL queries content stored in list views and charts
« Reply #3 on: August 25, 2019, 10:50:27 pm »
The alternative is to delete the list view and regenerate it.