salesforce.com‎ > ‎code‎ > ‎

[SOQL]有効ユーザのいるプロファイル

2011/10/05 9:56 に Makoto Fukasu が投稿   [ 2013/05/18 10:17 に更新しました ] 
SELECT Profile.Name, Count(Name) Cnt
FROM User
WHERE IsActive = true
GROUP BY Profile.Name
ORDER BY Profile.Name
SELECT Name
FROM Profile
WHERE Id IN (
  SELECT ProfileId
  FROM User
  WHERE IsActive = true
)
ORDER BY Name
Comments