SQL: package name like object alias + string?

[Hurra]

Hello!

I've run in to some problems with a SQL query.

I have defined some roles to an OperationalPerformer (UAF) in a package named x Organisation where x is the alias of the element OperationalPerformer.

I find all the elements I need with

Code: [Select]

select o.ea_guid as CLASSGUID, o.Object_Type as CLASSTYPE, o.Name, p.Name as PName
from t_object o, t_package p
where p.Package_ID = o.Package_ID and p.Name = "x Organisation"

I want to make this more generic for documentation. Therefore my thought was I add the element of interest and use its alias, something like:

Code: [Select]

select o.ea_guid as CLASSGUID, o.Object_Type as CLASSTYPE, o.Name, p.Name as PName, o2.Alias
from t_object o, t_package p, t_object o2
where p.Package_ID = o.Package_ID and o2.Object_ID = 8451 and p.Name = o2.Alias + ' Organisation'
and setting the o2.Object_ID to #OBJECTID#.

However I can't get this to work. I tried all kinds of combinations with parenthesis, brackets, '', "", wildcards (using like).

I guess this has a simple solution, but my SQL skills are not the best.

Thank you!

[qwerty]

I'm also no SQL guru but string operations are likely to b RDBMS dependent. Google for something like "sql server string concat" which gives you plenty of results.

q.

[Hurra]

I'm also no SQL guru but string operations are likely to b RDBMS dependent. Google for something like "sql server string concat" which gives you plenty of results.

q.

Thank you!