Why we extend table?

Go to solution
mukesh18
Giga Contributor

‎03-19-2020 12:18 AM

Hello Community,

I'm not clear about why we extend the table. Even if we insert records in the child table it gets populated in the base table.

please help me to get out of it.

 

Thanks In Advance!

0 Helpfuls
  • 5,733 Views
1 ACCEPTED SOLUTION

Go to solution
Mohit Kaushik
Mega Sage
Mega Sage
In response to mukesh18

‎03-19-2020 12:32 AM

Hi Mukesh,

Now in this case, if you see there will e different fields for Incident and Request. So will you keep all the fields in your task table records.

Like stage field is not required for incident but required for request. So when you will add this field to task it will display it for incident record and request record as well. This will only confuse the users and create complexity in the business flow.

So it is required to always extend the table if you want to use the default functionality of that table and want to customize it more instead of adding new fields to it.

 

Thanks,

Mohit Kaushik

Thanks,
Mohit Kaushik
ServiceNow MVP (2023-2025)

View solution in original post

11 REPLIES 11

Go to solution
Saurabh singh4
Kilo Guru

‎03-19-2020 01:48 AM

Hi Mukesh

 

Extending an existing ServiceNow table means the table you create will inherit the parent table’s columns as well as the table’s business logic. The most commonly extended table is the Task table.

Follow these steps to view a table’s columns:

  1. In the main ServiceNow Browser window, use the Application Navigator to open System Definition > Tables.
  2. Click a table in the list, such as Task, to open it for viewing.
  3. Scroll to the Columns section and examine the table’s columns.

Follow these steps to view the database schema for a table:

  1. In the main ServiceNow browser window, use the Application Navigator to open System Definition > Tables.
  2. Click a table in the list, such as Task, to open it for viewing.
  3. On the table record, scroll down to the Related Links and select the Show Schema Map link.
  4. Examine the schema to see the relationships between the selected table and other tables in the database.

Follow these steps to view information about the business logic for a table:

  1. In the main ServiceNow browser window, use the Application Navigator to open the list of records for the table using a module in the Application Navigator. If no modules exists or if you know the table name, you can enter <table_name>.list in the Application Navigator filter field. For example, task.list.
  2. Click a table record to open it for editing.
  3. Click the Additional actions button (Additional actions menu) and select the Configure > All menu item.
  4. Select each of the tabs to examine the existing business logic for the table.

     

    Graphic showing the tabs for a table’s business logic: Business Rules, Client Scripts, Dictionary Entries, Dictionary Entry Overrides, Notifications, UI Actions, Access Controls, UI Policies, Data Policies, Styles, and View Rules.

     

Create a Table Without Extending Another Table

Creating a table without extending an existing table means that the application developer has complete control over the table columns and the table’s business logic. This type of table is often used for tables containing reference/lookup data. For example, if you are building a flight tracking application, you might have a table that contains airport locations and airport codes.

ServiceNow adds 6 fields to all tables including those that do not extend an existing table:

  • Created by
  • Created
  • Sys ID
  • Updates
  • Updated by
  • Updated

Please my answer correct and helpful, If this helps you in any way thanks in advance

Saurabh

 

 

Go to solution
Le Son
Tera Contributor
In response to Saurabh singh4

‎07-26-2022 02:45 AM

when use customize and when use extend table?

0 Helpfuls