To query User Profile Name from Contact, It is Possible
Example Query Like : select Id,FirstName,LastName,(Select Id,Name,Isactive,Profile.Name from user) from Contact
Thanks Nagarjuna
To query User Profile Name from Contact, It is Possible
Example Query Like : select Id,FirstName,LastName,(Select Id,Name,Isactive,Profile.Name from user) from Contact
Thanks Nagarjuna
Query for profiles of users
SELECT Id, Firstname, Lastname, ProfileId, Profile.Name FROM User
Query Last modified user from Contact
SELECT ID, Firstname, Lastname, LastModifiedBy.Profile.Name FROM Contact WHERE ID = :YOUR_CONTACT_ID
Query related users of contacts "Community users"
SELECT ID, ContactId, Contact.Firstname, Contact.Lastname, ProfileId, Profile.Name FROM User WHERE ContactID = :YOUR_CONTACT_ID
Try this :
for( Contact c : [select Id,FirstName,LastName,LastModifiedBy.Name, LastModifiedBy.Profile.Name from Contact limit 1]){
System.debug('cont ' + c.FirstName + ' prof '+ c.LastModifiedBy.Profile.Name);
}