Every now and then I find myself debating with a friend or colleague on whether we should use ACL or Business rules query.
Personally, I think the use of business rule query should be minimised. if you think about it, ACL called ACL for a reason! your security admin is the only one who can change ACL where anyone in your organisation with personalize_rules role can play with a query business rule that can be integral to your team.
again, I am not saying never use query business rules , I am just saying it should be minimised.
Here is when you shouldn’t use query business rules
- Your query BR is going to run on large table.
- Your query BR might contain a lot of OR clauses or LIKE operator.
- You are not concern about your instance performance.
In Quebec release, ServiceNow introduce new capability to enable users to insert multiple records into a staging table and trigger a transformation that is based on predefined transform maps in a single API request. In this post i am going to use the Insert Multiple REST API end point.
First thing, I am going to structure my JSON, I use company.do?JSONv2 to help me structure my JSON
Continue reading “Quebec Tour Part 3:Import Set REST API – Insert Multiple”
I am continuing my Quebec tour, today I am going to look into ‘Issue rating’ which is available on Issue Triage table(sn_grc_advanced_issue_triage). here is how i am going to use it:
Continue reading “Quebec Tour Part 2”