Contents Now Platform App Engine Previous Topic Next Topic Default before-query business rule Subscribe Log in to subscribe to topics and get notified when content changes. ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Share Default before-query business rule You can use a query business rule that executes before a database query is made. Use this query business rule to prevent users from accessing certain records. Consider the following example from a default business rule that limits access to incident records. Name: incident query Table: Incident When: before, query Script: if(!gs.hasRole("itil") && gs.isInteractive()) { var u = gs.getUserID(); var qc = current.addQuery("caller_id",u).addOrCondition("opened_by",u).addOrCondition("watch_list","CONTAINS",u); gs.print("query restricted to user: " + u); } This example prevents users from accessing incident records unless they have the itil role, or are listed in the Caller or Opened by field. So, for example, when self-service users open a list of incidents, they can only see the incidents they submitted.Note: You can also use access controls to restrict the records that users can see. On this page Send Feedback Previous Topic Next Topic
Default before-query business rule You can use a query business rule that executes before a database query is made. Use this query business rule to prevent users from accessing certain records. Consider the following example from a default business rule that limits access to incident records. Name: incident query Table: Incident When: before, query Script: if(!gs.hasRole("itil") && gs.isInteractive()) { var u = gs.getUserID(); var qc = current.addQuery("caller_id",u).addOrCondition("opened_by",u).addOrCondition("watch_list","CONTAINS",u); gs.print("query restricted to user: " + u); } This example prevents users from accessing incident records unless they have the itil role, or are listed in the Caller or Opened by field. So, for example, when self-service users open a list of incidents, they can only see the incidents they submitted.Note: You can also use access controls to restrict the records that users can see.
Default before-query business rule You can use a query business rule that executes before a database query is made. Use this query business rule to prevent users from accessing certain records. Consider the following example from a default business rule that limits access to incident records. Name: incident query Table: Incident When: before, query Script: if(!gs.hasRole("itil") && gs.isInteractive()) { var u = gs.getUserID(); var qc = current.addQuery("caller_id",u).addOrCondition("opened_by",u).addOrCondition("watch_list","CONTAINS",u); gs.print("query restricted to user: " + u); } This example prevents users from accessing incident records unless they have the itil role, or are listed in the Caller or Opened by field. So, for example, when self-service users open a list of incidents, they can only see the incidents they submitted.Note: You can also use access controls to restrict the records that users can see.