interview question

[chandan86patra]

Hi All,

I have some doubts related to interview questions :

1. What is the order of the execution order of ACL (read , write , create , delete)?

2. What is a global business rule, and how do you create one?

3. The two fields coalesce (like employee ID and mail ID) in the transform map. How will the data execute in the ServiceNow table?

Can anyone help relate this question it will be helpful for me 

Thanks and Regards,

Chandan Patra

[Shivalika · Accepted solution]

Hello @chandan86patra 

1)Whether Read,write, create, delete - it depends on the operation being performed by logged in user. But for any ACL it goes from "Most specific to most generic" Means first field level is analyzed, then row level is analyzed and then table level is analyzed. 

2)

A global Business Rule is any Business Rule where the selected Table is Global. Any other script can call global Business Rules. Global Business Rules have no condition or table restrictions and load on every page in the system. Most functions defined in global Business Rules are fairly specific, such as an advanced reference qualifier on one field of one form. There is no benefit to loading this kind of script on every page. 

Script includes only load when called. If you have already written a global Business Rule, move the function definition to a Script Include. The name of the Script Include must match the name of the function for the Script Include to work properly. There is no need to modify any calls to the named function.

3)If there are two fields coalesce on the table, they are connected by AND relation. If any of the field's value provided in excel sheet is not present in the table, then the whole row will be inserted. In a nutshell it matches on both the values. 

For your example, if mail id exists but employee ID does not, then also record will be inserted, if both exist only in that case the record is updated. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY