Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: amacara1 on January 10, 2023, 02:04:50 am

Title: Apply SQL-based profile to MatrixOptions of "matrix specification"
Post by: amacara1 on January 10, 2023, 02:04:50 am

I would like to use a 'search' (sql) based profile that I have saved from an <<EAMatrixSpecification>> element (the profile is visible in t_trxtypes table) inside <MatrixData> of element's MatrixOptions tagged value. I believe this cannot be done currently, with EA 16.1.
Or another option to apply an sql search when opening the matrix specification and/or generating documentation using "Relationship Matrix" from a doc template.

Title: Re: Apply SQL-based profile to MatrixOptions of "matrix specification"
Post by: qwerty on January 10, 2023, 10:10:59 am

You can include model searches in the MDG likes this

Code: [Select]

  <ModelSearches>
  <Search Name="name of search" GUID="{some-guid}" PkgGUID="-1" Type="0" LnksToObj="0" CustomSearch="1" AddinAndMethodName="">
<SrchOn>
<RootTable Filter="SELECT bla FROM bla...;" Type="-1">
<TableName Display="Custom SQL Search" Name="" />
<TableHierarchy Display="" Hierarchy="" />
</RootTable>
</SrchOn>
<LnksTo />
</Search>

</ModelSearches>

</MDG.Technology>
I put that manually (or via an external script) in the MDG at the end (as can be seen). That's for model searches. Probably (don't ask me how) you could use that for the matrix as well!?

q.