//SolutionName = solution name
select DISTINCT e.LogicalName ,l.label, s.UniqueName from entity e right join LocalizedLabel l
on e.entityid = l.objectid inner join SolutionBase s
on e.SolutionId = s.SolutionId inner join SolutionComponentBase sb
on sb.SolutionId = s.SolutionId where l.LanguageId=LangNumber
and l.ObjectColumnName ='LocalizedName' and s.UniqueName = 'SolutionName'
Enjoy,
Rami Heleg
No comments:
Post a Comment