Book Image

ServiceNow: Building Powerful Workflows

By : Tim Woodruff, Martin Wood, Ashish Rudra Srivastava
Book Image

ServiceNow: Building Powerful Workflows

By: Tim Woodruff, Martin Wood, Ashish Rudra Srivastava

Overview of this book

ServiceNow is a SaaS application that provides workflow form-based applications. It is an ideal platform for creating enterprise-level applications, giving requesters and fulfillers improved visibility and access to a process. ServiceNow-based applications often replace email by providing a better way to get work done. This course will show you how to put important ServiceNow features to work in the real world. We will introduce key concepts and examples on managing and automating IT services, and help you build a solid foundation towards this new approach. You will then learn more about the power of tasks, events, and notifications. We’ll then focus on using web services and other mechanisms to integrate ServiceNow with other systems. Further on, you’ll learn how to secure applications and data, and understand how ServiceNow performs logging and error reporting. At the end of this course, you will acquire immediately applicable skills to rectify everyday problems encountered on the ServiceNow platform. The course provides you with highly practical content explaining ServiceNow from the following Packt books: 1. Learning ServiceNow 2. ServiceNow Cookbook 3. Mastering ServiceNow, Second Edition
Table of Contents (39 chapters)
Title Page
Credits
Preface
Free Chapter
1
Module 1
36
Bibliography

One-to-many relationships in ServiceNow


One-to-many relationships are one type of parent-child relationship. They consist of one parent record, that is linked to many child records. This linkage is done via database table keys.

As we briefly mentioned in a previous chapter, records have a primary key (PK), and a foreign key (FK) column. The PK in ServiceNow is the Sys ID. Every record in ServiceNow has a Sys ID that is unique within the entire database. An example of an FK column, is any column which is meant to hold the PK of another record. These fields are Reference fields in ServiceNow. The Incident [incident] table for example, contains an FK column with the label Assigned to, and an actual column name of assigned_to. This is a Reference field that points to the User [sys_user] table, and contains the PK (Sys ID) of one of the records in that table.

Note

When you look at one of these FK/Reference fields on a form, you'll see the display value of the record that the Sys ID it contains corresponds...