How to find the extended tables which are having the custom field that was there in task??

KM SN
Tera Expert

I have a business service field in task but someone else have created same field which starts with "u_" but now i need to remove the field but removing directly from task may effect the child tables extended from task where they might have used the custom field instead OOB field.

What is the best practice to go further?

How to find the child tables at a time which are  using custom field? 

 

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @KM SN 

 

Try like this

LearnNGrowAtul_0-1704361750887.png

 

 

Go to Dictionary and search for field

 

You will get some information.

 

Also don't remove the field directly, take the data back up and then remove and bring the data in OOTB field. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @KM SN 

 

Try like this

LearnNGrowAtul_0-1704361750887.png

 

 

Go to Dictionary and search for field

 

You will get some information.

 

Also don't remove the field directly, take the data back up and then remove and bring the data in OOTB field. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Anil Lande
Kilo Patron

Hi,

Follow below steps:

1. You can open task table list using task.LIST
2. 
Add custom field and Task type fields on list view by personalising list

3. Use filter out option for your custom field column where value is empty. (or apply filter like Business service IS Empty)

4. You will get the list of all tasks where custom field have some value selected by user.

5. Now group by 'Task type' Column.

 

This will show the records grouped by child table (like incidents, problems etc) where this field is used. 

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande