*Note Word with red color
SELECT DP.vw_name AS 'DPRNo',Co.FullName AS 'PersonnelName',
Ves.vw_name AS 'VesselName',PE.vw_Role,PersonnelRole.Value AS 'PersonnelRole',
PE.vw_OnHireDate AS 'OnHire',PE.vw_OffHireDate AS 'OffHire'
FROM vw_personnelEngagementExtensionBase AS PE INNER JOIN
MetadataSchema.Entity AS Entity ON Entity.Name = 'vw_personnelengagement' LEFT OUTER JOIN
stringmap AS PersonnelRole ON
PersonnelRole.AttributeName = 'vw_Role' AND PersonnelRole.AttributeValue = PE.vw_Role AND
PersonnelRole.ObjectTypeCode = Entity.ObjectTypeCode LEFT OUTER JOIN
vw_vesselExtensionBase AS Ves ON Ves.vw_vesselId = PE.vw_BargeVesselId LEFT OUTER JOIN
contactBase AS Co ON Co.ContactId = PE.vw_PersonnelNameId LEFT OUTER JOIN
vw_dailyprogressExtensionBase AS DP ON DP.vw_dailyprogressId = PE.vw_DPRNoId
Query that i use to retrieve the dropdown or option list name. Using MetadataSchema.
This work for crm 2011. Reporting to retrieve the name.
0 comments:
Post a Comment