Web Screen Painter (WSP) does not allow modifying the new columns that were published.
After a site-defined schema has been published, web screen painter will consider it as a standard schema and will not allow any changes to the columns. To verify,
- Login to Web Screen Painter as Administrator.
- Go to Tools->Schema Designer and click on the custom column created (see Figure 1):
- In Figure 1, a column zTest was added to the CR object with data type as STRING and length as 150, however, web screen painter does not allow to modify the length.
- To modify the length of zTest, go to $NX_ROOT/site/mods and open wsp_schema.sch with a text editor (see Figure 2):
- Change the zTest length to 250 and click on File->Save to save the changes.
- Go to $NX_ROOT/site/mods/majic folder and open wsp.mods file with a text editor (see Figure 3).
- Change the length of zTest to 250. Click on File->Save to save the changes.
- Click on Start ->Run ->type cmd and click OK to open the command prompt.
- On command prompt type the command pdm_wspupd and hit enter.
- pdm_wspupd compares wsp_schema.sch with wspcol table in database and indicates the changes (Figure 4).
- Verify if the changes are correct and type Y to accept the changes.
- It updates the changes to the wspcol table (see Figure 5).
- Open the SQL Server Management Studio/ SQL Query Analyzer and run the command to update the column length.
Alter table Call_Req Alter Column ZTest nvarchar(250)
- Stop Service Desk Manager Services.
- In the command prompt run the command pdm_publish (see Figure 6):
- Start Service Desk Manager Services.