function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
shashi kanaparthishashi kanaparthi 

query on user record not returning any records when logged in as partner community user

Hi,

The below query is returning zero records when i log in as partner community user. This query is being execute from a helper class which is being called from a trigger. The helper class and trigger are running in system mode.

Query below:
NameSet='Developer Test'
List<User> userList = new List<User>();
        userList = [Select Id, name from User where name in :nameSet]
system.debug('### SOQL Query is ####'+''+ [Select Id, name from User where name in :nameSet]);
when i use debug log for the user, the above soql query is not even being printed in the debuglog

Let me know what the issue could be.
       
Raj VakatiRaj Vakati
Try this  
String NameSet='Developer Test'
List<User> userList = new List<User>();
        userList = [Select Id, name from User where name =:nameSet]

or
  
Set<String> NameSet = new Set<String>();
NameSet.add('Developer Test');
List<User> userList = new List<User>();
        userList = [Select Id, name from User where name in :nameSet]
s

​​​​​​​