Video Screencast Help

reports

Created: 13 Mar 2013 | 2 comments

good afternoon everyone

I need know how get product type, or if someone knows where is it (in that table)

thanks in advance

Comments 2 CommentsJump to latest comment

The Gaffer's picture

The product type is associated to a software product via a resource association. Here's a query which returns the software products and their types in the database.

select p.Guid [_ItemGuid]
,p.Name [Software Product]
,t.Name [Software Type]
from dbo.vRM_Software_Product_Item p
left outer join ResourceAssociation ra
on p.Guid = ra.ParentResourceGuid and ra.ResourceAssociationTypeGuid='ae4dbdf7-457b-4828-a83e-b64b91ae0e87'
left outer join [RM_ResourceSoftware_Type] t
on t.Guid = ra.ChildResourceGuid
order by 2
diana.mesta's picture

thank you very much the gaffer =)