Query Builder Object.Name contains Search Term?

[AndyJ]

Hi people,

I'm fiddling around trying to see if I can build a custom search to use EA as a "Data Dictionary"

The following SQL works fine, but I'm hoping to find a method to return a match if the search term is contained within the Object.Name.

Can anyone suggest a method?

I've tried putting wildcards in the Search Term box, and tried
'<Search Term>'IN(t_object.Name) but haven't lucked onto a solution yet.

As an example, I'd like the search term "Order" to return "Sales Order" and "Order Profile".

The current SQL is provided for info.

Andy

SELECT t_attribute.ea_guid AS CLASSGUID, 'Attribute' AS CLASSTYPE,
t_object.Name as Table_Name,
t_object.Tagged,
t_attribute.Name,
t_attribute.Notes,
t_objectproperties.Property,
t_objectproperties.Value
FROM t_attribute, t_object, t_objectproperties
WHERE t_attribute.Object_ID = t_object.Object_ID AND t_object.Object_ID=t_objectproperties.Object_ID AND t_object.Name='<Search Term>'

[KP]

Try this:

Code: [Select]

AND t_object.Name LIKE '#WC#<Search Term>#WC#'
EA will replace #WC# with the correct wildcard character for the database you're using ('*' for MS Access/EAP files, '%' for everything else).

[AndyJ]

Nice!

Andy