Book a Demo

Author Topic: Searching on custom tagged values  (Read 12598 times)

UrsulaGreen

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Searching on custom tagged values
« on: October 11, 2013, 02:16:38 am »
I've been using the tagged value feature with the requirements elements to store information such as: a customer of a requirement; which srum iteration a requirement is developed in.  Is it possible to then use the search facility to query a specific customer or scrum iteration?  I've looked in the help facility and can't find anything

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Searching on custom tagged values
« Reply #1 on: October 11, 2013, 08:51:36 am »
You can create a custom search for tagged values. Use Ctrl-F and the builder. Then create a new search (name it Scrum or whatever) and use the Query Builder. Add a filter which includes your tagged value. You can then use that search from the drop down.

If you are after more (advanced) searches you might consult my Inside book.

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: Searching on custom tagged values
« Reply #2 on: October 11, 2013, 04:40:39 pm »
I would use an SQL Search.
Something like:
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 = 'MyTaggedValue'
and op.Value like '<Search Term>'
Replace 'MyTaggedValue' with the name of the tagged value you are searching on.

A bit more info on SQL Searches in this article: Harvesting the power of EA’s SQL searches

Geert