Thursday, May 21, 2015

Database: Command to get Entities list related to Solution

//LangNumber  = 1031, 1036, 1037 etc... language code
//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