Restricting Hardware table data visibility based on location

[FlaviaRoshni]

Hi!

I'm trying to restrict my Hardware table data (alm_hardware), based on the logged in user's location.

For example:

Say Hardware A, B and C; Location 1 and 2; User x and y;

Hardware A and B is in Location 1; Hardware C is in Location 2;

User x is in location 1, user y is in location 2

If user x login into ServiceNow portal they should only see the Hardware Asset details of A and B in the alm_hardware.

If user y login into ServiceNow portal they should only see the Hardware Asset details of C in the alm_hardware.

How do I achieve this?

[Harish Bainsla]

Create Field Level Acl and in advance write script

[Rajat15]

Instead of ACL try DATA LOOKUP. They are easy to configure and more user friendly

[Samaksh Wani]

Hello @FlaviaRoshni 

Plz Mark my Solution as Accept and Give me thumbs up, if you find it helpful.

Regards,

Samaksh

[manjusha_]

@FlaviaRoshni 

1.When you need to hide/show  specific fields for some users ,you should go with ACL

2.Here you need to hide records based on logged in user location 

3.To achieve your requirement you have to go with the before query business rule 

Refer below  knowledge article provided by Servicenow 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0523826

Let me know if you need more help

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact

Thanks,

Manjusha Bangale

[FlaviaRoshni]

Thank you! It helped!