Viewing reports for OWNER ONLY

[gkeyes]

My system is setup for accessing and viewing for OWNER ONLY. In the reports I am creating I am seeing ALL the records. Is there a way I can incorporate that same type of "Owner" only access in reporting. Below is my is sample of my report code, so far.

SELECT leads.first_name, leads.last_name, leads.phone_work, leads.phone_mobile, leads.date_entered, leads.date_modified, leads.description, leads.account_name
FROM leads
WHERE leads.deleted = 0
ORDER BY leads.date_entered;

[Angel]

You'll need the ID value that corresponds with your user name, then modify this:

SELECT leads.first_name, leads.last_name, leads.phone_work, leads.phone_mobile, leads.date_entered, leads.date_modified, leads.description, leads.account_name
FROM leads
WHERE leads.deleted = 0
ORDER BY leads.date_entered;

to:

SELECT leads.first_name, leads.last_name, leads.phone_work, leads.phone_mobile, leads.date_entered, leads.date_modified, leads.description, leads.account_name
FROM leads
WHERE leads.deleted = 0
AND assigned_user_id = 'THE_ID_VALUE_FOR_YOUR_USER'
ORDER BY leads.date_entered;

[gkeyes]

Thank You, I will give this a try.