[Music] in order to subscribe to my channel please click here or click here please share comment and like my videos and channel hello guys welcome to SAS with service now this is service now system administrator training and this is part 8 this training has been recorded in Orlando version of ServiceNow before we start the training let me show you the topics of this complete training and this aids part of the training we will talk about tables and fields in ServiceNow tables and fields ServiceNow source data in the form of database structure and it has components like tables records and fields in this section we will learn about tables and fields in ServiceNow how data is stored in ServiceNow tables relationship custom and color tables we will also try to create new custom tables in this session ServiceNow data structure as I mentioned everything is managed wire database structure in service now you have tables which is a database component which stores records then you have records which are stored in a table and these records have fields which show the information about that particular racket and then you have lists which shows the records in a table the list of rackets what all rackets you have in that particular table that is what you can see in the list ServiceNow data related tables as a ServiceNow administrator you can access modules related to tables and columns under system definition in the application navigator you will find three different applications tables which have rackets for each table you have in your ServiceNow instance even if you have tables and ServiceNow but all those tables are basically have a different table where all those tables are mentioned that what all tables you have in your instance then we have tables and columns which shows an advanced view where you can see all the tables and their column details then you have dictionary which contains the definition of each table and filled in the database of your instance go to system definition application so I will type system and this type definitely you will automatically get the system definition application we will go to tables module this will show the list of all table records of your instance now this shows tables provided by ServiceNow and tables created by ServiceNow administrators as of now it is showing all the tables which are out-of-the-box because I have not created any custom table yet if I click any table record I can see the details of that table so let me go back and I will try to search for a user table so if I type here user and press ENTER I will get this user table I can see the details of this user table and some other configurations as well then you have tables and columns which shows additional details of tables and columns now if you select any table any table you have here then you can see all the columns and if you click any column maybe this one then you can see more details which is basically the dictionary of that field that is what you can see in tables and column you can also create new table from this view you can create new application you can search for some existing application you can browse applications you can also create indexing if I go little bit bottom here it says index creator so you can create indexing from different fields of a table now what exactly indexing is indexing is a way to optimize the performance of a database when query is processed overall indexing helps you to perform better searching because if you will have lot of data if you have lot of fields in that case you need to do indexing to improve the performance now indexing is not ServiceNow invented feature or world or terminology this is something used wherever you have databases even you have indexing in your Outlook and you must have seen some errors sometime whenever you type any word in Outlook it shows index is not completed yet you might see some kind of message in Outlook then we have dictionary which shows the list of all columns of all the tables of your instance have which is also called dictionary entry and these are all dictionary entries tables a table is a collection of records in the database where information can be entered tables have different rows and these individual rows correspond to a record in a table tables also have columns which correspond to a field on record or row as I mentioned row is a racket which shows the details of the racket in the form of fields and stores the data these are the fields on the form now apart from these fields of racket every record of a table in ServiceNow is also identified by a 32 character unified ID which is called sis ID and that's unique for every record of a table any table feels as I mentioned earlier field is a column of tables which stores the actual data it can be of different types like string choice reference true or false the major attributes of fields are filled label which is the display name of a field for end users feel the name which is kind of back a name of field and used in scripting as well and then we have field value which is the data for a racket stored in that particular field let's see incident table and its fields so go to tables module under system definition click on that search for incident table so I will type here incident here we have incident table if I click this it will open up the racket for incident table now if I go a little bit down these are all columns of incident table here you have related links now under related links you have this show list if I click this button this will show me the list of incident rackets that means the rackets which are in incident table and this shows some columns or fields you have on this view now these are the values in rows for individual incidents so all these you can see on these different fields you have here now this view which you can see here it's a default view users can also personalize this view by changing the columns so if I click here I can personalize this list that what all columns I want to see in this particular view let me open any incident now this is showing the details of this record on the form you were seeing the details in the list first but when you open that racket you can see the details of that particular record on the form now this is again not showing all the fields of the table the visibility of the fields on the form depends on the requirement you have from your customer so it can be different for different organizations now these individual columns or fields they store data for individual racket now as an admin you can configure these fields directly on the form so if you right-click on any field you will see some options now in order to configure this field configure the dictionary of this field you have to click on configure dictionary now this will open the dictionary rack head of that particular field now field has two types of name one is column label which is visible on the form to the users and it is also visible in the list as well and then we have column name which is the backand name and used in scripting as well you can see the type of field as well here now there are various types of field you can create in ServiceNow you can also make the fields let me read only and mandatory directly from dictionary and then you have some other options to configure the dictionary of a field for a particular table table relationships as you have different tables in ServiceNow these tables can also be related to each other in different ways the first relationship we have is one to many in which one table has some fields which are referencing to other tables like a reference fields or blight list fields as an example you can have multiple incidents as user table is on incident table referenced in caller field this way user table has one-to-many relationship with incident table then we have many to many relationship in which two or more tables are related to each other as an example group and roles table which are related to group roles table and lastly we have extended relationship in which one or more tables can be extended from another table which are also inherited the fields from the parent table so basically if you extend any table from any other table you also extend the fields as well created in parent table as an example you have task table an incident and change table are extended from task tables you will find some fields on incident chain tables which are inherited from task tables go to incident list so I will just type incident and here I have list of incidents now if I open any incident I can see this collar field now this collar field is basically referencing to user table that means user might have multiple incidents and this is one-to-many relationship with incident table for user table you can see this this particular record is coming from user table this is not an incident table then we have many to many relationship in that case you have to see group table so we have this group's table here then we have a role table now both are basically related to each other with many do many relationships in this table so we have this group roles table and you can see multiple groups which have multiple roles as well that means these have many to many relationship let's see extended table so if you go to incident table and if I open configuration of this table you will see this particular field extends table that means this table incident table is extended from task table that means this table is called extended table and that's how it's called extended relationship similarly you also have problem so if I look for problem record you will see that that is also extended from task table if I go to table configuration you can see it says X ends table and it is extending tasks table as well and I can open this particular table and you have all these fields so remember as I told you that this is a task table now incident and problem and other tables they are extending from TAS table so whatever fields you have in this table you will have those fields on these extended tables as well like incident and problem types of tables ServiceNow has different types of tables which are categorized as per the structure they have ServiceNow administrators and developers need to know which type of table they want to meet the business requirement before starting the development and creation of a table these tables are base tables extended tables core tables and custom tables base tables a base table is a table which is not extended from any other table and referred to as a parent table or parent class but extends other tables as an example task table which is not extended from any other table but extends table like change incident problem extended tables a table which is extended from another table is called extended table like we have change table incident table problem table which are basically extended from task table and the table which is getting extended is referred as child class and the one from which these tables are extended is referred as parent class another example of base table is Kahn aggression item table from which tables like hardware software applications are extended core and custom tables core tables are created by ServiceNow which are in the base system and custom tables are tables which are created by developer or administrator the example of code tables are tasks change incident an example of custom tables which are created by developers or administrators like leave mapping table or any metrics table like approval metrics table in order to see base tables you can go to tables module and you can search for the tables which are not basically extended we are not getting extended from any other table so if I go to this column extends table and I put a filter here that means I just put show matching that means wherever extended from is empty this extends table is empty in this case you will see all the tables which are basically not extended and you will also find tasks table in it so let's see if I search for it yes you have task table here and you can see X ends table is empty so that's how you can search for base tables now tables like incident change problem they are called tables so if I click here again and just look for incident table so I have this incident table now these are core tables which came from ServiceNow directly out of the box for friend applications of ServiceNow so all the applications which are directly coming from ServiceNow out-of-the-box those are core tables now let me create a new custom table so that's how you will learn what exactly the custom table is because custom table is not available in ServiceNow our other box you have to create ServiceNow administrator service now developers have to create as per the business requirement they get from different customers or clients so as you can see I have this option here so I will also create a new table and show you to add few fields and show you that how exactly it works when you create a new table what kind of fields you get automatically created when you create a new custom table so if I click on this button new you will see this table form here I can give the label name now as of now I am just giving demo space YouTube now the functionality we have in ServiceNow for custom table when you press tab it will automatically create a name for you you can see here but the one thing to see but one thing to focus on is naming convention you can see as I have created this custom table it has automatically added you underscore so wherever you see you underscore that is a custom table if it's a global scope we have we have never talked about scope but ServiceNow has two different scopes global and private scope as well but even if it's a custom table for private scope in that case you will see the identifier for private scope as well so here it it shows the name of the table now by right creating it if you want to extend it you can extend it from task table and I will show you it will inherit all the fields so what I will do first I will just create a random table without extending it from task table I can also create the module for any application if I want that is something you can select here if you will uncheck it we'll just create a table it will not create that module in Application Navigator under any application so I'm just unchecking it for now and then here I have dictionary entries that means you can create columns fields for your table so for example I will just add name now I will make it the type as strings as I mentioned you can create different types of fields so let me show you them see we have 52 types of fields you can create so as of now I will just select a string press ENTER I will get string here I will select it no reference max length will be automatically selected I don't want any default value for now and I can just save it before that if you see we have some other tabs like controls if it is extensible do you want to do you want to make it extensible that means some other tables can extend it that is something you can check this box if you wanna some naming convention numbering automatically there is something you can mention here this is something Rose specific if you want to provide any role so that these users if users will have this role then only they will be able to access the table may be read access write access or delete access so I will show you when you will create or save this particular racket then we have application access then how people can access this table that kind of configuration you can mention here now let me just save it first once this is saved it is saved and if you will go to columns you will see some extra fields but you didn't even create yourself now these fields will be created automatically every time you will create a new table your custom field will definitely be there but these six fields at the top will be created automatically like created by which shows the person who has created this racket that is what it shows then we have created the person when exactly this racket was created the whatever record will be created it will show that particular time then we have society the the one unique ID which we were talking about for each racket then we have updates if we have any updates to the to the racket then we have updated by then we have updated when this racket was updated and then we have name which is our custom feed and you can add multiple fields you want you can add here as per your business requirement now as of now it shows these fields now let me create another table which you will extend from task table and you will see love difference so if I click on new again I will just close this message here I will select just demo YouTube tasks if I press ENTER it will select the name you can also change it if you want now the important part is here extends table so let me extend it from task now you will see the magic which I was talking about that it inherits all the tables from parent table that means this parent table we are talking about so I'm not going to create my custom field for now and I'm not going to create any module well let's let's do that maybe you will be able to see that so maybe we will add this module two maybe self-service let's see if we can see that so I have added this to self-service and I'm going to save this but before that let me check this Auto number as well we will have dem and that's it and I will just save this once I will save this you will see all those fields let's go to columns you can see we got these 69 fields which we didn't even create ourselves now these fields are basically from TAS table so that is what we were talking about because this has extended this table is basically being extended from TAS table so it will inherit all the fields of tasks table let's add some custom fields on code tables like incident change problem so if I go to tables let me search for any table maybe like change I have this change request so for change management we have this change request table so you have that opportunity if I go a little bit bottom here I can add any new field and I can make it visible on the form as well so if I show you show form as of now we have these fields now as a ServiceNow administrator as a service not developer if you have a new requirement to add any new field so what he can do you can just go here go to form layout and I can create any new field like maybe I will just do you test make a string for now I will click on add now I will show you how exactly it will be added in the table as well so as of now I am creating it from the form layout but I will just show you so I have here and I will save it it is succeeded I will close you can see I have this new field test here the custom field which we just created now I can show you this field in the table as well so let me go to the table so here is the table we have and if I see yep you can see here we have that test table you can delete it as well if you want so if I just cross this here and save it that field will be deleted it's done it's deleted and if I go at the bottom here and if I click on show form then you will not see that field anymore you can see that feel is gone because you have deleted it from that particular view from table configuration view table schema map schema map is a graphical representation of tables related to other tables it shows the relationship between the tables map you can go to tables and columns under system definition select any table let's search for incident table so if I select incident I have this incident table now here you have a schema map so if I click on schema map I should be able to see the schema map for incident table now in this map it shows different configurations like you have reference tables referencing tables extended tables show access to X ending tables as well that is something you can select here so you can see like this incident is basically you have incident tasks you have security incident that means it is the referencing table that means these tables basically they have a reference of incident table on this table that is what it is talking about then we have other tables you have like configuration item you have change request where exactly you are referencing incident that is something you can see that means on incident you have these relationships as well if you want to see the columns you can see that from here that's how you can see lot of details and relationships directly from table schema map and that's that's reason is called graphical representation that what all fields you have what all columns you have how exactly different tables are related to each other that is something you can see in this particular view