How can I pull data from sc_task table into a new custom table ?

[Arunima_12]

I have 2 query.

1. How can I pull the list of all catalog task records to a custom table (m2m*****) from main sc_task table ?
     The inputs created in the custom table as show in screenshot is manual entry as of now.

2. This custom table is being used as a related list under change request form, when clicked on 'Edit' for this related list I am getting the sys_id of the catalog tasks listed in the custom table. How to resolve this ?

The collection should show the SCTASK by number but it is showing as sys_id how to fix this ??

[Danish Bhairag2 · Accepted solution]

Hi @Arunima_12 ,

The answer to your 2nd question is :

Go to ur custom table & right click on any column select configure- table.

Once the table opens set the number field Display value to true & update it. This can be performed from the list view itself. Once done u will be able to see number instead of sys I'd.

For 1st case u should have extended ur custom table with task table do that it could contain all the existing task values along with the manually created ones.

Thanks,

Danish

[Danish Bhairag2]

Hi @Arunima_12 ,

Apologies for the confusion it should be task table which u need to extend. It does contain the catalog task records as well. Adding snip for your reference.

Thanks,

Danish

[Arunima_12]

Hi Danish,

This solution is not helping as I am not getting the sctasks pulled into my custom table even after selecting TASK table under extends table while creating the custom table.

Main table :

Custom table:

Custom table list view: