Book Image

Learning ServiceNow. - Second Edition

5 (1)
Book Image

Learning ServiceNow. - Second Edition

5 (1)

Overview of this book

This book is an updated version of Learning ServiceNow, that will cover the new and updated features of the ServiceNow platform. It will show you how to put important ServiceNow features to work in the real world, while introducing key concepts via examples of managing and automating IT services. It'll help you build a solid foundation of knowledge, and will demonstrate how to effectively implement and configure modules within ServiceNow. We'll show you how to configure and administer your instance, and then move on to building strong user interfaces and creating powerful workflows. We also cover other key elements of ServiceNow, such as notifications, security, reporting, and custom development. You will learn how to improve and automate your business' workflow and processes. By the end of this book, you will be able to successfully configure and manage ServiceNow like a pro.
Table of Contents (19 chapters)
Learning ServiceNow Second Edition
Contributors
Preface
Index

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 using database table keys.

As we briefly mentioned in a previous chapter, records have a primary key (PK), and a foreign key (FK) column; though they aren't called that in ServiceNow. The PK in ServiceNow is the Sys ID [sys_id] column. Every record in ServiceNow has a Sys ID that is typically unique within the entire database (though technically a primary key only needs to be unique within a table). 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...