Help with SQL Scratch pad

[whyamidoingthis]

I am trying to generate a SQL Scratch pad search that i can import into a template fragment that will search for a specific stereotype and keyword. I can get the correct output with the simple search tool, but cant find the necessary elements to call keyword in the sql scratch pad. What i have so far is:

SELECT t_object.name AS CLASSGUID, Object_Type AS CLASSTYPE, Name, Stereotype, Version FROM t_object Where Stereotype = "ActualResource"

I'm looking for a way to add keyword = "boat" or something like that so i get all the actual resources that are boats

[Geert Bellekens]

the keywords field is stored in PDATA5

Code: [Select]

SELECT o.name AS CLASSGUID, o.Object_Type AS CLASSTYPE, o.Name, o.Stereotype, o.Version
FROM t_object o
Where o.Stereotype ='ActualResource'
and o.PDATA5 = 'boat'
Geert

[qwerty]

You probably should use wildcards for the keywords since it's an arbitrary string.

q.