Book a Demo

Author Topic: How to find a string in a Tag name or Tag value?  (Read 3513 times)

ngong

  • EA User
  • **
  • Posts: 275
  • Karma: +2/-2
    • View Profile
How to find a string in a Tag name or Tag value?
« on: July 01, 2014, 06:54:58 pm »
What I did:
I related a reference to a sequence diagram to a requirement (trace). I added a condition to that trace that is based on a change request outside EA. I added the change request ID as a tag-value to that trace relation.
I opened a find dialog and searched for that ID.

What I expected:
to get anyhow near to that trace relation.

What I got:
no result

I cannot think of a workaround.
What did I wrong?
Any idea for an alternate solution with the same intention appreciated:
Finding specifically conditioned requirement traces.
Rolf

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: How to find a string in a Tag name or Tag valu
« Reply #1 on: July 01, 2014, 06:58:28 pm »
Use the Extended search. That will also look into TVs.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to find a string in a Tag name or Tag valu
« Reply #2 on: July 01, 2014, 07:47:14 pm »
The problem with the built in searches in EA is that they only ever return elements, never relations, attributes, operations or diagrams.

With SQL searches you can return anything you want.
In this case you would need to join t_connector with t_connectorTag rather similar to the search below (so replace t_object by t_connector and t_objectproperties by t_connectorTag)


Code: [Select]
select c.ea_guid as CLASSGUID,c.object_type as CLASSTYPE,c.name as Name, c.stereotype as Stereotype ,package.name as PackageName ,package_p1.name as PackageLevel1,package_p2.name as PackageLevel2,package_p3.name as PackageLevel3
from (((((t_object c
inner join t_objectproperties op on op.Object_ID = c.Object_ID)
inner join t_package as package on c.package_id = package.package_id)
left join t_package as package_p1 on package_p1.package_id = package.parent_id)
left join t_package as package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package as package_p3 on package_p3.package_id = package_p2.parent_id)
where op.Property = 'FRName'
and op.Value like '<Search Term>'

Geert