Model Search for Multiple Terms

[Dorian Workman]

I'm trying to run a Model Search using the Simple search, for multiple terms.  I'd like to find the three elements called Element1, Element2 and Element3.

I'm trying to just comma separate the values in the Search Term field, but that doesn't work.  How do I do this please?

Thanks.

[Geert Bellekens]

If you really need this you can always use the 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 'Package Name'
from t_object c
join t_package as package on (c.package_id = package.package_id)
where
c.name like 'Element1'
or c.name like 'Element2'
or c.name like 'Element3'You would then need to change "Element1", "Element2" and "Element3" for what you are looking for.
And if you really really need this you can surely parse the different parts from the comma separated <Search Term> and look for those seperately. Then you could enter a comma separated list in the search box and you don't have to worry about the SQL code. But I leave that excercise to someone else.

[Martin Terreni]

In model search you can enter only one term through imput, but you can try a SQL search with an "where in" in it and then in one parameter you can pass a list of terms.

[Geert Bellekens]

I'm afraid that isn't going to work.
You get an error about invalid columns because your search terms are not enclosed in quotes.
i've tried to add the quotes in the search field, but those get stripped off by EA before the query is submitted.
No, I'm afraid some fancy combination of string functions will need to do the trick.

[Dorian Workman]

Thanks for your help Geert, but when I copy and paste your query and run the search, I get this error:

DAO.QueryDef [3131]
Syntax error in FROM clause.

Any ideas please?  Thanks!

[Martin Terreni]

maybe the parenthesis?

[Dorian Workman]

Thanks Martin, I tried removing them, but that didn't work...

[Martin Terreni]

maybe just moving the first one right after the "join". I'm not sure about it, but it works with Access, and it makes problems with the "joins" and parenthesis...

[Dorian Workman]

Tried this, still getting the same error unfortunately:

select c.ea_guid as CLASSGUID,c.object_type as CLASSTYPE,c.name as Name, c.stereotype as Stereotype,package.name as 'Package Name'
from t_object c
join (t_package as package on c.package_id = package.package_id)
where
c.name like 'Element1'
or c.name like 'Element2'
or c.name like 'Element3'

[Geert Bellekens]

Oh, sorry, that was a query for sql-server.
I'll try to translate it to the crippled sql syntax of Access and get back to you.

[Dorian Workman]

Actually one of our developers here helped me, and I got it working!

Thanks Geert!

select
  t_object.ea_guid AS CLASSGUID,
  t_object.object_type AS CLASSTYPE,
  t_object.name,
  t_object.stereotype,
  t_package.name
from
t_object inner join t_package
on (t_object.package_id = t_package.package_id)
where
(object_type) = 'Requirement'
and (UCase(t_object.name) like '*BR: ACH/NOC PROCESSING*'
or UCase(t_object.name) like '*BR: ACCOUNT DISPLAY*')

[Geert Bellekens]

This one works in Access as well.
Apparently Access doesn't like JOIN statements; how typical  :-/

Code: [Select]

select c.ea_guid as CLASSGUID,c.object_type as CLASSTYPE,c.name as Name
, c.stereotype as Stereotype
,package.name as 'Package Name'
from t_object as c,t_package as package
where
c.package_id = package.package_id
and (c.name like 'Element1'
or c.name like 'Element2'
or c.name like 'Element3' )

[Dorian Workman]

Thanks for all your help Geert.

[Geert Bellekens]

Look like our replies crossed each other.
I'm happy you found a working solution.

Geert

[Dorian Workman]

You may like to know that my friend who helped me is also Belgian.