Unable to see field "updated on" when merged multiple tables in database view

VIKAS MISHRA
Tera Contributor

I have merged 7 tables and created one database table and i observed that we can not see all the fields from all the table in the database view, for ex i wanted to add field "Updated on" from time_card table. but in Geyer icon in list view its not visible. 

Please suggest how to add that.

 

VIKASMISHRA_1-1741149933254.png

 

VIKASMISHRA_2-1741149969694.png

 

 

 

 

 

1 ACCEPTED SOLUTION

@VIKAS MISHRA 

go inside that view table, there you will find related list to add view fields

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

3 REPLIES 3

Ankur Bawiskar
Tera Patron
Tera Patron

@VIKAS MISHRA 

Did you add that field under the view table as View field for time_Card table?

Only fields added as view fields under view table can be selected

Add that and then logout and login and verify

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar 

How can we add any field in view table as a view field, please suggest me the steps for the same.

Because when i am clicking on geyer icon its not showing me that field.

@VIKAS MISHRA 

go inside that view table, there you will find related list to add view fields

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader