good afternoon everyone
I need know how get product type, or if someone knows where is it (in that table)
thanks in advance
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
thank you very much the gaffer =)