How to pull records from an existing table to a custom table?

[Arunima_12]

Trying to pull all records from catalog task table (sc_task) to a custom table (m2m_***)

From :

To: (Entry created in M2m table is manually done)

NOTE:  Opting for 'extends table' while creating the custom table did not work as sc_task is not extensible, and if extended with TASK table that is not pulling  SC task records anyway.

[Amit Verma]

Hi @Arunima_12 

Please check if below posts helps :

https://www.servicenow.com/community/now-platform-forum/copy-records-from-one-table-to-another-table...

https://www.servicenow.com/community/itsm-forum/extending-tables-from-task/m-p/569655#M141434

Thanks & Regards

Amit Verma

[Ankur Bawiskar]

@Arunima_12 

what's your business requirement here?

[Arunima_12]

Hi Ankur,

We are using this custom table as a related list on change request.
But when clicking on the EDIT button on related list we are not getting the sctask records on the custom table, because the custom table is falling somewhere in mapping with the main sc_task table.

In the above screenshot the sctasks numbers showing now under both lists are manual entries.