Book a Demo

Author Topic: Relationship Matrix and applying of Model Search  (Read 4828 times)

Slávek Rydval

  • EA User
  • **
  • Posts: 40
  • Karma: +2/-0
    • View Profile
    • homepage
Relationship Matrix and applying of Model Search
« on: May 11, 2015, 12:45:15 am »
Dear folks,

I have a custom search which returns two rows as a result. When I want to use it in relationship matrix, it doesn't work even one of the columns is CLASSGUID as is stated in documentation:

select ea_guid as CLASSGUID, Object_Type AS CLASSTYPE, *
      from t_object
            where object_id in (2130, 2205)

What else must be fulfilled to obtain the result set in RM?

Thanks in advance.

EA 12 (build 1213), EAP repository, no addins.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Relationship Matrix and applying of Model Sear
« Reply #1 on: May 11, 2015, 12:22:45 pm »
try this

Code: [Select]
select ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE, *
     from t_object
           where object_id in (2130, 2205)

Yes, some areas in EA are very (case) sensitive.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Relationship Matrix and applying of Model Sear
« Reply #2 on: May 11, 2015, 03:22:51 pm »
I remember this being reported here a while ago (the first AS needs to be capitalized). So it's still not fixed.

q.

Slávek Rydval

  • EA User
  • **
  • Posts: 40
  • Karma: +2/-0
    • View Profile
    • homepage
Re: Relationship Matrix and applying of Model Sear
« Reply #3 on: May 12, 2015, 05:53:56 pm »
Thanks, Geert. It works. It is pretty surprising to me that even a keyword has to be capitalized.