Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 1st, 2012  |  syntax: None  |  size: 1.29 KB  |  hits: 18  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SOQL - Querying for a list of users the current user is following
  2. List<User> Following = [SELECT Id, Name, SmallPhotoUrl
  3.   FROM User
  4.   WHERE Id IN (
  5.       SELECT ParentId
  6.       FROM EntitySubscription
  7.       WHERE SubscriberId = :UserInfo.getUserId())
  8.     AND Id != :UserInfo.getUserId()
  9.   LIMIT 96];
  10.        
  11. List<User> Following = [SELECT Id, Name, SmallPhotoUrl
  12.   FROM User
  13.   WHERE Id IN (
  14.       SELECT ParentId
  15.       FROM EntitySubscription
  16.       WHERE SubscriberId = :UserInfo.getUserId()
  17.       LIMIT 1000)
  18.     AND Id != :UserInfo.getUserId()
  19.   LIMIT 96];
  20.        
  21. List<EntitySubscription> sub = [SELECT ParentId
  22.   FROM EntitySubscription
  23.   WHERE SubscriberId = :UserInfo.getUserId()
  24.   LIMIT 1000];
  25. List<Id> ids = new List<Id>();
  26. for(EntitySubscription s : sub){
  27.     ids.add(s.ParentId);
  28. }
  29. List<User> Following = [SELECT Id, Name, SmallPhotoUrl
  30.   FROM User
  31.   WHERE Id IN (:ids)
  32.     AND Id != :UserInfo.getUserId()
  33.   LIMIT 96];
  34.        
  35. Invalid bind expression type of LIST<Id> for column of type Id
  36.        
  37. WHERE Id IN (:ids)
  38.        
  39. WHERE Id IN :ids
  40.        
  41. List<EntitySubscription> sub = [SELECT ParentId
  42.   FROM EntitySubscription
  43.   WHERE SubscriberId = :UserInfo.getUserId() AND ParentId != :UserInfo.getUserId()
  44.   LIMIT 1000];
  45.  
  46. Set<Id> ids = new Set<Id>();
  47.  
  48. for(EntitySubscription s : sub){
  49.     ids.add(s.ParentId);
  50. }