Querying recent Contact for the Owner of User logged in

Question

Hi This query doesnt work for me, I dont know what I am missing that I cant query the recent Contact's entry by user that just logged in to salesforce account.

Id accountid = userinfo.getProfileId();
     myConn = [SELECT Id, Name, Account.Name , Accountid 
                         from Contact 
                         WHERE Id = :accountid ORDER BY  Name ASC Limit 10];

Answer 1

Your existing query is trying to match the Contact ID (starts with 003) with your User ID (starts with 005). Your list will never show a matching record.

You need to change your query to link the Owner ID to the current user. That will give you a matching value, if there are any contacts that are linked to that owner.

myConn = [
    SELECT Id, Name, Account.Name , Accountid 
    FROM Contact 
    WHERE OwnerId = :userinfo.getUserId()
    ORDER BY  Name
    ASC LIMIT 10
];