Author Topic: How to save SQL search in project?  (Read 508 times)

babdev

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
    • View Profile
How to save SQL search in project?
« on: September 01, 2018, 12:38:43 am »
Hi

I'm experimenting with model searches and relationship matrices and have created an SQL search and a Matrix Profile that uses the search. I have found that the profile is available to other users of the same model via the Matrix Profiles node in the Resources view, but the profile can't find the SQL search that I've defined. I'm pretty sure it's because any new search that I create is saved in the 'My Searches' group, which is local to my machine or user profile. How do I create new searches and save them in the project to make them available to other users?

Thanks

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9537
  • Karma: +274/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to save SQL search in project?
« Reply #1 on: September 01, 2018, 01:44:32 am »
You can export your search into an MDG file and import the MDG into the model, or distribute it to your users via an url, or file path.

Geert

babdev

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
    • View Profile
Re: How to save SQL search in project?
« Reply #2 on: September 01, 2018, 02:18:23 am »
Thanks Geert. Disappointing that it's not possible to just save them within a project as a resource. 

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9537
  • Karma: +274/-27
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to save SQL search in project?
« Reply #3 on: September 01, 2018, 03:33:29 pm »
Thanks Geert. Disappointing that it's not possible to just save them within a project as a resource.
Maybe, but creating an MDG file is easier then you might think.
It takes just 2 minutes to create one and import it into the model.

Geert