Layton ServiceDesk - Settings - Global List View - End User Request
From Layton Support
Removing the Change Request Status Button Column
The End User Request form has four button columns by default:
Tasks
Comments
File:Button attachment 16.png Attachments
Change Request Status
To remove the Change Request Status button column:
- Go to Administration > Global List Views > End User Request.
- Click any Change Request Status button. A settings page will open.
- In the settings, change the Column Width to 0 Pixels. Click Save.
The column will disappear from the request list view.
Restoring the Change Request Status Button
Restoring the button requires a SQL query. Note that this will reset all the columns, so any changes you've made other than the removal of the Change Request Status button will be lost.
- Connect to the LaytonServiceDesk database in SQL Server Management Studio.
- Click the New Query button.
- Choose LaytonServiceDesk in the Available Databases drop-down menu.
- Copy and paste the following query into the query field and execute it:
UPDATE resultsetprofile
SET sys_resultsetprofile_xml = '
<request pagecolor="#EEEEEE" toolboxtop="48" toolboxleft="1488" table="request" backimg="" height=""><label1 top="32" left="536" font-family="Verdana" font-size="18" color="#003366" font-bold="false">Template:Requests</label1><filter1 font-family="Verdana" font-size="11" color="#000000" userreq="false" caption="" tabindex="" left="872" top="24" width="300">Requests Filter</filter1><resultset top="72" left="24" maxrows="18" width="1149" height=""><field1 heading="ID" font-family="Verdana" font-size="11" color="#000000" width="5%" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_request_id</field1><field4 heading="Date" font-family="Verdana" font-size="11" color="#000000" width="15%" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_requestdate</field4><field2 heading="Template:Requesttype" width="19%" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_requesttype_id</field2><field5 heading="Problem Summary" font-family="Verdana" font-size="11" color="#000000" width="18%" align="left" headingalign="left">sys_problemsummary</field5><field6 heading="Priority" font-family="Verdana" font-size="11" color="#000000" width="10%" align="center" headingalign="center">sys_requestpriority</field6><field3 heading="Status" width="10%" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center">sys_requeststatus</field3><actionlink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/tasks_16.png" linkhasitemsimg="~/Application_Images/16x16/task_hasitems.png" linkinactiveimg="" linkimgalt="Template:Actions" linkhasunreaditemsimg="">View</actionlink><commentlink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/Comments_16.png" linkhasitemsimg="~/Application_Images/16x16/Commentshasreaditem16px.png" linkinactiveimg="" linkimgalt="Template:Comments" linkhasunreaditemsimg="~/Application_Images/16x16/Commentshasunreaditem16px.png">Comments</commentlink><attachlink width="5%" heading="" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/attach_16.png" linkhasitemsimg="~/Application_Images/16x16/attachhasitems_icon_16px.png" linkinactiveimg="" linkimgalt="" linkhasunreaditemsimg="">Attachment</attachlink><opencloselink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="application_images\16x16\Request_Open.png" linkhasitemsimg="" linkinactiveimg="" linkimgalt="" linkhasunreaditemsimg="">Open Close</opencloselink></resultset></request>
'
WHERE sys_resultsetprofile_id = 'enduserrequest'
Now the default column configuration has been restored.