How CWM_Task table fields are associated with sn_cwm_columns_usage custom columns table.

MohitSaxena
Tera Contributor

3 weeks ago

Hi Everyone,

 

I have created a CWM board, under which I have created 15 Custom columns, as those records are created in sn_cwm_columns_usage table with column- column_001, column_002.. and so on. 

Now Ask is to show those 15 custom columns in CWMTask Form. 

 

Issue- When I add those column in the task Form, they are coming up with Column 001, Column 002.. so on, 

Not coming up with Lables. Could you please help me  with this, should I change the Column value? (that doesn't seem to be good solution to me)

 

 

Second Related Question: If these custom column are created in sn_cwm_columns_usage table, How they are associated with cwm_task table(as I can bring custom column in task form).

 

MohitSaxena_0-1791988969659.png

 

0 Helpfuls
  • 422 Views
1 REPLY 1

Madhav Bharadwa
ServiceNow Employee

2 weeks ago

sn_cwm_task table contains column_001 - column_100 which stores string values

sn_cwm_columns_usage table contains the details of type of column and label of the column

This data is used to modify the behaviour of the grid when loading cwm workspace. based on the configuration in sn_cwm_columns_usage table CWM Workspace will show dropdown or date or text or reference in the workspace

As this is not used by platform lists or forms, OOTB custom columns cannot be modified from the form component

0 Helpfuls