How to restrict user to see only records assigned to him??

[Shivani Khedek1]

Hi,

I have created a custom task table named "Record". In the assigned to field I have provided the user name.

That task should be assigned to the user provided in the "assigned_to" field. It is working fine, but the user is also able to see the tasks which are assigned to other users.

I have given the "itil" role to the user and my table can be access if the user has that "itil" role.

But the  concern is that the itil user can see all the tasks in the table instead of only tasks assigned to him/her.

Please suggest if there is any way to make the limit the tasks visible to "itil" user on the basis of tasks assigned to them.User should be able to see the tasks which are assigned to them and not the other tasks.

Please suggest, if I am doing anything wrong and how can we achieve this?

[Pranay Tiwari]

Hi Shivani,

Give this condition in ACL,it will work..!

operation read, then table_name.None

 By this only assigned user can see the record assigned to him.

Mark correct or helpful if it helps you.

Warm Regards,

Pranay Tiwari

| www.DxSherpa.com |

[Shivani Khedek1]

hey,

actually I have assigned an ITIL role for all my users who would be able to records in table. So being an ITIL user, he/she can see all records, and I want to restrict it to his/her records only.

Please suggest

[SanjivMeher]

You can add an onBefore Query business rule on your task table

script:

if (gs.hasRole('admin')==false)

             current.addQuery('assigned_to',gs.getUserID());

[Pranay Tiwari]

Hi Shivani,

I were do this task through ACL Only.

Follow below steps...

 In 1st Image i give some role to my table. 

 2nd image show the user role.

3rd image give the read accessibility of record's .

in 4th image we restrict user to see only assign incident.

 5th image show the user view,and he will see only assign incident only.

 6TH image is my table record.

Mark correct or helpful if it helps you.

Warm Regards,

Pranay Tiwari

| www.DxSherpa.com |

[Shivani Khedek1]

It worked ! 

Thank you so much.. 

Regards,

shivani