How to prevent users from seeing other RITM request by going into sc_req_item.list

[Peter Williams]

Good Day, 

i need to be able to restrict users that is non-itil to prevent them from seeing other ritm request when they go into sc_req_item.list

at the moment they can see this:

i want them to only see items they submitted or of they are apart of the watch list.

i tried the ACL but it doesnt filter the list for it

how can i do this please?

[Peter Williams]

sorry one more thing

i am trying to filter out roles via the items they should see plus if they opened it

i tried this but didnt work

(function executeRule(current, previous /*null when async*/) {

if (!(gs.hasRole("itil")||gs.hasRole("Finance_Access")||gs.hasRole("EIF_access") || gs.hasRole("Office_Facilities_access")) && gs.isInteractive()) {

  var u = gs.getUserID();

  var qc = current.addQuery("request.requested_for", u).addOrCondition("opened_by", u).addOrCondition("watch_list", "CONTAINS", u);

    gs.print("query restricted to user: " + u);

}

    if(gs.hasRole("Conference_centre")&&gs.isInteractive()){

      var qc = current.addQuery("request.requested_for", u).addOrCondition("opened_by", u).addOrCondition("watch_list", "CONTAINS", u).addOrCondition("item", "Copy-Print (Multitech)").addOrCondition("item","Messaging Service");

    }

})(current, previous);

[Peter Williams]

ive also tried

      var qc = current.addQuery("request.requested_for", u).addOrCondition("opened_by", u).addOrCondition("watch_list", "CONTAINS", u).addOrCondition("cat_item.name", "Copies-Impression").addOrCondition("cat_item.name","Copy-Print (Multitech)");

[Peter Williams]

amazing it works perfectly thank you very much

[jMarshal]

There is also a specific feature that ServiceNow provides for exactly this, no need to write (potentially) complicated, custom access control conditions.

Exploring Data filtration (servicenow.com)

[Peter Williams]

how do i go about doing that i am tryin to but i dont see that option in servicenow