+ Start a Discussion

Join Query to Fetch the Data From Standard Object.

Hi All,


I am creating a visualforce page , inside it  I want to display the data based on the User Role.

I am using Standard Object User to create users. Now Once the page gets load I want to

display extra hyperlink to the User whose User Role is Administrator.

I am displaying the Welcome message to the all users to using {!User.FirstName}

But How can I solve the above problem.


One More query. How can I write SOQL query to join the Users & Profiles Object. I want to fetch the UserName from User whose Profile is System Administrator.



Brijesh Thakur