EA Package Hierarchy

[Tehila1]

Hello!

I would like to get a list of package directly owned elements of a package.

When I extract the information by the following expression I get all package's owned elements- but not only the directly owned.
For example-  an Activity under a directly-owned UseCase element.

Code: [Select]

SELECT t_object.Object_ID FROM t_object WHERE t_object.Package_ID=MyPackageID.PackageID;
When I do that like this:

Code: [Select]

SELECT t_object.Object_ID FROM t_object WHERE t_object.ParentID=MyPackageID.PackageID;
I get no elements at all!

Any ideas?
Thanks in advance!

[Uffe]

Elements in a hierarchy are, of course, all located in the same package. But you're almost there.

The element's parent ID is in fact the containing element. If the element is contained directly within the package, ParentID is 0. So to find only elements contained directly within the package:

Code: [Select]

SELECT *
FROM t_object
WHERE t_object.Package_ID = ThePackageIdYoureLookingFor
AND t_object.ParentID = 0
/Uffe

[Tehila1]

Great!

Thanks a lot, Uffe!

[motivatedgorilla]

How can I get the package ID for a given package name? For example if I ave packages ABC,DEF,etc how can I find out their package ID. Secondly what if I have 2 or more packages with the same name?

[qwerty]

Code: [Select]

SELECT t_package.Package_ID FROM  t_package WHERE t_package.Name = "..."If you have the package twice you get two records. Then it's up to you to decide...

q.