Messages

1

General Board / Re: Package browser not showing all information

« on: July 13, 2016, 05:11:59 pm »

Can you please tell me what the (#Branch#) does in your Query. It seems to be useful for me, but I have each element matching the query six times in my results.

...
and package.Package_ID in (#Branch#)
...

Additionally here is my query:

Code: [Select]

select
c.ea_guid as CLASSGUID,
c.object_type as CLASSTYPE,
c.name as Name,
c.stereotype as Stereotype,
package.name as PackageName,
package_p1.name as PackageLevel1,
package_p2.name as PackageLevel2,
package_p3.name as PackageLevel3,
c.package_id AS Package
from (((((t_object c
inner join t_objectproperties op on op.Object_ID = c.Object_ID)
inner join t_package as package on c.package_id = package.package_id)
left join t_package as package_p1 on package_p1.package_id = package.parent_id)
left join t_package as package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package as package_p3 on package_p3.package_id = package_p2.parent_id)
where c.package_id in (#Branch#)
and c.stereotype = 'requirement'
and op.Property <> 'Target_Release'