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 · 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

[Arunima_12]

Thanks Danish, the solution for 2nd question is helpful and fixed now.

For the 1st case issue, do I need to delete the table for now and create newly to get that option to extend the the custom table, as I am not getting a queue where from to extend the custom table now.

[Danish Bhairag2 · Accepted solution]

Hi @Arunima_12 ,

Yes while creating a new table we do get the field of Extend Table where u can select the Task Table in it & create the custom table.

So if your work is still in development phase then yes u can go ahead n delete it n create a new one

Thanks,

Danish

[Arunima_12]

Hi Danish,

Seems like the Catalog task table is not extensible, and hence extending the table to a custom table is not a way out now.
Can you suggest how can we fix on this? But we are not wishing to accept any changes made on a OOB script.

Regards,
Arunima