Author Topic: Relationship between functions and Matrix  (Read 10660 times)

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Relationship between functions and Matrix
« on: July 02, 2013, 11:44:40 pm »
Hello,

I have really weird question: is it possible to link two function in EA and see their relationship in the Relationship Matrix?

Thanks.

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Re: Relationship between functions and Matrix
« Reply #1 on: July 03, 2013, 12:09:50 am »
I mean two classes operations.

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Relationship between functions and Matrix
« Reply #2 on: July 03, 2013, 01:03:41 am »
Helle,

it isn't possible to see dependencies between operations by means of Relationship matrix.

However you can draw a dependency between operations/attributes. To do this make a dependency between the two classes. Then right click on the dependency and choose "Link to an element feature".

Best regards,

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Re: Relationship between functions and Matrix
« Reply #3 on: July 03, 2013, 05:08:31 pm »
WOW, thanks a lot. I'm just wondering where are those relations saved in EA database? I can use it for my addin in order to built my own relationship matrix between operations.

Thanks.

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Relationship between functions and Matrix
« Reply #4 on: July 03, 2013, 05:27:07 pm »
Hello,

there are some ways to find out:
- Thomas Kilian's eBook InsideEA or ScriptingEA
- Make a new repository with just the problem at hand modelled
  Usually you quickly find the database field the connection is saved in
- Addin EnarSpy (from LieberLieber, free)

In case of operation its:
- t_connector, StyleEx
  LFSP={GUID} LFEP={GUID}

Best regards,

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Re: Relationship between functions and Matrix
« Reply #5 on: July 03, 2013, 06:09:49 pm »
Thank you again.

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Re: Relationship between functions and Matrix
« Reply #6 on: July 03, 2013, 07:35:03 pm »
Another one Thought according to Relationship Matrix. I can run a Model Search on it, but when I do it, my matrix is empty. I suppose that my queries are in "wrong style". For example: select Name from t_object where bla-bla. What am I missing? I wanted to link 2 operation using Model Searches. You told me it's not possible, but...

Thanks.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Relationship between functions and Matrix
« Reply #7 on: July 03, 2013, 07:42:56 pm »
I guess you must be more specific in term of your SQL and the applied RDBMS.

q.

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Re: Relationship between functions and Matrix
« Reply #8 on: July 03, 2013, 07:56:12 pm »
The search is stright forward:

SELECT Name
FROM t_object
WHERE Name LIKE '#WC#<Search Term>'

But I assume in this case the query returns strings, but the Matrix requiries objects.

Thanks.

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Relationship between functions and Matrix
« Reply #9 on: July 03, 2013, 08:31:25 pm »
Hello,

the Apply Model Search feature looks weird. With Simple it works. With my own SQL search with the same output it doesn't work.

I haven't found any documentation regarding search in Relationship Matrix.

The conventions should be according to CLASSGUID and CLASSTYPE (see SQL search documentation).

Example:
select ea_guid as CLASSGUID, object_type AS CLASSTYPE, Name, object_Type As Type from t_object
where Name like "<Search Term>#WC#"

Beside: Operations, Attributes are not supported elements.

You may file a bug report about not supporting SQL queries for classes or so.

Kind regards,

Helmut
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Re: Relationship between functions and Matrix
« Reply #10 on: July 03, 2013, 10:02:07 pm »
It's very clear what you said. So, my solution could be a conversion of operations into classes or to write some addin for my own needs.

Thanks.

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Relationship between functions and Matrix
« Reply #11 on: July 03, 2013, 10:16:19 pm »
Hello,

you may consider:
  • Define Behavior of Operation by Activity or Interaction
  • Activities, Interaction,.. are supported in Relationship Matrix

Helmut Ortmann
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

zalbina

  • EA User
  • **
  • Posts: 149
  • Karma: +0/-0
    • View Profile
Re: Relationship between functions and Matrix
« Reply #12 on: July 03, 2013, 11:33:40 pm »
100%. I'll discuss this option with my boss.

Thank you very much for so quick response.

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1297
  • Karma: +21/-4
  • Read The Help!
    • View Profile
Re: Relationship between functions and Matrix
« Reply #13 on: July 04, 2013, 09:25:53 am »
There is a short discussion of using Model Searches to locate source and/or target elements in the Help topic:

Navigate, Search and Trace > Trace: Tracking Dependencies > Relationship Matrix > Set Source and Target Package.
Best Regards, Roy

Helmut Ortmann

  • EA User
  • **
  • Posts: 970
  • Karma: +42/-1
    • View Profile
Re: Relationship between functions and Matrix
« Reply #14 on: July 04, 2013, 03:31:28 pm »
Hello,

@Roy Thanks for your feedback and also thanks for the quick and valuable response to my bug report.

The important thing about using SQL Searches in Relationship Matrix is:
Write 'AS CLASSGUID, AS CLASSTYPE' in capitals

Example which works:
Code: [Select]
select ea_guid AS CLASSGUID, object_type AS CLASSTYPE, Name, object_Type As Type from t_object
where Name like "<Search Term>#WC#"

Helmut Ortmann
Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)